How to load JSON into a SQLite database all in one go using Python.
SQLite has a JSON datatype, so it's possible to load JSON objects into columns. There still needs to be a unique key for each entry, though.
Convert CSV files into a SQLite database. Designed for use with Datasette. Requires Python 3.
Datasette provides an instant, read-only JSON API for any SQLite database, even those applications on your system maintain. It also provides tools for packaging the database up as a Docker container and deploying that container to hosting providers such as Zeit Now. Got CSV data? Use csvs-to-sqlite to convert them to SQLite. Runs its own webserver on localhost:8001 so you don't need to write code to use it, just point it at a .sqlite3 file.
Requires Python 3.
A free, open source application that makes manipulating SQLite databases easier. Designed with both people who aren't skilled with databases and administrators in mind.
How to use PySQLite to interact with SQLite databases.
A single-file database administration utility written in PHP. Supports MySQL, PostgreSQL, SQLite, MS SQL, and Oracle database servers. Formerly phpMyAdmin. Seems to let you do everything you could do from a database shell. Session-aware. Has plugins for a number of popular web apps to help you fix their databases should you need to. Easily themeable, just drop a new CSS file into the directory Adminer is installed in.
A document oriented noSQL database server that uses SQLite as its back end. Written in Python. Network aware. Requires no configuration. Claims to be lightweight.
A distributed relational database that uses SQLite as its back end. Eventual consensus of all nodes that relies upon quorum. Automatically elects leaders in the network of servers. More lightweight than MySQL or Postgres. Has a REST API built in. Fully transactional. Hot backups possible. Uses SQLite in "all in memory" mode by default for efficiency, but can maintain on-disk database files with a command line option (the on-disk transaction log can be used to repopulate the in-memory database on startup). Written in Go.
A map dataset in the public domain. Multiple scales of resolution available (1:10m, 1:50m, 1:110 million). Vector and raster images. Incorporates GIS attributes for mapmaking. Designed to make it easy to develop maps on your own. Comes as ArcMap MXD and QGIS documents. You can also download entire databases (even SQLite) all in one go.
A server-based chan like BBS written in C. No registration, just post. Supports tripcodes. futaba style. Aggressive content turnover. Requires lighttpd (probably) as its front-end, sqlite backend.
Python module that uses sqlite as the back-end for storing hash tables. Rather than working with a dict, you instantiate a copy as mydict or something, and it works the same way. Multiple hash tables can be stored in the same file. Useful so you don't have to figure out how to do it yourself, I guess?
Kareha doesn't use a database, Wakaba does.