News for hackers. Stuff that matters.
Re:SQLite Disk Page Explorer by electroly on Thursday February 06, 2025 @03:08PM (#42966006)
The main advantage is also its biggest disadvantage: you CAN control the clustering of the rows... and you MUST control the clustering of the rows. SQLite won't give you an auto-incremented ID on a WITHOUT ROWID table. You have to assign the IDs yourself and SQLite won't help you.
Re:SQLite Disk Page Explorer by srcreigh on Thursday February 06, 2025 @06:15PM (#42967465)
SQLite can give you an auto incremented ID on a without row id table. You just need to have a unique index on the id.