awesome-sqlite

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

GitHub
316 stars
18 watching
36 forks
last commit: about 1 month 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,679 about 1 month ago (github: ) by nalgeon
elau1004/TFR4SQLite 19 about 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,579 2 months 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,617 5 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,804 9 days ago a library for accessing SQLite databases through the JDBC API; coded by Taro L. Saito

SQLite / Language Bindings
rstats-db/RSQLite 327 20 days ago (github: , cran: ) -- SQLite interface for R
sparklemotion/sqlite3-ruby 763 11 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,356 2 months 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,893 11 months ago Easily query, script, and visualize data from every database, file, and API
SQLTorrent 281 over 8 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 77 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,183 2 months ago (github: -- Python script; lets you run SQL directly on CSV files
simonw/csvs-to-sqlite 873 9 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,759 3 months ago (github: ) - Convergent, Replicated, SQLite
benbjohnson/litestream 10,716 about 2 months ago (github: ) - Streaming replication for SQLite

SQLite / Schema Documentation Generators
rubylibs/schemadoc 59 over 6 years ago (github: , gem: ) -- documents your database schemas (tables, columns, etc.); uses SQLite (via ActiveRecord)
inukshuk/sqleton 113 2 months ago (github: ) by Sylvester Keil -- ['skelɪtən]; visualizes your SQLite database schema (requires graphviz)

SQLite / SQLite Schemas
openfootball/schema.sql 48 about 4 years ago (github: ) - teams, competitions, seasons, matches, goals, rounds, groups, etc
openbeer/schema.sql 8 about 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 452 10 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,439 8 days ago (github: ) by Simon Willison - an instant JSON API for your SQLite databases
lovasoa/sqlpage 1,535 12 days ago (github: ) - build dynamic websites entirely in SQL on top of SQLite databases

Backlinks from these awesome lists: