News for hackers. Stuff that matters.
Re:SQLite Disk Page Explorer by koeng on Thursday February 06, 2025 @02:57PM (#42965903)
What are the disadvantages of using WITHOUT ROWID?
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.
Re:SQLite Disk Page Explorer by srcreigh on Thursday February 06, 2025 @06:16PM (#42967469)
The disadvantage is that you’ll never look at Postgres the same way again.
Re:SQLite Disk Page Explorer by tehlike on Friday February 07, 2025 @07:21AM (#42971771)
Yeah, one of the things postgres is missing. Yugabyte seems to be addressing this thankfully
Re:SQLite Disk Page Explorer by srcreigh on Friday February 07, 2025 @11:44AM (#42974696)
Yep looks like it. They don't seem to use Postgres storage layer at all.