Datasette turns a database into an interactive website and JSON API, so anyone can browse, filter, and query the data without a custom backend. Point it at SQLite files and each table gets a page with sortable columns, per-column filters, full-text search where it is enabled, and facets that tally the values in a column, including array and date columns, with suggested facets surfaced automatically. Rows have their own URLs, foreign keys become links, and a row that other tables reference links to a filtered list of those records. A "View and edit SQL" link turns whatever filters you applied into an editable query, and visitors with permission can run read-only SQL with named parameters. Useful queries save as canned queries with their own URLs, and writable canned queries add forms that insert or update rows. Every page comes as JSON and as streaming CSV. A metadata file adds titles, licenses, sources, column descriptions, units, default sort orders, and hidden tables. Access rules can apply to the whole instance or a single database, table, or query. Plugins add charts, maps for latitude and longitude columns, Atom feeds, GitHub sign-in, and custom output formats. Custom templates, CSS, and static files carry your branding. SpatiaLite support adds geospatial queries, and datasette publish deploys to Google Cloud Run, Heroku, Vercel, or Fly. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. Apache-2.0 licensed.

CKAN lets governments, research institutions, and companies publish data as a searchable catalog, where every dataset carries its description, license, tags, and downloadable files. Organizations own their datasets, and members, editors, and admins get different rights, so a dataset can stay private until someone with publishing rights releases it. Visitors narrow results with faceted filters on tags, formats, and organizations, or write fielded queries with wildcards and fuzzy matching. Resource pages preview spreadsheets in a grid and, when the data fits, as maps and charts, and they also display images, PDFs, and HTML. The DataStore keeps tabular resources as queryable tables, serving filtered rows with range conditions and nested AND/OR logic. Everything the web interface does is also available through the Action API. Groups gather related datasets, and custom metadata fields extend each record. Per-dataset activity streams document how data changes, and follow buttons feed a personal news feed. Files can be stored on local disk or, with extensions, in S3, Google Cloud Storage, or Azure Blob Storage. Extensions add geospatial search, harvesting for federated portals, multilingual metadata, and more chart types, and themes restyle the portal to match your brand. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. AGPL-3.0 licensed.