Open source gems

Datasette

An open source tool for publishing, exploring, and sharing SQLite-backed data as a small web app.

Open original

What it is

Datasette is a gem because it makes a humble SQLite file feel like a shareable public data product.

Why worth a look

An open source tool for publishing, exploring, and sharing SQLite-backed data as a small web app.

Good for

  • Publishing a small dataset without building a custom backend.
  • Letting readers inspect tables and run lightweight queries.

How to start

  1. Put one cleaned CSV into SQLite.
  2. Run Datasette locally before adding plugins.

Best first click

Open Datasette and start here: Put one cleaned CSV into SQLite.

Trust facts

Pricing
Free
Login required
No
Open source
Yes
API available
No
License
Open-source license; verify the project repository.
Risk
Pricing, login requirements, and availability can change; last human check: 2026-07-08.

Similar gems

ExcalidrawAn open source whiteboard for sketchy diagrams, quick architecture maps, and collaborative visual thinking.MetabaseAn open source business intelligence tool for asking questions, building dashboards, and sharing data views.

Source links