Why you should probably be using SQLite

Re:Why you should probably be using SQLite by sorenbs on Friday October 27, 2023 @09:46AM (#38038368)

At Prisma, the "twelve easy steps" for performing a table change in SQLite documented on 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.

[ Parent | on HN ]

Re:Why you should probably be using SQLite by rmbyrro on Friday October 27, 2023 @10:44AM (#38039117)

A 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.

[ Parent | on HN ]

Re:Why you should probably be using SQLite by yencabulator on Friday October 27, 2023 @12:47PM (#38040814)

The whole point is how few ALTER TABLE statements are actually supported by SQLite.

[ Parent | on HN ]

Re:Why you should probably be using SQLite by rmbyrro on Saturday October 28, 2023 @06:47AM (#38048756)

The original comments talks nothing about that, actually. If that was the purpose, why not say that instead?

[ Parent | on HN ]