Hacker News with Generative AI: SQLite

SQLook – A free online SQLite database manager with a Windows 2000 interface (sqlook.com)
SQLook is a modern web-based SQLite database manager with a nostalgic Windows 2000 interface.

Databases, Web Development, User Interfaces, Nostalgic Design, SQLite

175 points by gringow 3 days ago | 70 comments

Supercharge SQLite with Ruby Functions (julik.nl)
An interesting twist in my recent usage of SQLite was the fact that I noticed my research scripts and the database intertwine more. SQLite is unique in that it really lives in-process, unlike standalone database servers. There is a feature to that which does not get used very frequently, but can be indispensable in some situations.

Ruby, SQLite, Databases, Programming, Performance

149 points by julik 5 days ago | 40 comments

We will rewrite SQLite. And we are going all-in (turso.tech)
Two years ago, we made a bet: SQLite, the most successful database in history, could be even better.

Databases, SQLite, Open Source

17 points by mpereira 7 days ago | 3 comments

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 24 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 26 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 30 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 38 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 38 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 43 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 49 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 54 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 58 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 58 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 65 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 65 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 66 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 67 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 71 days ago | 110 comments

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

Databases, Performance, Video, PostgreSQL, SQLite

28 points by thunderbong 71 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 76 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 80 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 81 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 93 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 94 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 105 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 107 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 116 days ago | 15 comments

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

Databases, SQLite, Edge Computing

169 points by hunvreus 116 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 117 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 121 days ago | 3 comments