Awesome Lists

awesome-sqlite

by planetopendata

awesome listpushed about 2 years ago

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
View on GitHub

Embed the badge

Show how many awesome lists link to your project. The count updates automatically.

Awesome Lists badge
Markdown
[![Awesome Lists Badge](https://awesome.facts.dev/shield/planetopendata/awesome-sqlite/links.svg)](https://awesome.facts.dev/awesome/planetopendata/awesome-sqlite)
HTML
<a href="https://awesome.facts.dev/awesome/planetopendata/awesome-sqlite"><img src="https://awesome.facts.dev/shield/planetopendata/awesome-sqlite/links.svg" alt="Awesome Lists Badge" /></a>
Image URL
https://awesome.facts.dev/shield/planetopendata/awesome-sqlite/links.svg

What's in the list

51 links in 21 sections, with live GitHub stats.activeno commit in 2y

SQLite Headquarters (HQ)

SQLite Headquarters (HQ) / sqlite.org

SQLite Headquarters (HQ)

SQLite Documentation / History

SQLite Books

SQLite Modules / Extensions

SQLite Derivates

SQLite-based Distributed Database

  • rqlite/rqlite

    (github: ) by Philip O'Toole et al -- The lightweight, distributed relational database built on SQLite

Middleware

Language Bindings

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

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

More related projects

Add a GitHub project

Missing a project or an awesome list? Paste its GitHub URL and we fetch it right away.