https://corecursive.com/066-sqlite-with-richard-hipp/
On today's show, I'm talking to Richard Hipp about surviving becoming core infrastructure for the world. SQLite is everywhere. It's in your web browser, it's...
untoldstorysqliterichardpodcast
https://ionicacademy.com/courses/building-a-habit-tracker-with-sqlite/
Dec 5, 2022 - Versions: Ionic 6 / Angular 14 In this course you will learn to work with the SQLite database and local notifications. In this course we’ll
habit trackerbuildingsqliteionicacademy
https://changelog.com/shipit/59
Ben Johnson, the creator of Litestream, joined Fly.io a few weeks after we migrated changelog.com - episode 50 has all the details. That was pure coincidence....
ben johnsonpostgresvssqlitefeaturing
https://www.p99conf.io/session/why-were-rewriting-sqlite-in-rust/
Rewriting SQLite in Rust with deterministic simulation testing achieves massive 500× performance gains.
rewritingsqliterustconf
https://www.geeky-gadgets.com/sqlite-multi-writer/
Nov 28, 2025 - Get faster SQLite writes for heavy ingest. Turso’s Rust engine adds MVCC and async IO, hitting roughly 200,000 writes each second.
singlewriterlimitsmultispeed
https://changelog.com/podcast/626
Glauber Costa, co-founder and CEO of Turso, joins us to discuss libSQL, Limbo, and how they're rewriting SQLite in Rust. We discuss their efforts with...
tursorewritingsqliterustcosta
https://simonwillison.net/2020/Sep/26/weeknotes-software-carpentry-sqlite/
This week I completed the Software Carpentry instructor training course, added two foundational features to sqlite-utils and learned how to compile modules for...
weeknotessoftwarecarpentrycompilingmodules
https://fly.io/javascript-journal/single-tenant-sqlite-in-tigris/
Documentation and guides from the team at Fly.io.
multitenantappssinglesqlite
https://simonwillison.net/2021/Feb/4/datasette-tiles/
Working on datasette-leaflet last week re-kindled my interest in using Datasette as a GIS (Geographic Information System) platform. SQLite already has strong...
servingmaptilessqlitedatasette
https://simonwillison.net/2021/Aug/6/sqlite-utils-convert/
Earlier this week I released sqlite-utils 3.14 with a powerful new command-line tool: sqlite-utils convert, which applies a conversion function to data stored...
applyconversionfunctionsdatasqlite
https://hoelz.ro/blog/with-sqlite-insert-or-ignore-is-often-not-what-you-want
tl;dr - INSERT OR IGNORE will silently fail if any constraint is violated (even a NOT NULL on a column type!). If you want to express "insert this row...
sqliteinsertignoreoften
https://app.codecrafters.io/courses/sqlite/overview
Real-world proficiency projects designed for experienced engineers. Develop software craftsmanship by recreating popular devtools from scratch.
buildsqlite
https://modern-sql.com/use-case/pivot
Pivot SQL tables with CASE or FILTER. Turn rows into columns for the entity-attribute-value model (EAV).
sqlpivotdatabasesmariadboracle
https://serverfault.com/questions/1196076/configuring-nfs4-for-maximum-reliability-with-sqlite
Let me start by saying that I am aware a simple search for "nfs SQLite" surfaces this answer as the top result. In a perfect world, I'd be able to choose to...
server faultstorageconfiguringmaximumreliability
https://sqlite.org/datatype3.html
sqlite
https://doc.dovecot.org/2.4.2/core/config/sql/sqlite.html
Dovecot CE Documentation
dovecot cesqlite
https://ionicacademy.com/sqlite-ionic-with-capacitor/
Jul 20, 2023 - If you need to store more data than a few keys, you should pick the SQLite Capacitor integration that you can easily use with Ionic
usesqliteioniccapacitoracademy
https://simonwillison.net/2021/Mar/14/weeknotes/
This week I started a limited production run of my new backend for Vaccinate CA calling, built a tableau-to-sqlite import tool and started working on a subset...
weeknotestableausqlitedjangodashboard
https://fly.io/blog/sqlite-internals-btree/
Let's open a hex editor and see what this thing is made of
sqliteinternalspagesampb
https://tailscale.com/blog/database-for-2022
Apr 1, 2022 - we moved from etcd to SQLite for a simpler, more scalable database solution. Learn about Litestream, live replication, and lessons learned.
database migrationswitchingetcdsqlitestory
https://fly.io/blog/sqlite-internals-rollback-journal/
Let's take a peek at how the rollback journal works.
sqlitehelpsacidflyblog
https://www.devclass.com/serverless/2024/10/24/sqlite-will-migrate-from-gnu-autotools-to-autosetup-team-warns-of-some-build-level-breakage/1619880
Oct 24, 2024 - The SQLite team is migrating the next release to use Autosetup instead of GNU Autotools and warns that […]
sqlitemigrategnuteamwarns
https://sqlite.org/about.html
sqlite
https://randomnerdtutorials.com/sqlite-with-node-red-and-raspberry-pi/
Apr 2, 2019 - In this project you’ll install an SQLite package for Node-RED and learn how to write simple SQL queries to interact with your SQLite database.
raspberry pisqlitenoderedrandom
https://simonwillison.net/2023/Dec/8/weeknotes/
I’ve mainly been working on Datasette Enrichments and continuing to explore the possibilities enabled by sqlite-chronicle. Enrichments This is the biggest...
weeknotesdatasettecommentssqlitechronicle
https://turso.tech/drizzle
Turso is SQLite for production: great developer experience and efficiency with essential quality of life improvements for modern applications.
tursosqliteproduction
https://sqlite.org/index.html
sqlite
https://www.contentteller.com/guide/upgrading-database-from-sqlite/
A quick tutorial about converting from SQLite to MariaDB, MySQL, Postgres or vice versa.Upgrading from SQLite to a MariaDB, MySQL, or PostgreSQL can be done...
upgradingdatabasesqlite
https://www.theserverside.com/video/SQLite-tutorial-for-beginners
This SQLite tutorial will show you how to install SQLite3 on Windows, create tables in a database and perform read, update and delete operations.
sqlitetutorialbeginnerstheserverside
https://www.heidisql.com/
HeidiSQL is a free and powerful client for MariaDB, MySQL, Microsoft SQL Server, PostgreSQL, SQLite and Interbase/Firebird
mariadbmysqlmssqlpostgresqlsqlite
https://codetv.dev/series/learn-with-jason/s8/sqlite-and-turso
It’s hard to beat SQLite for quickly setting up a database on a project — but can it handle “real” projects? Glauber Costa teaches us how it works in...
sqlitetursolearnjasonseason
https://www.theregister.com/2025/06/25/anthropic_sql_injection_flaw_unfixed/
Jun 25, 2025 - : Fork that - 5k+ times
anthropicfixbugsqlitemcp
https://db0.unjs.io/connectors/sqlite
Connect DB0 to local SQLite database with Node.js and Deno
sqlite
https://randomnerdtutorials.com/esp8266-publishing-dht22-readings-to-sqlite-database/
Apr 2, 2019 - You’ll create a standalone web server with a Raspberry Pi that displays temperature and humidity readings with a DHT22 that are stored in an SQLite database.
publishingsqliterandomnerdtutorials
https://datasette.io/tutorials/data-analysis
A 2h45m video tutorial about SQLite, Python, sqlite-utils and Datasette presented at PyCon 2023
data analysispython tutorialsqlite
https://turso.tech/blog/introducing-limbo-a-complete-rewrite-of-sqlite-in-rust
Dec 10, 2024 - we forked SQLite with the libSQL project. What would it be like if we just rewrote it?
introducinglimbocompleterewritesqlite
https://simonwillison.net/2021/Jun/19/sqlite-utils-memory/
The new sqlite-utils memory command can import CSV and JSON data directly into an in-memory SQLite database, combine and query it using SQL and output the...
json datajoiningcsvmemorysqlite
https://randomnerdtutorials.com/sqlite-database-on-a-raspberry-pi/
Jun 3, 2019 - I'll introduce you to SQLite, which is an in-process light weight library that implements a self-contained, zero-configuration, transactional SQL database...
raspberry pisqlitedatabaserandomnerd
https://joyofrails.com/articles/what-you-need-to-know-about-sqlite
A compilation of lessons about what the SQLite database engine can and cannot do, how Ruby on Rails helps you work with SQLite, and why it may, or may not, be...
joyrailsneedknowsqlite
https://daniele.tech/2025/01/how-to-import-fixture-in-django-with-sqlite-with-foreign-key-disabled/
Jan 14, 2025 - You have various fixtures but maybe they are referenced between each other so they in the import don’t exists. This is a pain but with a custom django...
importfixturedjangosqliteforeign
https://ramen.tools/sqlite
SQLite is being used by 32 makers. What about you?
sqliteramentools
https://simonwillison.net/2023/Oct/30/weeknotes/
I wrote a lot this week. I also did some fun research into new options for self-hosting vector maps and pushed out several new releases of plugins. On the blog...
e
https://simonwillison.net/2023/Aug/5/weeknotes-plugins/
The principle theme for the past few weeks has been plugins. Llama 2 in LLM via plugins I added the ability to support models other than the OpenAI ones to …
weeknotespluginsllmsqliteutils
https://realpython.com/courses/sqlite-sqlalchemy-python-beyond-flat-files/
In this video course, you'll learn how to store and retrieve data using Python, SQLite, and SQLAlchemy as well as with flat files. Using SQLite with...
sqlitesqlalchemypythonmovedata
https://fly.io/docs/js/prisma/sqlite/
Documentation and guides from the team at Fly.io.
sqliteflydocs
https://flightaware.engineering/making-sqlite-upserts-snappy-with-python-and-sqlalchemy/
In this post, we explore some of the tradeoffs of performance optimization and where to draw the line in the never-ending quest for speedy code.
makingsqlitesnappypythonsqlalchemy
https://realpython.com/python-contact-book/
In this step-by-step project, you'll build a minimal contact book application using Python, with PyQt to build the application's GUI and SQLite to...
buildbookpythonsqlite
https://til.simonwillison.net/sqlite/sqlite-triggers
I wrote a Python script, triggers.py , to help me understand what data is available to SQLite triggers for which operations.
sqlitetriggerssimon
https://starbasedb.com/
Starbase, a SQLite database rendered on the edge.
starbasesqliteedge
https://simonwillison.net/tags/sqlite/
313 posts tagged ‘sqlite’. SQLite is the world's most widely deployed database engine.
simon willisonsqlite
https://simonwillison.net/2023/Apr/29/enriching-data/
I shipped openai-to-sqlite 0.3 yesterday with a fun new feature: you can now use the command-line tool to enrich data in a SQLite database by running values...
enrichingdatasqlitefunctions
https://docs.deno.com/examples/sqlite/
In-depth documentation, guides, and reference materials for building secure, high-performance JavaScript and TypeScript applications with Deno
connectsqlite
https://nuxtstarterkit.com/docs/database
Cloudflare D1 is a serverless SQL database that runs on SQLite.
nuxt startersqlitekit
https://simonwillison.net/2021/Feb/7/video/
I put together a 17 minute video introduction to Datasette and sqlite-utils for FOSDEM 2021, showing how you can use Datasette to explore data, and...
videointroductiondatasettesqliteutils
https://simonwillison.net/2021/Dec/7/git-history/
I described Git scraping last year: a technique for writing scrapers where you periodically snapshot a source of data to a Git repository in order to record...
git historytoolanalyzingdatacollected
https://simonwillison.net/2023/Jul/24/sqlite-utils-plugins/
sqlite-utils 3.34 is out with a major new feature: support for plugins. sqlite-utils is my combination Python library and command-line tool for manipulating...
sqliteutilssupportsplugins