Theo's Typesafe Cult•3y ago

Planetscale UUID

Can anybody suggest how to use uuid as primary key in planetscale with drizzle orm?

Josh•8/11/23, 1:43 PM

You have to generate the uuid yourself

AnkanOP•8/11/23, 1:52 PM

Also should I use uuid or serial key that's also a question for me

Neto•8/11/23, 1:53 PM

i dont recomend using uuids

Neto•8/11/23, 1:53 PM

they arent sortable in the same way that they were created

Neto•8/11/23, 1:53 PM

cuid2 or ulid

Neto•8/11/23, 1:53 PM

are two nice alternatives

Neto•8/11/23, 1:57 PM

main difference that i can remember is: storage and limit

Neto•8/11/23, 1:57 PM

storing string ids are more expensive in terms of storage, but they dont suffer from limitations of length

Neto•8/11/23, 1:58 PM

a intint id column tops are 4294967295

Neto•8/11/23, 1:58 PM

if you have the scale to worry about topping a column and not wanting to have to deal with changing the schema later, go with string ids

Neto•8/11/23, 1:58 PM

if not, just use what you want

AnkanOP•8/11/23, 2:00 PM

Actually I was also thinking of going with string ids but was finding a way to auto implment string ids in drizzle I guess I need to do that manually

Neto•8/11/23, 2:00 PM

you can probably use a default of calling a mysql function

AnkanOP•8/11/23, 2:01 PM

is there one for mysql for cuid?

Neto•8/11/23, 2:01 PM

cuid probably not

Neto•8/11/23, 2:01 PM

uuid probably there is one

AnkanOP•8/11/23, 2:01 PM

okk then it would be great using an uuid

Neto•8/11/23, 2:02 PM

check if the mysql server has a generate uuid function

barry•8/11/23, 2:02 PM

Postgres > MySQL t3ggLove

Neto•8/11/23, 2:02 PM

then you would use this one

https://orm.drizzle.team/docs/indexes-constraints#default

import { sql } from "drizzle-orm";
import { int, time, mysqlTable } from "drizzle-orm/mysql-core";
 
const table = mysqlTable("table", {
  int: int("int").default(42),
  time: time("time").default(sql`cast("14:06:10" AS TIME)`), // << sql`` calling the function
});

import { sql } from "drizzle-orm";
import { int, time, mysqlTable } from "drizzle-orm/mysql-core";
 
const table = mysqlTable("table", {
  int: int("int").default(42),
  time: time("time").default(sql`cast("14:06:10" AS TIME)`), // << sql`` calling the function
});

AnkanOP•8/11/23, 2:05 PM

Actually I found PlanetScale to be a nice service but uses mysql behind the scenes. Also Neon has got its own limitations, can you recoomed some hosted service for postgresql?

NNeto then you would use this one https://orm.drizzle.team/docs/indexes-constraints#d...

AnkanOP•8/11/23, 2:07 PM

This one we can try out

JacobMGEvans•8/11/23, 2:59 PM

I came here to check to see if this question was moved into here and answered. Awesome to see both happened!

AAnkan Actually I found PlanetScale to be a nice service but uses mysql behind the scen...

JacobMGEvans•8/11/23, 2:59 PM

Supabase is probably the best postgres hosted service with good DX

JJacobMGEvans Supabase is probably the best postgres hosted service with good DX

barry•8/11/23, 3:00 PM

I like neon too

Neto•8/11/23, 3:00 PM

if you want a compatible

barry•8/11/23, 3:00 PM

cba with anything mysql

Neto•8/11/23, 3:00 PM

cockroachdb as well

JacobMGEvans•8/11/23, 3:00 PM

Neon is good, there is a reason Vercel chose it lol

AnkanOP•8/11/23, 4:03 PM

I guess moving to Postgresql is kinda the right way.

AnkanOP•8/11/23, 4:04 PM

As I was unable to find any direct way in mysql.

AnkanOP•8/11/23, 4:09 PM

Thanks guys for the help. It really means a lot to me.

Neto•8/11/23, 4:15 PM

glad to help

AnkanOP•8/11/23, 4:16 PM

Btw one last thing what would you suggest to use Neon or Supabase?

barry•8/11/23, 4:18 PM

neon

Bbarry neon

AnkanOP•8/11/23, 4:18 PM

Okk will go with that

import { sql } from "drizzle-orm"; import { int, time, mysqlTable } from "drizzle-orm/mysql-core"; const table = mysqlTable("table", { int: int("int").default(42), time: time("time").default(sql`cast("14:06:10" AS TIME)`), // << sql`` calling the function });

Planetscale UUID

Similar Threads

Similar Threads

Similar Threads