3 ms·
I think that's a security vulnerability. If a parent table ID gets reused, then it's a potential to expose data to a wrong user -- security broked.
by deepsun 3mo ago
I think that's a security vulnerability.
If a parent table ID gets reused, then it's a potential to expose data to a wrong user -- security broked.
- zarzavat 3mo agoThat's correct but SQLite was never designed to be a production database in the first place. It can be used as a production database but only if you know what you're doing, and presumably anyone who knows what they're doing knows about the AUTOINCREMENT keyword because it's one of the first things you learn about SQLite.
- nick__m 3mo agoI disagree, SQLite is a production embedded database, the extensive test¹ suite is a testament to that. It's just has different default and behavior than a database designed for being served to multiples simultaneous writers. 1- https://sqlite.org/testing.html https://sqlite.org/testing.html