rubberduckies
rubberduckies
Explore posts from servers
DTDrizzle Team
Created by rubberduckies on 8/20/2024 in #help
trouble creating Enum
it appeared on migration yes
8 replies
DTDrizzle Team
Created by rubberduckies on 8/20/2024 in #help
trouble creating Enum
export const subscriptionPlanEnum = pgEnum('subscription_name', paymentPlansNames);
export const frequencyEnum = pgEnum('frequency', ['monthly', 'yearly']);
export const subscriptionPlanEnum = pgEnum('subscription_name', paymentPlansNames);
export const frequencyEnum = pgEnum('frequency', ['monthly', 'yearly']);
8 replies
DTDrizzle Team
Created by rubberduckies on 8/20/2024 in #help
trouble creating Enum
I forgot to export the enums
8 replies
DTDrizzle Team
Created by rubberduckies on 8/20/2024 in #help
trouble creating Enum
Thank you for the quick reply, i figured it out though
8 replies
DTDrizzle Team
Created by Daniel Drozdov on 6/7/2024 in #help
Not sure why we need to make relations when we have foreign keys?
well, i like doing it as i do, to each its own 🙂
16 replies
DTDrizzle Team
Created by HighTouch on 6/19/2024 in #help
Not enough information to infer relation with self-one-To-Many relation
i was also in need of this, thanks
3 replies
DTDrizzle Team
Created by Daniel Drozdov on 6/7/2024 in #help
Not sure why we need to make relations when we have foreign keys?
@A Dapper Raccoon, @Daniel Drozdov , I'm not sure if this is the real origin story for drizzle to include "relations"but certain cloud database providers, like Neon, which was all the rage a few months ago, don't (or at least didn't) allow for foreign keys in their postgres offer. Relations are a way to mimic that
16 replies
DTDrizzle Team
Created by Daniel Drozdov on 6/7/2024 in #help
Not sure why we need to make relations when we have foreign keys?
No description
16 replies
DTDrizzle Team
Created by Daniel Drozdov on 6/7/2024 in #help
Not sure why we need to make relations when we have foreign keys?
I use relations without foreign keys
16 replies
DTDrizzle Team
Created by rubberduckies on 6/17/2024 in #help
duplicate key value violates unique constraint when trying to insert
3 replies
DTDrizzle Team
Created by rubberduckies on 5/29/2024 in #help
using array of ids as a where clause, using magic sql operator
it works!!! Thank you so much
11 replies
DTDrizzle Team
Created by rubberduckies on 5/29/2024 in #help
using array of ids as a where clause, using magic sql operator
@crawl trying it now
11 replies
DTDrizzle Team
Created by rubberduckies on 5/11/2024 in #help
relations to the same table
thank you
9 replies
DTDrizzle Team
Created by rubberduckies on 5/11/2024 in #help
relations to the same table
No description
9 replies
DTDrizzle Team
Created by rubberduckies on 5/11/2024 in #help
relations to the same table
it just "is"
9 replies
DTDrizzle Team
Created by rubberduckies on 5/11/2024 in #help
relations to the same table
hey. no, it's not, but that has never been a problem
9 replies
DTDrizzle Team
Created by rubberduckies on 7/10/2023 in #help
postges, auto-generated uuid as primary key
thank you so much
12 replies
DTDrizzle Team
Created by rubberduckies on 7/10/2023 in #help
postges, auto-generated uuid as primary key
awesome, it's working
12 replies
DTDrizzle Team
Created by rubberduckies on 7/10/2023 in #help
postges, auto-generated uuid as primary key
ChatGPT tells me that, but it only mentions UUID v4, i don't know the differences
As of my knowledge cutoff in September 2021, the latest version of the `uuid-ossp` extension available in PostgreSQL is version 1.1, and it provides the UUID v4 functionality. However, there might have been updates or changes since then.

To enable the `uuid-ossp` extension in your AWS RDS PostgreSQL instance, you can follow these general steps:

1. Connect to your AWS RDS PostgreSQL instance using a PostgreSQL client tool or the AWS RDS console.

2. Open a database session with administrative privileges (e.g., with a user having the `rds_superuser` role).

3. Run the following SQL command to enable the `uuid-ossp` extension:


As of my knowledge cutoff in September 2021, the latest version of the `uuid-ossp` extension available in PostgreSQL is version 1.1, and it provides the UUID v4 functionality. However, there might have been updates or changes since then.

To enable the `uuid-ossp` extension in your AWS RDS PostgreSQL instance, you can follow these general steps:

1. Connect to your AWS RDS PostgreSQL instance using a PostgreSQL client tool or the AWS RDS console.

2. Open a database session with administrative privileges (e.g., with a user having the `rds_superuser` role).

3. Run the following SQL command to enable the `uuid-ossp` extension:


sql CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
This command creates the extension if it doesn't already exist in the database.

4. Verify that the extension has been installed by running the following command:


This command creates the extension if it doesn't already exist in the database.

4. Verify that the extension has been installed by running the following command:


sql SELECT * FROM pg_extension WHERE extname = 'uuid-ossp';
If the installation was successful, you should see a row returned with the extension details.

Please note that the availability of specific extension versions can depend on the PostgreSQL version that is running on your AWS RDS instance. Additionally, if there have been updates or changes to the `uuid-ossp` extension since my knowledge cutoff, you might need to adapt the instructions accordingly. It is recommended to consult the official AWS RDS documentation and the PostgreSQL documentation for the most up-to-date and specific instructions for your setup.
If the installation was successful, you should see a row returned with the extension details.

Please note that the availability of specific extension versions can depend on the PostgreSQL version that is running on your AWS RDS instance. Additionally, if there have been updates or changes to the `uuid-ossp` extension since my knowledge cutoff, you might need to adapt the instructions accordingly. It is recommended to consult the official AWS RDS documentation and the PostgreSQL documentation for the most up-to-date and specific instructions for your setup.
12 replies
DTDrizzle Team
Created by rubberduckies on 7/10/2023 in #help
postges, auto-generated uuid as primary key
i did
12 replies