Re:SQLite Disk Page Explorer
by koeng on Thursday February 06, 2025 @02:57PM
(#42965903)
What are the disadvantages of using WITHOUT ROWID?
[ Parent
| on HN ]
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.
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.
The disadvantage is that you’ll never look at Postgres the same way again.
Yeah, one of the things postgres is missing. Yugabyte seems to be addressing this thankfully