awesome-sqlite

Database library

A curated collection of tools, scripts, books, and resources related to SQLite, a self-contained, serverless, zero-configuration, transactional SQL database engine.

A collection of awesome sqlite tools, scripts, books, etc

GitHub

331 stars

18 watching

36 forks

last commit: 3 months ago

Linked from 6 awesome lists

databasesqlsqlite

SQLite / SQLite Headquarters (HQ)
sqlite.org			(web: ) by D. Richard Hipp et al
SQLite / SQLite Headquarters (HQ) / sqlite.org
Versions / Release History
Talk			sqlite-users mailing list
SQLite / SQLite Headquarters (HQ)
SQLite As An Application File Format
In-Memory Databases
SQLite / SQLite Documentation / History
Article: SQLite @ Wikipedia
SQLite / 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 / SQLite Modules / Extensions
https://github.com/nalgeon/sqlean	3,763	about 1 month ago	(github: ) by nalgeon
elau1004/TFR4SQLite	19	over 1 year ago	(github: ) by Edward Lau -- read any structured text file according to your parsing spec into SQLite
SQLite / SQLite Derivates
sql-js/sql.js	12,788	23 days ago	(github: ) -- SQLite compiled to JavaScript (using asm.js) through Emscripten
Inside Punkbase - SQLite (SQL.js) In Action	24	about 1 year ago
SQLite / SQLite-based Distributed Database
rqlite/rqlite	15,790	6 days ago	(github: ) by Philip O'Toole et al -- The lightweight, distributed relational database built on SQLite
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)	2,849	16 days ago	a library for accessing SQLite databases through the JDBC API; coded by Taro L. Saito
SQLite / Language Bindings
rstats-db/RSQLite	327	4 days ago	(github: , cran: ) -- SQLite interface for R
sparklemotion/sqlite3-ruby	772	9 days ago	(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 / SQLite Admin Tools / Web
coleifer/sqlite-web	3,438	17 days ago	★217 (github: ) by Charles Leifer -- a web-based SQLite database browser written in Python
hypebeast/sqliteweb	100	over 9 years ago	★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 / 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	2,903	about 1 year ago	Easily query, script, and visualize data from every database, file, and API
SQLTorrent	281	almost 9 years ago	Sqltorrent is a custom VFS for sqlite which allows applications to query an sqlite database contained within a torrent
SQLite / SpatiaLite
SpatiaLite
SQLite / SpatiaLite / SpatiaLite
libspatialite
SpatiaLite Command Line Tools
SpatiaLite Admin Tool
SQLite / SpatiaLite
Article: SpatiaLite @ Wikipedia
SQLite / Text-to-SQLite
textkit/datapak	78	about 1 year ago	(github: , gem: ) -- Ruby tool and library for working with tabular data packages (.csv files w/ .json) using SQLite (via ActiveRecord)
harelba/q	10,206	4 months ago	(github: -- Python script; lets you run SQL directly on CSV files
simonw/csvs-to-sqlite	878	11 months ago	(github: , pypi: ) -- Python command-line tool for loading one or more CSV files and converting them into a SQLite database
SQLite / PostgreSQL-to-SQLite
louis77/pg2sqlite			(codeberg: ) -- Go command-line tool for automatically migrating tables from PostgreSQL to SQLite incl. generating DDL
SQLite / Misc
ggrothendieck/sqldf	249	about 1 year ago	(github: , cran: ) -- perform SQL selects on R data frames
vlcn-io/cr-sqlite	2,861	27 days ago	(github: ) - Convergent, Replicated, SQLite
benbjohnson/litestream	11,070	13 days ago	(github: ) - Streaming replication for SQLite
SQLite / Schema Documentation Generators
rubylibs/schemadoc	59	almost 7 years ago	(github: , gem: ) -- documents your database schemas (tables, columns, etc.); uses SQLite (via ActiveRecord)
inukshuk/sqleton	115	4 months ago	(github: ) by Sylvester Keil -- ['skelɪtən]; visualizes your SQLite database schema (requires graphviz)
SQLite / SQLite Schemas
openfootball/schema.sql	49	about 4 years ago	(github: ) - teams, competitions, seasons, matches, goals, rounds, groups, etc
openbeer/schema.sql	9	over 10 years ago	(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	468	12 months ago	(github: , Swift pkg: ) - food store (customers, products, orders, employees, suppliers, ...) with sample data; port of the "classic" Microsoft Northwind database
SQLite / SQLite Web Service (JSON API) Publishers / Containers
simonw/datasette	9,562	6 days ago	(github: ) by Simon Willison - an instant JSON API for your SQLite databases
lovasoa/sqlpage	1,634	4 days ago	(github: ) - build dynamic websites entirely in SQL on top of SQLite databases