awesome-sqlite
A collection of awesome sqlite tools, scripts, books, etc
AI summary
Database library
A curated collection of tools, scripts, books, and resources related to SQLite, a self-contained, serverless, zero-configuration, transactional SQL database engine.
- stars
- 336
- forks
- 36
- watching
- 18
- awesome lists
- 6
- entries
- 51
What's in the list
51 links in 21 sections, with live GitHub stats.activeno commit in 2y
SQLite Headquarters (HQ)
- sqlite.org
(web: ) by D. Richard Hipp et al
SQLite Headquarters (HQ) / sqlite.org
- Talk
sqlite-users mailing list
SQLite Headquarters (HQ)
SQLite Documentation / History
SQLite Books
- The Definitive Guide to SQLite (2nd Edition)
by Mike Owens and Grant Allen; 2010; Apress; 368 pages
- Using SQLite
by Jay A. Kreibich; 2010, O'Reilly; 530 pages
- Getting Started with SQL - A Hands-On Approach for Beginners
by Thomas Nield; 2016; O'Reilly; 134 pages -- learn SQL with SQLite and SQLiteStudio
SQLite Modules / Extensions
https://github.com/nalgeon/sqlean
(github: ) by nalgeon
elau1004/TFR4SQLite
(github: ) by Edward Lau -- read any structured text file according to your parsing spec into SQLite
SQLite Derivates
sql-js/sql.js
(github: ) -- SQLite compiled to JavaScript (using asm.js) through Emscripten
SQLite-based Distributed Database
rqlite/rqlite
(github: ) by Philip O'Toole et al -- The lightweight, distributed relational database built on SQLite
Middleware
- SQLite ODBC Driver
coded by Christian Werner
- SQLite JDBC Driver (sqlite.jar)
a Java wrapper includes a basic JDBC driver for SQLite; coded by Christian Werner
SQLite JDBC Driver (sqlite-jdbc.jar)
a library for accessing SQLite databases through the JDBC API; coded by Taro L. Saito
Language Bindings
rstats-db/RSQLite
(github: , cran: ) -- SQLite interface for R
sparklemotion/sqlite3-ruby
(github: , gem: ) -- SQLite interface for Ruby
- system.data.sqlite.org
(web: ) -- a SQLite ActiveX Data Objects (ADO).NET driver with Language-Integrated Query (LINQ) and Entity Framework support; official support by SQLite HQ
- sqliteforexcel
(codeplex: ) -- SQLite wrapper for VBA
- lighter-swift/lighter
(github: , pkg: ) -- SQLite code generator and db packager for Swift
SQLite Admin Tools / Web
coleifer/sqlite-web
★217 (github: ) by Charles Leifer -- a web-based SQLite database browser written in Python
hypebeast/sqliteweb
★46 (github: ) by Sebastian Ruml -- a web-based SQLite database browser written in Go
- phpliteadmin.org
★31 (web: , github: ) -- a web-based SQLite database admin tool written in PHP
- extendsclass.com
(web: , github: by Cyril Bois -- a web-based SQLite database browser written in JavaScript
SQLite Admin Tools / Desktop
- sqlitestudio.pl
(web: ) - Linux, Windows, Mac OS X
- sqlitebrowser.org
★3,718 (web: , github: ) -- formerly known as SQLite Database Browser
- SQLite Toolbox
(codeplex: [sqlcetoolbox] ( )) -- Visual Studio extension (add-in); coded by Erik Ejlskov Jensen
DataStation
Easily query, script, and visualize data from every database, file, and API
SQLTorrent
Sqltorrent is a custom VFS for sqlite which allows applications to query an sqlite database contained within a torrent
SpatiaLite
SpatiaLite / SpatiaLite
SpatiaLite
Text-to-SQLite
textkit/datapak
(github: , gem: ) -- Ruby tool and library for working with tabular data packages (.csv files w/ .json) using SQLite (via ActiveRecord)
harelba/q
(github: -- Python script; lets you run SQL directly on CSV files
simonw/csvs-to-sqlite
(github: , pypi: ) -- Python command-line tool for loading one or more CSV files and converting them into a SQLite database
PostgreSQL-to-SQLite
- louis77/pg2sqlite
(codeberg: ) -- Go command-line tool for automatically migrating tables from PostgreSQL to SQLite incl. generating DDL
Misc
ggrothendieck/sqldf
(github: , cran: ) -- perform SQL selects on R data frames
vlcn-io/cr-sqlite
(github: ) - Convergent, Replicated, SQLite
benbjohnson/litestream
(github: ) - Streaming replication for SQLite
Schema Documentation Generators
rubylibs/schemadoc
(github: , gem: ) -- documents your database schemas (tables, columns, etc.); uses SQLite (via ActiveRecord)
inukshuk/sqleton
(github: ) by Sylvester Keil -- ['skelɪtən]; visualizes your SQLite database schema (requires graphviz)
SQLite Schemas
openfootball/schema.sql
(github: ) - teams, competitions, seasons, matches, goals, rounds, groups, etc
openbeer/schema.sql
(github: ) - beer, brand, brewery, etc
- chinookdatabase
(codeplex: ), - online music store (artists, albums, genres, playlists, media tracks, customers, invoices, employees) with sample data; inspired by the "classic" Microsoft Northwind database
jpwhite3/northwind-SQLite3
(github: , Swift pkg: ) - food store (customers, products, orders, employees, suppliers, ...) with sample data; port of the "classic" Microsoft Northwind database
SQLite Web Service (JSON API) Publishers / Containers
simonw/datasette
(github: ) by Simon Willison - an instant JSON API for your SQLite databases
lovasoa/sqlpage
(github: ) - build dynamic websites entirely in SQL on top of SQLite databases
Nothing in this list matches your filter.
Featured in 6 awesome lists
Each link jumps to the spot where the list mentions awesome-sqlite.