Awesome Series @ Planet Open Data
World (Countries, Cities, Codes, ...) • Football (Clubs, Players, Stadiums, ...) • SQLite (Tools, Books, Schemas, ...)
A collection of awesome sqlite tools, scripts, books, etc.
[ANNOUNCEMENT] Looking for awesome SQLite libraries in Ruby? See the Awesome ActiveRecord List @ Planet Ruby.
Small. Fast. Reliable. Choose any three.
- SQLite (web: sqlite.org) by D. Richard Hipp et al
- Versions / Release History
- 2013: 3.8.0 (Aug/26)
- 2010: 3.7.0 (Jul/22)
- Talk - sqlite-users mailing list
- Versions / Release History
Articles
- 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
- Text File Reader for SQLite (TFR4SQLite) (github: elau1004/TFR4SQLite) by Edward Lau -- read any structured text file according to your parsing spec into SQLite
- sql.js (github: kripken/sql.js) -- SQLite compiled to JavaScript (using asm.js) through Emscripten
Microsoft ODBC
- SQLite ODBC Driver - coded by Christian Werner
Java JDBC
- 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
R Language
- RSQLite (github: rstats-db/RSQLite, cran: RSQLite) -- SQLite interface for R
Ruby
- sqlite3 (github: sparklemotion/sqlite3-ruby, gem: sqlite3) -- SQLite interface for Ruby
Microsoft .NET
- System.Data.SQLite (web: system.data.sqlite.org) -- a SQLite ActiveX Data Objects (ADO).NET driver with Language-Integrated Query (LINQ) and Entity Framework support; official support by SQLite HQ
Visual Basic for Applications (VBA)
- SQLite for Excel (codeplex: sqliteforexcel) -- SQLite wrapper for VBA
and many more
- sqlite-web ★217 (github: coleifer/sqlite-web) by Charles Leifer -- a web-based SQLite database browser written in Python
- sqliteweb ★46 (github: hypebeast/sqliteweb) by Sebastian Ruml -- a web-based SQLite database browser written in Go
- phpliteadmin ★31 (web: phpliteadmin.org, github: phpLiteAdmin/pla) -- a web-based SQLite database admin tool written in PHP
- web gui for sqlite (web: extendsclass.com, github: hautdefrance/Web-GUI-for-SQLite by Cyril Bois -- a web-based SQLite database browser written in JavaScript
Major
- SQLiteStudio (web: sqlitestudio.pl) - Linux, Windows, Mac OS X
- DB Browser for SQLite ★3,718 (web: sqlitebrowser.org, github: sqlitebrowser/sqlitebrowser) -- formerly known as SQLite Database Browser
- SQLite Toolbox (codeplex: [sqlcetoolbox] (http://sqlcetoolbox.codeplex.com)) -- Visual Studio extension (add-in); coded by Erik Ejlskov Jensen
Minor
- SQLite Expert - note: free personal edition and commercial "professional" edition
- SQLiteSpy
- SQLite Administrator
A spatial SQLite extension for vector geodata functionality
- datapak (github: textkit/datapak, gem: datapak) -- Ruby tool and library for working with tabular data packages (.csv files w/ .json) using SQLite (via ActiveRecord)
- q command line tool (github: harelba/q -- Python script; lets you run SQL directly on CSV files
- csvs-to-sqlite (github: simonw/csvs-to-sqlite, pypi: csvs-to-sqlite) -- Python command-line tool for loading one or more CSV files and converting them into a SQLite database
- R-Package sqldf (github: ggrothendieck/sqldf, cran: sqldf) -- perform SQL selects on R data frames
- schemadoc (github: rubylibs/schemadoc, gem: schemadoc) -- documents your database schemas (tables, columns, etc.); uses SQLite (via ActiveRecord)
- sqleton (github: inukshuk/sqleton) by Sylvester Keil -- ['skelɪtən]; visualizes your SQLite database schema (requires graphviz)
Ready-to-Use (Instant) Database Schemas
- football.db (github: openfootball/schema.sql) - teams, competitions, seasons, matches, goals, rounds, groups, etc.
- beer.db (github: openbeer/schema.sql) - beer, brand, brewery, etc.
- Chinook Database (codeplex: chinookdatabase), (chinook.sqlite Download) - online music store (artists, albums, genres, playlists, media tracks, customers, invoices, employees) with sample data; inspired by the "classic" Microsoft Northwind database
Turn your Database into Ready-to-Use (Instant) Online Web Services (JSON APIs) w/ Query Language (QL)
- Datasette (github: simonw/datasette) by Simon Willison - an instant JSON API for your SQLite databases
License
The awesome list is dedicated to the public domain. Use it as you please with no restrictions whatsoever.
Questions? Comments?
Send them along to the sqlite-users mailing list. Thanks!