Published on 2021-04-14. Modified on 2023-02-16. The name SQLite is a nice name, but the “lite” part is misleading, it sounds like it is only useful for tiny things – which is very wrong. SQLite should be named AwesomeSQL, because … Read more
Here’s an exercise for you. Go to the Craft of Emacs website and type the word “list” into the search bar. You might think you’ve executed a perfectly ordinary text search, the sort you can do on Medium, or Hacker … Read more
In our blog post Deprecating and removing Web SQL, we promised a replacement for Web SQL based on SQLite. The SQLite Wasm library with the Origin Private File System persistence backend is our fulfillment of this promise. # About SQLite … Read more
So the customer… They were using Informix for the database engine. The problem that I was working on, it was a really interesting problem. We had to solve an NP-complete problem, which of course we couldn’t solve, but we could … Read more
2022 Recap (1) By Richard Hipp (drh) on 2022-12-31 17:59:40 [source] There have been many improvements to SQLite during 2022. Listed below or just a few of the bigger changes. See the change logs or the trunk timeline for a … Read more
To all SQLite lovers. You can view [ compileralchemy.com ] or [ contribute to the book ] or [ download the book ] It is OpenSource! Feel free to contribute a section, propose rewrites, fix typos etc. If you have … Read more
Why SQLite and Go in the cloud are a great match, getting started, best practices, and more. Last updated November 2022 for Go 1.19. Why SQLite and Go? I love the intersection of the cloud and “boring” old technologies. SQLite … Read more
SQLite Release 3.40.0 On 2022-11-16 Small. Fast. Reliable.Choose any three. SQLite Release 3.40.0 On 2022-11-16 Add support for compiling SQLite to WASM and running it in web browsers. NB: The WASM build and its interfaces are considered “beta” and are … Read more
SQLite Release 3.40.0 On 2022-11-16 Small. Fast. Reliable.Choose any three. SQLite Release 3.40.0 On 2022-11-16 Add support for compiling SQLite to WASM and running it in web browsers. NB: The WASM build and its interfaces are considered “beta” and are … Read more
Partial Indexes A partial index is an index over a subset of the rows of a table. In ordinary indexes, there is exactly one entry in the index for every row in the table. In partial indexes, only some subset … Read more