5 ms·

What are the disadvantages of using WITHOUT ROWID?

• electroly 2y ago
  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.
  • srcreigh 2y ago
    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.
• srcreigh 2y ago
  The disadvantage is that you’ll never look at Postgres the same way again.
  • tehlike 2y ago
    Yeah, one of the things postgres is missing. Yugabyte seems to be addressing this thankfully
    • srcreigh 2y ago
      Yep looks like it. They don't seem to use Postgres storage layer at all.