nr7751
Explore posts from serversDTDrizzle Team
•Created by Brokenwind on 6/18/2024 in #help
Can't migrate on vercel postgres
@Brokenwind , I solved the issue. I haven't connected today. But yesterday was working fine
10 replies
DTDrizzle Team
•Created by Brokenwind on 6/18/2024 in #help
Can't migrate on vercel postgres
@Brokenwind , no, but I don't think my issue had anything to do wth the outage.
10 replies
DTDrizzle Team
•Created by Brokenwind on 6/18/2024 in #help
Can't migrate on vercel postgres
Form https://www.vercel-status.com/:
Vercel Postgres outage in the SIN1 region
Resolved - This incident has been resolved.
Jun 18, 14:44 UTC
Monitoring - Neon has implemented a fix and we're currently monitoring the results.
Jun 18, 14:23 UTC
Identified - Due to a problem with our upstream provider, all databases in the SIN1 (Singapore) region are intermittently accessible. For more information, see the Neon status: https://neonstatus.com/aws-asia-pacific-singapore
Jun 18, 13:50 UTC
10 replies
DTDrizzle Team
•Created by Brokenwind on 6/18/2024 in #help
Can't migrate on vercel postgres
@Brokenwind , Vercel Postgres was down today in some Asian regions, as fasr as I can recall.
I'm using Vercel Postgres as well and today I was having a hard time migrating. My schema and migrations were out of sync, but it seems to me it was my bad. I managed to solve the issue by deleting migrations folder/ dropping migrations table and using push to cirumvent migrations.
10 replies
DTDrizzle Team
•Created by nr7751 on 6/18/2024 in #help
Drizzle kit generating migrations but not migrating, claiming all remains the same
Solved by deleting migrations folder and table, using push to bypass migrations, changing back the schema and generating and migrating at long last. Ufff! 😄
6 replies
DTDrizzle Team
•Created by Nick on 6/18/2024 in #help
Trying to get Drizzle, Lucia and Vercel-postress to work together (no changes to schema detected)
@Nick no worries. I solved it. Great education 😄 . Deleting migrations folder and table and using push to bypass migrations apparently solved the issue
7 replies
DTDrizzle Team
•Created by Nick on 6/18/2024 in #help
Trying to get Drizzle, Lucia and Vercel-postress to work together (no changes to schema detected)
@Nick , good thta you solved it ! It's not related to my issue then. Mine is that Drizzles generates migrations byt doesn't apply them.
7 replies
DTDrizzle Team
•Created by nr7751 on 6/18/2024 in #help
Drizzle kit generating migrations but not migrating, claiming all remains the same
@Nick , yes every table is exported. I never had any issues with generating and migrating before with this db. It's the first time
6 replies
DTDrizzle Team
•Created by Nick on 6/18/2024 in #help
Trying to get Drizzle, Lucia and Vercel-postress to work together (no changes to schema detected)
I have the exact same setup Drizzle, Lucia and Vercel PostgreSQL:
generate genereates the right migration files , but when I try to migrate i claims no changes were made the db deosn't get changed. Maybe it's a common isse?
7 replies
DTDrizzle Team
•Created by nr7751 on 5/3/2024 in #help
Columns are being stringified at random
@Sillvva , Ah, I see the issue now. It's "integer" vs "numeric".
Thanks!
4 replies
DTDrizzle Team
•Created by nr7751 on 5/2/2024 in #help
( sql question ) How do you join full tables with select columns from other table?
@arily , it worked!
```typescript
export const fetchAllServicesWithProfiles = async () => {
const result = await db
.select({
id: services.id,
category: services.category,
service: services.service,
description: services.description,
unit: services.unit,
duration: services.duration,
personnel: services.personnel,
included: services.included,
price: serviceProfiles.price,
sale: serviceProfiles.sale,
saleExpiresBy: serviceProfiles.saleExpiresBy,
popularity: serviceProfiles.popularity,
})
.from(services)
.innerJoin(serviceProfiles, eq(services.id, serviceProfiles.serviceId));
return result;
};
Thanks a bunch!
4 replies
DTDrizzle Team
•Created by nr7751 on 4/1/2024 in #help
Drizzle spontaneously trying to truncate my db
Some master trolling going on, then!
21 replies
DTDrizzle Team
•Created by nr7751 on 4/1/2024 in #help
Drizzle spontaneously trying to truncate my db
@ByteBender , Arpil Fool's ?! Any official word on the matter?
21 replies
DTDrizzle Team
•Created by nr7751 on 4/1/2024 in #help
Drizzle spontaneously trying to truncate my db
@jaronheard,
Yes, I did the same thing, and I managed to abort it. In my case, I hadn't changed anything. Yesterday, I had made some very minor changes to the tables, so minor that they didn't even qualify as a migration.
Today, when I logged into Studio, I was greeted with that same modal.
I need an answer, lest this happens again.
21 replies
DTDrizzle Team
•Created by nr7751 on 2/26/2024 in #help
Can someone direct me to a UUID implementation as PK with Drizzle ORM?
Intersting. I will be implementing auth with Lucia as well.
Any considerations I should eb aware of?
WOuld you say my implementation might cause problems with Lucia?
25 replies
DTDrizzle Team
•Created by nr7751 on 2/26/2024 in #help
Can someone direct me to a UUID implementation as PK with Drizzle ORM?
@Peter Boling , but then you can't use any form of UUID , can you?
25 replies
DTDrizzle Team
•Created by nr7751 on 2/26/2024 in #help
Can someone direct me to a UUID implementation as PK with Drizzle ORM?
@Peter Boling , I solved it uisng cuid2
import { createId } from "@paralleldrive/cuid2";
and in the table:
export const users = pgTable(
"users",
{
id: text("id")
.$defaultFn(() => createId())
.primaryKey(),
...
Hope this helps
25 replies
DTDrizzle Team
•Created by nr7751 on 2/26/2024 in #help
Can someone direct me to a UUID implementation as PK with Drizzle ORM?
IIRC, this showed up after genereate and migrate
25 replies
DTDrizzle Team
•Created by nr7751 on 2/26/2024 in #help
Can someone direct me to a UUID implementation as PK with Drizzle ORM?
@Blixkreeg , Yes, I have now been able to run migrations sucessfully. The problem seems to b restricted to UUIDs, at least for now
25 replies
DTDrizzle Team
•Created by nr7751 on 2/27/2024 in #help
Basic config problems - can't get Drizzle to start
@solo , thanks!
It worked. What's the deal here? "./" stands for the project's root folder in this case?
4 replies