mlnsvbd/awesome-sqlite

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

awesome-sqlite

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

Note: stands for the GitHub page and 💎 stands for the RubyGems page.

---

[ANNOUNCEMENT] Looking for awesome world data (countries, cities, flags, languages, currencies, etc.)? See the Awesome World List @ Planet Open Data.

---

Contributions welcome. Anything missing? Send in a pull request. Thanks.

SQLite Headquarters (HQ)

Small. Fast. Reliable. Choose any three.

• sqlite.org
• Versions / Release History
  • 2013: 3.8.0 (Aug/26)
  • 2010: 3.7.0 (Jul/22)
• Talk - sqlite-users mailing list

Articles

• SQLite As An Application File Format
• In-Memory Databases

SQLite Documentation / History

• Article: SQLite @ Wikipedia

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

SQLite Modules / Extensions

• Text File Reader for SQLite (TFR4SQLite) - read any structured text file according to your parsing spec into SQLite

SQLite Derivates

• sql.js - SQLite compiled to JavaScript (using asm.js) through Emscripten

Middleware

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

Language Bindings

R Language

• RSQLite , (CRAN - Comprehensive R Archive Network) - SQLite interface for R

Ruby

• sqlite3 gem , 💎 - SQLite interface for Ruby

Microsoft .NET

• System.Data.SQLite - 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 - SQLite wrapper for VBA

and many more

SQLite Admin Tools

Major

• SQLiteStudio
• DB Browser for SQLite - - formerly known as SQLite Database Browser
• SQLite Toolbox - (Source) - Visual Studio extension (add-in); coded by Erik Ejlskov Jensen

Minor

• SQLite Expert - note: free personal edition and commercial "professional" edition
• SQLiteSpy
• SQLite Administrator

SpatiaLite

A spatial SQLite extension for vector geodata functionality

• SpatiaLite
  • libspatialite
  • SpatiaLite Command Line Tools
  • SpatiaLite Admin Tool
• Article: SpatiaLite @ Wikipedia

Text-to-SQLite

• datapak gem , 💎 - Ruby tool and library for working with tabular data packages (.csv files w/ .json) using SQLite (via ActiveRecord)
• q command line tool - Python script; lets you run SQL directly on CSV files

Misc

• R-Package sqldf , (CRAN - Comprehensive R Archive Network) - perform SQL selects on R data frames

Schema Documentation Generators

• schemadoc gem , 💎 - documents your database schemas (tables, columns, etc.); uses SQLite (via ActiveRecord)

SQLite Schemas

Ready-to-Use (Instant) Database Schemas

• football.db - teams, competitions, seasons, matches, goals, rounds, groups, etc.
• beer.db - beer, brand, brewery, etc.
• Chinook Database - (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

Meta

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!