simonw/datasette
Datasette
Datasette is a tool for publishing and sharing SQLite databases as public websites. It functions as a data publishing system that provides searchable interfaces and JSON APIs to expose the contents of SQLite files.
The project enables both server-side and client-side execution. It can operate as an API server or as a database browser that runs entirely within a web browser using WebAssembly, allowing for serverless database access.
The system supports a variety of deployment strategies, including containerized images for cloud hosting and a local development server for testing. It includes capabilities for database exploration, dynamic query generation, and the management of dataset metadata such as licensing and source information.
Features
- Dataset Publishing Tools - Ships a complete system for publishing SQLite databases as searchable public websites with integrated APIs.
- SQLite Databases - Utilizes SQLite as the primary serverless, single-file relational database engine for data storage.
- Dataset Publishing - Shares SQLite datasets over the web via a searchable interface and API for public transparency.
- Publishing Platforms - Functions as a publishing platform to make SQLite databases searchable and accessible via the web.
- Dynamic SQL Generators - Translates user interface interactions into structured SQL queries to fetch and filter database content.
- JSON API Servers - Provides a JSON-based API layer to programmatically expose the contents of SQLite databases.
- Public Datasets - Enables the exposure of SQLite data over the web for public consumption and distribution.
- WebAssembly Engines - Runs the database engine directly in the browser using WebAssembly to enable serverless data exploration.
- SQLite Integration - Provides direct support for querying and browsing SQLite database files through a web interface.
- Interactive Explorers - Ships an interactive web interface for browsing, querying, and visualizing data stored in SQLite files.
- Client-Side Serverless Access - Uses WebAssembly to run database queries entirely within a web browser, removing the need for backend servers.
- WebAssembly - Runs the entire application stack within a web browser using WebAssembly to eliminate server dependencies.
- JSON APIs - Exposes database contents and query results through a structured JSON API for programmatic access.
- Cloud Container Deployments - Packages databases and the application into container images optimized for cloud platform deployment.
- Cloud Hosting - Provides workflows for hosting containerized databases on cloud platforms for public access.
- Container Deployment - Supports packaging the application and its data into portable container images for consistent cloud execution.
- Containerized Deployments - Supports standardized packaging of the application into portable containers for consistent execution.
- Containerized Platforms - Provides a complete software environment for SQLite publishing packaged as a containerized unit.
- API Generation - Tool for exploring and publishing data as an API.
- Data Analysis - Tool for exploring and publishing data.
- Database and Storage Tools - Tool for exploring and publishing data via SQLite.
- Database Management - Multi-tool for exploring and publishing database data.
- End-User Applications - Tool for exploring and publishing data via compatible components.
- SQLite Web Service (JSON API) Publishers / Containers - Listed in the “SQLite Web Service (JSON API) Publishers / Containers” section of the Awesome Sqlite awesome list.
Star history
How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.
