4 ms·
The Design of SQLite4 (2014)
- meepmorp 3y ago> SQLite4 was an experimental rewrite of SQLite that was active from 2012 through 2014. All development work on SQLite4 has ended. Lessons learned from SQLite4 have been folded into the main SQLite3 product. SQLite4 was never released. There are no plans to revive it. You should be using SQLite3.
- smolsky 3y agoOh, wow, that's right. That note is here: https://sqlite.org/src4/doc/trunk/www/index.wiki https://sqlite.org/src4/doc/trunk/www/index.wiki
- Waterluvian 3y agoI love this concept. Work on a rewrite and then fold lessons learned methodically into the existing, stable, proven one.
- smolsky 3y agoDid they fold the LSM idea? What about the single global namespace in which all records live?
- amanzi 3y agoI feel like that should be in a banner at the top of the page OP linked to!
- LegibleCrimson 3y agoI don't see why. It's on the SQLite4 Home page: https://sqlite.org/src4/doc/trunk/www/index.wiki https://sqlite.org/src4/doc/trunk/www/index.wiki The OP's link is to the first subpage, The Design of SQLite4. If you're putting it there, you might as well put it on every page.
- deleted 3y ago[deleted]
- anyfoo 3y agoEDIT: It looks like something that mostly addresses my problem, “strict tables”, was added in 2021. Thank you everyone. It seems this rewrite would not have addressed my biggest gripe with SQLite: Surprisingly, it is not actually type safe. SQLite uses a more general dynamic type system. In SQLite, the datatype of a value is associated with the value itself, not with its container. https://www.sqlite.org/datatype3.html https://www.sqlite.org/datatype3.html That’s right, the type you give to a column when creating a table is merely a suggestion. This means at some point, TEXT may make it into a column where a NUMERIC is expected. This actually caused a large scale problem in production once. I still love SQLite, it’s the very best at what it does, but I’m a bit more careful now. The same documentation says SQLite uses dynamic typing so that you can “do more things” than with other databases, but for me this is akin to saying you can “do more things with assembly than with a high level language” (in both cases that’s mostly not even true). I expect my SQL database to keep data from taking the wrong form. It looks like the SQLite 4 rewrite would at least have enabled constraints by default… I think many would appreciate a “no surprises” strict, type safe mode in SQLite 3, for me this would complete it. Maybe that exists already?
- npn 3y agoYes, create your table with a trailing strict statement.
- deleted 3y ago[deleted]
- gavinhoward 3y ago> I think many would appreciate a “no surprises” strict, type safe mode in SQLite 3, for me this would complete it. Maybe that exists already? It does, somewhat. https://www.sqlite.org/stricttables.html https://www.sqlite.org/stricttables.html
- bruce_one 3y agoYou're looking for [strict tables](https://www.sqlite.org/stricttables.html https://www.sqlite.org/stricttables.html) and they do already exist :-) Added in 3.37.0 (2021-11-27), apparently :-)
- dang 3y agoRelated. Others? The Design of SQLite4 - https://news.ycombinator.com/item?id=31785170 https://news.ycombinator.com/item?id=31785170 - June 2022 (19 comments) Work on SQLite4 has concluded - https://news.ycombinator.com/item?id=15648280 https://news.ycombinator.com/item?id=15648280 - Nov 2017 (157 comments) SQLite4: The Design of SQLite4 - https://news.ycombinator.com/item?id=10104964 https://news.ycombinator.com/item?id=10104964 - Aug 2015 (2 comments) The Design Of SQLite4 - https://news.ycombinator.com/item?id=7797025 https://news.ycombinator.com/item?id=7797025 - May 2014 (67 comments) The Design Of SQLite4 (work in progress) - https://news.ycombinator.com/item?id=4168645 https://news.ycombinator.com/item?id=4168645 - June 2012 (49 comments)