4 ms·
At Prisma, the "twelve easy steps" for performing a table change in SQLite documented on https://sqlite.org/lang_altertable.html https://sqlite.org/lang_alterta
by sorenbs 3y ago
At Prisma, the "twelve easy steps" for performing a table change in SQLite documented on https://sqlite.org/lang_altertable.html https://sqlite.org/lang_altertable.html is a bit of a running joke.
SQLite is super versatile, but very different from other more traditional RDMBS.
- rmbyrro 3y agoA bit of unfair comment. These steps apply only to ALTER statements that are NOT supported natively by SQLite. The natively supported statements are as easy to perform as in MySQL or Postgres, for example. > "The only schema altering commands directly supported by SQLite are the 'rename table', 'rename column', 'add column', 'drop column' commands shown above. However, applications can make other arbitrary changes to the format of a table using a simple sequence of operations.
- yencabulator 3y agoThe whole point is how few ALTER TABLE statements are actually supported by SQLite.
- rmbyrro 3y agoThe original comments talks nothing about that, actually. If that was the purpose, why not say that instead?