Why you should probably be using SQLite

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 ]