Code Of Ethics This document was originally called a “Code of Conduct” and was created for the purpose of filling in a box on “supplier registration” forms submitted to the SQLite developers by some clients. However, we subsequently learned that … Read more
SQLite Release 3.39.0 On 2022-06-25 Small. Fast. Reliable.Choose any three. SQLite Release 3.39.0 On 2022-06-25 Add (long overdue) support for RIGHT and FULL OUTER JOIN. Add new binary comparison operators IS NOT DISTINCT FROM and IS DISTINCT FROM that are … Read more
sqlite3 fiddle sqlite3 fiddle Initializing app… On a slow internet connection this may take a moment. If this message displays for “a long time”, intialization may have failed and the JavaScript console may contain clues as to why. Downloading… This … Read more
If every dog has his day, well, perhaps the same is true for every database. Judging from the news recently, SQLite is having its day in the sun. In the last few weeks, several companies announced they were building or … Read more
Overview# Sometimes Litestream can be overkill for projects with a small database that do not have high durability requirements. In these cases, it may be more appropriate to simply back up your database daily or hourly. This approach can also … Read more
Published on May 12, 2022 by Phil Eaton sqlitegobenchmark Most people use the mattn/go-sqlite3 package to interact with SQLite in Go. This package uses cgo and bundles the SQLite C amalgamation files with the Go source. But Go developers often … Read more
Ask HN: Have you used SQLite as a primary database? 48 points by barryhennessy 1 hour ago | hide | past | favorite | 26 comments I periodically hear about projects that use/have used sqlite as their sole datastore. The theory … Read more
GitHub – proofrock/ws4sqlite: Query sqlite via http {{ message }} This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. You can’t perform that action at this time. You … Read more
The Session Extension The session extension provide a mechanism for recording changes to some or all of the rowid tables in an SQLite database, and packaging those changes into a “changeset” or “patchset” file that can later be used to … Read more
How SQLite Is Tested The reliability and robustness of SQLite is achieved in part by thorough and careful testing. As of version 3.33.0 (2020-08-14), the SQLite library consists of approximately 143.4 KSLOC of C code. (KSLOC means thousands of “Source … Read more