sqlite3 Command Line: Create and Query SQLite Databases
Create and query SQLite databases with sqlite3 on Linux. Import CSV files, format query results, and back up or restore your data.
sqlite
SQLite as a document database
SQLite Features You Didn’t Know It Had: JSON, text search, CTE, STRICT, generated columns, WAL
SQLite has evolved far beyond a simple embedded database. Explore modern features like JSON, FTS5, window functions, strict tables, and more.
Import a CSV File Into an SQLite Table
This tutorial shows you various ways to import CSV data into an SQLite table using sqlite3 and SQLite Studio tools.
sqlite-s3vfs
Neat open source project on the GitHub organisation for the UK government's Department for Business and Trade: a "Python virtual filesystem for SQLite to read from and write to S3." …
Supercharge SQLite with Ruby Functions
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…
Collection of insane and fun facts about SQLite - blag
Some of the interesting and insane facts I learned about SQLite
sqlite-vec v0.1.0 Released: Portable Vector Database Extension for SQLite w
Alex Garcia announced the much-anticipated release of sqlite-vec v0.1.0. This new SQLite extension, written entirely in C, introduces a powerful vector search capability to the SQLite database system. Released under the MIT/Apache-2.0 dual license, sqlite-vec aims to be a…
A Guide to Working with SQLite Databases in Python
Get started with SQLite databases in Python using the built-in sqlite3 module.
Why SQLite Uses Bytecode
SQLite on Rails: The how and why of optimal performance
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.
sqlite-schema-diagram
GitLab.com
How (and why) to run SQLite in production: RubyConf Taiwan 2023
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.
S3 is files, but not a filesystem
"Deep" modules, mismatched interfaces - and why SAP is so painful
Built-In Scalar SQL Functions
0x6b/libgsqlite
A SQLite extension which loads a Google Sheet as a virtual table. - 0x6b/libgsqlite
openai-to-sqlite - a tool for Datasette
Quirks, Caveats, and Gotchas In SQLite
Scraping JSON, HTML, and ZIP Files with Pure SQLite
a.k.a. leave BeautifulSoup in the past and embrace SQL I used DALL·E to generate thumbnails for this post: “cute cartoon|claymation abominable snowman scraping ice off his frozen car windshield” is nightmare fuel Some of the most common web-scraping tasks can be done in pure…
SQLite Internals: Pages & B-trees
Let's open a hex editor and see what this thing is made of
One-liner for running queries against CSV files with SQLite | Simon Williso
I figured out how to run a SQL query directly against a CSV file using the sqlite3 command-line utility:
sqlite-utils: a nice way to import data into SQLite for analysis
SQLite3 Fiddle
Wesley Aptekar-Cassels | Consider SQLite
jmoiron/sqlx: general purpose extensions to golang's database/sql
general purpose extensions to golang's database/sql - jmoiron/sqlx
Hosting SQLite databases on Github Pages - (or any static file hoster) - ph
I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. But if you…
Inserting One Billion Rows in SQLite Under a Minute
This is a chronicle of my experiment where I set out to insert 1B rows in SQLite
Ask HN: What is the SQLite of nosql databases?
Tricks for Advanced SQL Querying
One of the most valuable technical skills I use working on a data science team in the retail space is SQL…
A Hitchhiker's Guide to SQLite with Python
To explore SQLite along with Python, which is a user-friendly and no-nonsense language, we are going...
SQLite the only database you will ever need in most cases
SQLite Plus: all the missing SQLite functions
The ultimate set of SQLite extensions.
SQLite is not a toy database | Anton Zhiyanov
Here is why SQLite is a perfect tool for you - whether you are a developer, data analyst, or geek.
Python Pandas and SQLite
Using SQLite to store your Pandas dataframes gives you a persistent store and a way of easily selecting and filtering your data
sqlite command line cheatsheet at DuckDuckGo
DuckDuckGo. Privacy, Simplified.
how to exit from sqlite at DuckDuckGo
DuckDuckGo. Privacy, Simplified.
Turn Your Excel Workbook Into A SQLite Database
Transforming spreadsheets into queryable database tables
Python SQLite Tutorial — The Ultimate Guide
Everything You Need to Get Started!