A Jekyll generator plugin to lets you use SQLite database instead of data files as a data source. It lets you easily create APIs and websites from a SQLite database, by linking together a database file, your template, and the … Read more
The WITH Clause Table Of Contents with-clause: hide Common Table Expressions or CTEs act like temporary views that exist only for the duration of a single SQL statement. There are two kinds of common table expressions: “ordinary” and “recursive”. Ordinary … Read more
After learning about indexes, I understood their basic structure, but I wanted to dig deeper — to explore the data structure, understand the algorithm, and learn how the index data is stored on disk.The theory and actual implementation can differ, … Read more
SQLite does not do checksums by default. I learned this from Alex Miller. What does this mean? If there is disk corruption, the database or application won’t be able to know that the database is ‘corrupt’. Even a single bit … Read more
SQLite Forum: Announce: migration of the build system to autosetup Announce: migration of the build system to autosetup ☰About Threads Post Subscribe SQLite (1) By Stephan Beal (stephan) on 2024-10-21 18:53:13 [source] Good evening, folks, As Richard just posted in … Read more
This site is home to the documentation for the SQLite project’s WebAssembly- and JavaScript-related APIs, which enable the use of sqlite3 in modern WASM-capable browsers. These components were initially released for public beta with version 3.40 and will tentatively be … Read more
The SQLite Amalgamation Over 100 separate source files are concatenated into a single large file of C-code named “sqlite3.c” and referred to as “the amalgamation”. The amalgamation contains everything an application needs to embed SQLite. Combining all the code for … Read more
Over the last year or so, I have found myself on a journey to deeply understand how to run Rails applications backed by SQLite performantly and resiliently. In that time, I have learned various lessons that I want to share … Read more
SQLite FTS5 Extension FTS5 is an SQLite virtual table module that provides full-text search functionality to database applications. In their most elementary form, full-text search engines allow the user to efficiently search a large collection of documents for the subset … Read more
{{ 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.