Datasette
Simon Willison
π‘ Pick it for publishing queryable SQLite data with an extensible open-source web interface.
Datasette is an open-source tool for publishing SQLite databases as browsable, queryable web applications and APIs. It is designed for developers and...
Pros
- Stronger out-of-the-box data browsing and API features than SQLPage
- Large plugin ecosystem built around SQLite and data publishing
- Excellent for read-only datasets and exploratory interfaces
Cons
- More focused on publishing data than building transactional websites
- Primarily centered on SQLite rather than multiple database engines
- Less suited to custom forms and multi-step business workflows
Free, open source