Hacker News with Generative AI: SQLite

Show HN: Postgres-SQLite: SQLite as first-class types in Postgres (github.com/michelp)
postgres-sqlite is a PostgreSQL extension that introduces SQLite databases as a first-class data type within PostgreSQL.

Databases, PostgreSQL, SQLite, Extensions

15 points by michelpp 14 days ago | 2 comments

Speeding Up SQLite Inserts (julik.nl)
In my work I tend to reach for SQLite more and more. The type of work I find it useful for most these days is quickly amalgamating, dissecting, collecting and analyzing large data sets. As I have outlined in my Euruko talk on scheduling, a key element of the project was writing a simulator. That simulator outputs metrics - lots and lots of metrics, which resemble what our APM solution collects.

Databases, Performance Optimization, SQLite

14 points by julik 15 days ago | 3 comments

Fun facts about SQLite (avi.im)
SQLite is the most deployed and most used database. There are over one trillion (1000000000000 or a million million) SQLite databases in active use.

Databases, SQLite, Fun Facts

393 points by avinassh 19 days ago | 191 comments

How bloom filters made SQLite 10x faster (avi.im)
This is the fascinating story of how researchers used Bloom filters cleverly to make SQLite 10x faster for analytical queries.

Database, Performance, Optimization, SQLite, Bloom Filters

504 points by avinassh 27 days ago | 121 comments

Show HN: NoSQL, but it's SQLite (github.com)
SQLite-backed key-value store with JS-like object manipulation and automatic JSON serialization.

Databases, NoSQL, JavaScript, SQLite

98 points by vsroy 27 days ago | 39 comments

Cr-SQLite – Multi-writer and CRDT support for SQLite (github.com/vlcn-io)
CR-SQLite is a run-time loadable extension for SQLite and libSQL. It allows merging different SQLite databases together that have taken independent writes.

Databases, SQLite, Software, Open Source

30 points by apitman 32 days ago | 2 comments

Limbo: A complete rewrite of SQLite in Rust (turso.tech)
Today we are announcing a more ambitious experiment: what could we achieve, if we were to completely rewrite SQLite in a memory-safe language (Rust)? With the Limbo project, now available at github.com/tursodatabase/limbo, we are now trying to answer that question.

Rust, Databases, SQLite, Programming Languages, Open Source

373 points by avinassh 38 days ago | 232 comments

Sensible SQLite Defaults (briandouglas.ie)
SQLite is cool now. DHH uses it, Laravel defaults to it. Here is a list of sensible defaults when using sqlite.

Databases, SQLite, Software Development

223 points by thunderbong 43 days ago | 67 comments

SQLite Index Visualization: Search (mrsuh.com)
In the previous post, I explained how to extract data from SQLite Indexes and make it visual. This time, I'll try to show what a search inside an Index looks like.

SQLite, Databases, Visualization, Search

15 points by mrsuh 47 days ago | 0 comments

Big Endian's Guide to SQLite Storage (jabid.in)
I wanted to learn how databases like SQLite store data under the hood, so I decided to write some code to inspect the database file. SQLite famously stores the entire database in a single file, and the file format is very well documented. Here is one diagram1 to get started instead of the roughly 13,848 words in that document.

Databases, SQLite, Programming, Data Storage, Software

38 points by marcobambini 47 days ago | 0 comments

SQLite-utils: a tool for manipulating SQLite databases (datasette.io)
CLI tool and Python library for manipulating SQLite databases

Databases, SQLite, Tools, Python

9 points by mpbart 54 days ago | 0 comments

SQLiteStudio: Create, edit, browse SQLite databases (sqlitestudio.pl)
It's a hotfix release to address urgent problem of "black SQL code line" that appeared in 3.4.5. It also gets two more issues resolved.

SQLite, Databases, Software, Bug Fixes

626 points by thunderbong 54 days ago | 123 comments

Sqlpkg – The SQLite Extension Hub (sqlpkg.org)
Find SQLite extensions using the search box above. You can download and install them manually, or use the sqlpkg package manager.

SQLite, Database, Tools, Package Management

5 points by thunderbong 55 days ago | 0 comments

SQLite’s Use of Tcl (2017) (tcl.tk)
SQLite is a TCL extension that has escaped into the wild.

Databases, Programming Languages, TCL, SQLite

138 points by fanf2 56 days ago | 44 comments

Show HN: Embed an SQLite database in your PostgreSQL table (github.com/frectonz)
Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved.

Databases, PostgreSQL, SQLite, Multitenancy, Software

180 points by frectonz 60 days ago | 110 comments

SQLite vs. PostgreSQL Performance [video] (youtube.com)

Databases, Performance, Video, PostgreSQL, SQLite

28 points by thunderbong 60 days ago | 7 comments

SQLite Index Visualization (mrsuh.com)
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.

Databases, Data Structures, Optimization, SQLite

295 points by mrsuh 65 days ago | 26 comments

SQLite is not a single connection database (igorstechnoclub.com)
I think the most common misconception about SQLite which drives people away from that database is that it's a single connection database.

Databases, SQLite, Misconceptions

77 points by Igor_Wiwi 70 days ago | 38 comments

SQLite does not do checksums (avi.im)
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’.

Databases, SQLite, Data Integrity

132 points by todsacerdoti 70 days ago | 98 comments

SQLite Rsync: Database Remote-Copy Tool for SQLite (sqlite.org)
The following command causes REPLICA to become a copy of ORIGIN:

Databases, Tools, SQLite, Remote Syncing

75 points by Peter5 82 days ago | 11 comments

35% Faster Than the Filesystem (2017) (sqlite.org)
SQLite reads and writes small blobs (for example, thumbnail images) 35% faster¹ than the same blobs can be read from or written to individual files on disk using fread() or fwrite().

Database, Performance, SQLite

46 points by lopkeny12ko 83 days ago | 27 comments

Sqlite3 WebAssembly (sqlite.org)
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 made API-stable with the 3.41 release, pending community feedback.

WebAssembly, Databases, Javascript, Software, SQLite

647 points by whatever3 94 days ago | 192 comments

Zero-latency SQLite storage in every Durable Object (simonwillison.net)
Kenton Varda introduces the next iteration of Cloudflare's Durable Object platform, which recently upgraded from a key/value store to a full relational system based on SQLite.

Cloud Computing, Databases, SQLite, Durable Objects

285 points by ajhit406 96 days ago | 103 comments

Compiling and running sqlite3-rsync from a branch (simonwillison.net)
Today I heard about the sqlite3-rsync command, currently available in a branch in the SQLite code repository. It provides a mechanism for efficiently creating or updating a copy of a SQLite database that is running in WAL mode, either locally or via SSH to another server.

Database Management, SQLite

63 points by tosh 105 days ago | 15 comments

Starbase: SQLite on the Edge (starbasedb.com)
Plug & Play SQLite

Databases, SQLite, Edge Computing

169 points by hunvreus 105 days ago | 47 comments

The SQLite team is preparing an efficient remote replication tool (devclass.com)
SQLite, the ubiquitous database engine, is likely to be enhanced with a replication tool that will ensure a consistent snapshot of a database even while there are active reads and writes taking place.

Databases, Replication, SQLite

5 points by thunderbong 106 days ago | 0 comments

Sqlite3-Rsync (Draft) (sqlite.org)
To cause the SQLite database named by REPLICA to be a copy of the current content of the ORIGIN database, run this command:

Databases, Software, Programming, Open Source, SQLite

46 points by alpn 110 days ago | 3 comments

Backup Strategies for SQLite in Production (oldmoe.blog)
If you are relying on SQLite as your production database, then it makes sense to have some sort of a backup strategy.

Databases, Backup, SQLite

37 points by mpweiher 118 days ago | 3 comments

db-to-sqlite: exporting tables or queries from any SQL database to SQLite (github.com/simonw)
CLI tool for exporting tables or queries from any SQL database to a SQLite file.

Databases, SQLite

5 points by tosh 121 days ago | 0 comments

SQLite Transparent Compression (github.com/phiresky)
Extension for sqlite that provides transparent dictionary-based row-level compression for sqlite. This basically allows you to compress entries in a sqlite database almost as well as if you were compressing the whole DB file, but while retaining random access.

Database, Compression, SQLite, Software, Open Source

5 points by edweis 123 days ago | 2 comments