Datasette¶
An open source multi-tool for exploring and publishing data
Datasette is a tool for exploring and publishing data. It helps people take data of any shape or size and publish that as an interactive, explorable website and accompanying API.
Datasette is aimed at data journalists, museum curators, archivists, local governments and anyone else who has data that they wish to share with the world. It is part of a wider ecosystem of tools and plugins dedicated to making working with structured data as productive as possible.
Explore a demo, watch a presentation about the project or Try Datasette without installing anything using Glitch.
More examples: https://github.com/simonw/datasette/wiki/Datasettes
Support questions, feedback? Join our GitHub Discussions forum.
Contents¶
- Getting started
- Installation
- The Datasette Ecosystem
- Tools for creating SQLite databases
- Datasette Plugins
- datasette-graphql
- datasette-cluster-map
- datasette-vega
- datasette-auth-github
- datasette-auth-tokens
- datasette-permissions-sql
- datasette-upload-csvs
- datasette-json-html
- datasette-atom
- datasette-ics
- datasette-init
- datasette-write
- datasette-media
- datasette-jellyfish
- datasette-doublemetaphone
- datasette-jq
- datasette-rure
- datasette-render-images
- datasette-render-binary
- datasette-render-markdown
- datasette-render-html
- datasette-leaflet-geojson
- datasette-pretty-json
- datasette-saved-queries
- datasette-haversine
- datasette-sqlite-fts4
- datasette-bplist
- datasette-cors
- datasette-template-sql
- datasette-mask-columns
- datasette-auth-existing-cookies
- datasette-sentry
- datasette-publish-fly
- Pages and API endpoints
- Publishing data
- Deploying Datasette
- JSON API
- Running SQL queries
- Authentication and permissions
- Performance and caching
- CSV export
- Binary data
- Facets
- Full-text search
- SpatiaLite
- Metadata
- Settings
- Using --setting
- Configuration directory mode
- Settings
- default_page_size
- sql_time_limit_ms
- max_returned_rows
- num_sql_threads
- allow_facet
- default_facet_size
- facet_time_limit_ms
- facet_suggest_time_limit_ms
- suggest_facets
- allow_download
- default_cache_ttl
- default_cache_ttl_hashed
- cache_size_kb
- allow_csv_stream
- max_csv_mb
- truncate_cells_html
- force_https_urls
- hash_urls
- template_debug
- base_url
- Configuring the secret
- Using secrets with datasette publish
- Introspection
- Custom pages and templates
- Plugins
- Writing plugins
- Plugin hooks
- prepare_connection(conn, database, datasette)
- prepare_jinja2_environment(env)
- extra_template_vars(template, database, table, columns, view_name, request, datasette)
- extra_css_urls(template, database, table, columns, view_name, request, datasette)
- extra_js_urls(template, database, table, columns, view_name, request, datasette)
- extra_body_script(template, database, table, columns, view_name, request, datasette)
- publish_subcommand(publish)
- render_cell(value, column, table, database, datasette)
- register_output_renderer(datasette)
- register_routes()
- register_facet_classes()
- asgi_wrapper(datasette)
- startup(datasette)
- canned_queries(datasette, database, actor)
- actor_from_request(datasette, request)
- permission_allowed(datasette, actor, action, resource)
- register_magic_parameters(datasette)
- forbidden(datasette, request, message)
- menu_links(datasette, actor)
- table_actions(datasette, actor, database, table)
- database_actions(datasette, actor, database)
- Testing plugins
- Internals for plugins
- Request object
- The MultiParams class
- Response class
- Datasette class
- .plugin_config(plugin_name, database=None, table=None)
- await .render_template(template, context=None, request=None)
- await .permission_allowed(actor, action, resource=None, default=False)
- .get_database(name)
- .add_database(name, db)
- .remove_database(name)
- .sign(value, namespace="default")
- .unsign(value, namespace="default")
- .add_message(request, message, message_type=datasette.INFO)
- .absolute_url(request, path)
- .setting(key)
- datasette.client
- datasette.urls
- Database class
- CSRF protection
- Contributing
- Changelog
- 0.52.1 (2020-11-29)
- 0.52 (2020-11-28)
- 0.51.1 (2020-10-31)
- 0.51 (2020-10-31)
- 0.50.2 (2020-10-09)
- 0.50.1 (2020-10-09)
- 0.50 (2020-10-09)
- 0.49.1 (2020-09-15)
- 0.49 (2020-09-14)
- 0.48 (2020-08-16)
- 0.47.3 (2020-08-15)
- 0.47.2 (2020-08-12)
- 0.47.1 (2020-08-11)
- 0.47 (2020-08-11)
- 0.46 (2020-08-09)
- 0.45 (2020-07-01)
- 0.44 (2020-06-11)
- 0.43 (2020-05-28)
- 0.42 (2020-05-08)
- 0.41 (2020-05-06)
- 0.40 (2020-04-21)
- 0.39 (2020-03-24)
- 0.38 (2020-03-08)
- 0.37.1 (2020-03-02)
- 0.37 (2020-02-25)
- 0.36 (2020-02-21)
- 0.35 (2020-02-04)
- 0.34 (2020-01-29)
- 0.33 (2019-12-22)
- 0.32 (2019-11-14)
- 0.31.2 (2019-11-13)
- 0.31.1 (2019-11-12)
- 0.31 (2019-11-11)
- 0.30.2 (2019-11-02)
- 0.30.1 (2019-10-30)
- 0.30 (2019-10-18)
- 0.29.3 (2019-09-02)
- 0.29.2 (2019-07-13)
- 0.29.1 (2019-07-11)
- 0.29 (2019-07-07)
- 0.28 (2019-05-19)
- 0.27.1 (2019-05-09)
- 0.27 (2019-01-31)
- 0.26.1 (2019-01-10)
- 0.26 (2019-01-02)
- 0.25.2 (2018-12-16)
- 0.25.1 (2018-11-04)
- 0.25 (2018-09-19)
- 0.24 (2018-07-23)
- 0.23.2 (2018-07-07)
- 0.23.1 (2018-06-21)
- 0.23 (2018-06-18)
- 0.22.1 (2018-05-23)
- 0.22 (2018-05-20)
- 0.21 (2018-05-05)
- 0.20 (2018-04-20)
- 0.19 (2018-04-16)
- 0.18 (2018-04-14)
- 0.17 (2018-04-13)
- 0.16 (2018-04-13)
- 0.15 (2018-04-09)
- 0.14 (2017-12-09)
- 0.13 (2017-11-24)
- 0.12 (2017-11-16)
- 0.11 (2017-11-14)
- 0.10 (2017-11-14)
- 0.9 (2017-11-13)
- 0.8 (2017-11-13)