drizzle-team / drizzle-orm

Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅
https://orm.drizzle.team
Apache License 2.0
23.52k stars 577 forks source link

[FEATURE]: generate `ALTER COLUMN` migrations for libSQL #1367

Open biowaffeln opened 11 months ago

biowaffeln commented 11 months ago

Describe what you want

When changing a table column in SQLite, Drizzle Kit doesn't automatically generate migrations because SQLite doesn't support altering columns. However, libSQL does support altering columns (see docs), which means that automatically generating migrations should be possible when using turso/libSQL as a driver. It would be awesome if the team could add this feature to Drizzle Kit!

ansarizafar commented 11 months ago

Is there any update on this issue?

ansarizafar commented 11 months ago

Please also provide support for Libsql's RANDOM ROWID feature.

emnnipal commented 6 months ago

With turso DB getting really popular lately because of its great free tier, now's a good time to think about this enhancement again.