Are you over 18 and want to see adult content?
More Annotations
![A complete backup of https://www.kaufmich.com/Lilly.1996](https://www.archivebay.com/archive6/images/917498e7-f203-4402-b4bf-bb7ef2bbffad.png)
A complete backup of https://www.kaufmich.com/Lilly.1996
Are you over 18 and want to see adult content?
![A complete backup of https://sandhyaaunty.blogspot.com/2015/](https://www.archivebay.com/archive6/images/9b6b5dd5-adbc-4f70-9387-d277b12f598c.png)
A complete backup of https://sandhyaaunty.blogspot.com/2015/
Are you over 18 and want to see adult content?
![A complete backup of https://www.comico.in.th/novel/titles/1544](https://www.archivebay.com/archive6/images/6877aa66-f039-4a7b-8d9b-f741a04bb84f.png)
A complete backup of https://www.comico.in.th/novel/titles/1544
Are you over 18 and want to see adult content?
![A complete backup of https://www.urajp.eu/category/urajp/music/page/796/](https://www.archivebay.com/archive6/images/2f607e62-6b63-4a2b-8aa8-236277f6d655.png)
A complete backup of https://www.urajp.eu/category/urajp/music/page/796/
Are you over 18 and want to see adult content?
![A complete backup of https://dramasq.com/cn180723/](https://www.archivebay.com/archive6/images/0dae22bf-7f00-4ce1-98a4-e844853d5ced.png)
A complete backup of https://dramasq.com/cn180723/
Are you over 18 and want to see adult content?
![A complete backup of https://www.urajp.eu/category/urajp/page/1713/](https://www.archivebay.com/archive6/images/d73c8249-1120-475e-bf77-7f5bfe1dfd89.png)
A complete backup of https://www.urajp.eu/category/urajp/page/1713/
Are you over 18 and want to see adult content?
![A complete backup of https://keywordspace.com/site-info/wap1.indotogel.net](https://www.archivebay.com/archive6/images/c3c3dee5-c7d9-4278-bd7d-fd904ea0f423.png)
A complete backup of https://keywordspace.com/site-info/wap1.indotogel.net
Are you over 18 and want to see adult content?
![A complete backup of https://greatlakespubcruiser.com/](https://www.archivebay.com/archive6/images/8c7353dc-25b8-43a7-aa5c-fd2d560e2675.png)
A complete backup of https://greatlakespubcruiser.com/
Are you over 18 and want to see adult content?
![A complete backup of https://koreangossip.net/episod/mostenitorii-1x3/](https://www.archivebay.com/archive6/images/b6b39d3d-3f52-45b3-8f7c-4c7d818a8089.png)
A complete backup of https://koreangossip.net/episod/mostenitorii-1x3/
Are you over 18 and want to see adult content?
Favourite Annotations
![A complete backup of highschoolot.com](https://www.archivebay.com/archive/262f3b62-5ada-4baf-8912-c5910fa47bf0.png)
A complete backup of highschoolot.com
Are you over 18 and want to see adult content?
![A complete backup of sudo-sekizai.co.jp](https://www.archivebay.com/archive/1a9f0e81-bedb-4513-9e0e-8286e18210f4.png)
A complete backup of sudo-sekizai.co.jp
Are you over 18 and want to see adult content?
![A complete backup of sklep-ogrodnik.pl](https://www.archivebay.com/archive/c30876c3-4321-4bc8-95d0-9817bbbaa9b2.png)
A complete backup of sklep-ogrodnik.pl
Are you over 18 and want to see adult content?
![A complete backup of catholicchemistry.com](https://www.archivebay.com/archive/7ded2b3f-179e-4952-a93e-1c083410ea97.png)
A complete backup of catholicchemistry.com
Are you over 18 and want to see adult content?
![A complete backup of archivesofrheumatology.org](https://www.archivebay.com/archive/3d2940f2-66ea-4b65-9933-ec6596471bcb.png)
A complete backup of archivesofrheumatology.org
Are you over 18 and want to see adult content?
![A complete backup of magnolianfarewell.tumblr.com](https://www.archivebay.com/archive/581be8ed-744a-4a60-8a3b-9d0d64d55e60.png)
A complete backup of magnolianfarewell.tumblr.com
Are you over 18 and want to see adult content?
![A complete backup of respiratorytherapistlicense.com](https://www.archivebay.com/archive/985c4fc3-12e7-4f1b-9e44-e64689c6820b.png)
A complete backup of respiratorytherapistlicense.com
Are you over 18 and want to see adult content?
![A complete backup of vpsforextrader.com](https://www.archivebay.com/archive/24b6a401-945a-4c49-b73f-2733d1558acb.png)
A complete backup of vpsforextrader.com
Are you over 18 and want to see adult content?
![A complete backup of tantuvistudio.com](https://www.archivebay.com/archive/01d05279-6064-44fc-813b-a095915a7038.png)
A complete backup of tantuvistudio.com
Are you over 18 and want to see adult content?
Text
Skip to content
* Why GitHub?
Features →
* Code review
* Project management* Integrations
* Actions
* Packages
* Security
* Team management
* Hosting
* Customer stories →* Security →
* Enterprise
* Explore
* Explore GitHub →LEARN & CONTRIBUTE
* Topics
* Collections
* Trending
* Learning Lab
* Open source guidesCONNECT WITH OTHERS
* Events
* Community forum
* GitHub Education
* Marketplace
* Pricing
Plans →
* Compare plans
* Contact Sales
* Nonprofit →
* Education →
*
In this repository All GitHub ↵Jump to ↵
* No suggested jump to results*
In this repository All GitHub ↵Jump to ↵
*
In this repository All GitHub ↵Jump to ↵
Sign in Sign up
SIMONW / DATASETTE
* Watch 70
* Star 3.2k
* Fork 185
Code
Issues 153
Pull requests 11
Actions
Projects 0
Wiki
Security
Insights
Dismiss
JOIN GITHUB TODAY
GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.Sign up
A tool for exploring and publishing data http://datasette.readthedocs.io/ sqlite python datasetsjson docker
datasette automatic-api asgi csv datasette-iosql
* 923 commits
* 79 branches
* 0 packages
* 48 releases
* 28 contributors
* Apache-2.0
Python HTML CSS Dockerfile* Python 93.6%
* HTML 4.9%
* CSS 1.2%
* Dockerfile 0.3%
_Branch:_ master
New pull request
Find file Clone or downloadCLONE WITH HTTPS
Use Git or checkout with SVN using the web URL.Download ZIP
DOWNLOADING
Want to be notified of new releases in simonw/datasette?Sign in
Sign
up
LAUNCHING GITHUB DESKTOP If nothing happens, download GitHub Desktopand try again.
Go back
LAUNCHING GITHUB DESKTOP If nothing happens, download GitHub Desktopand try again.
Go back
LAUNCHING XCODE
If nothing happens, download Xcodeand try again.
Go back
LAUNCHING VISUAL STUDIO If nothing happens, download the GitHub extension for Visual Studioand try again.
Go back
LATEST COMMIT
simonw Release 0.38 Loading status checks… Latest commit 7e357ab6
days ago
FILES
Permalink
TYPE
NAME
LATEST COMMIT MESSAGECOMMIT TIME
Failed to load latest commit information.datasette
Do not look for templates_path in default plugins6 days ago
docs
Release 0.38
6 days ago
tests
Do not look for templates_path in default plugins6 days ago
.dockerignore
Expose current git tag to Docker build,closes
#399
14 months ago
.gitattributes
Mark codemirror files as vendored (#367
)
11 months ago
.gitignore
New run_sanity_checks mechanism, for SpatiLite10 months ago
.isort.cfg
Used isort to re-order my imports2 years ago
.travis.yml
Added template_debug setting,closes
#654
3 months ago
Dockerfile
Upgrade Dockerfile to SQLite 3.31.1,closes
#695
8 days ago
LICENSE
Initial commit
2 years ago
MANIFEST.in
Add version number support with Versioneer2 years ago
README.md
Release 0.38
6 days ago
_config.yml
Set theme jekyll-theme-architect2 years ago
pytest.ini
Port Datasette from Sanic to ASGI + Uvicorn (#518
)
9 months ago
setup.cfg
Add a max-line-length setting for flake8 (#444
)
11 months ago
setup.py
.execute_write() and .execute_write_fn() methods on Database (#683
)
18 days ago
update-docs-help.py
Apply Black, update copyright to be 2017-2020last month
versioneer.py
Apply Black, update copyright to be 2017-2020last month
README.MD
DATASETTE
_A 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 sharewith the world.
Explore a demo
, watch a
video about the project or try it out by uploading and publishing your own CSV data.
* Comprehensive documentation: http://datasette.readthedocs.io/ * Examples: https://github.com/simonw/datasette/wiki/Datasettes * Live demo of current master: https://latest.datasette.io/NEWS
* 8th March 2020: Datasette 0.38- New
--memory option for datasete publish cloudrun, Docker imageupgraded to
SQLite 3.31.1.
* 25th February 2020: Datasette 0.37- new
internal APIs enabling plugins to safely write to databases. Read more here: Datasette Writes.
* 21st February 2020: Datasette 0.36- new
internals documentation for plugins, prepare_connection() now accepts optional database and datasette arguments. * 4th February 2020: Datasette 0.35- new
.render_template() method for plugins. * 29th January 2020: Datasette 0.34-
improvements to search, datasette publish cloudrun and datasettepackage.
* 21st January 2020: Deploying a data API using GitHub Actions andCloud Run
-
how to use GitHub Actions and Google Cloud Run to automatically scrape data and deploy the result as an API with Datasette. * 22nd December 2019: Datasette 0.33-
various small improvements. * 19th December 2019: Building tools to bring data-driven reportingto more newsrooms
- some notes on my JSK fellowship so far. * 2nd December 2019: Niche Museums is a new site entirely powered by Datasette, using custom templates and plugins. niche-museums.com, powered by Datasettedescribes how
the site works, and datasette-atom: Define an Atom feed using a customSQL query
describes how the new datasette-atom plugin was used to add an Atom syndication feed to the site. * 14th November 2019: Datasette 0.32now
uses asynchronous rendering in Jinja templates, which means template functions can perform asynchronous operations such as executing SQL queries. datasette-template-sqlis a new plugin
uses this capability to add a new custom sql(sql_query) templatefunction.
* 11th November 2019: Datasette 0.31-
the first version of Datasette to support Python 3.8, which means dropping support for Python 3.5. * 18th October 2019: Datasette 0.30 * 13th July 2019: Single sign-on against GitHub using ASGImiddleware talks
about the implementation of datasette-auth-githubin more detail.
* 7th July 2019: Datasette 0.29-
ASGI, new plugin hooks, facet by date and much, much more... * datasette-auth-github- a new plugin for
Datasette 0.29 that lets you require users to authenticate against GitHub before accessing your Datasette instance. You can whitelist specific users, or you can restrict access to members of specific GitHub organizations or teams. * datasette-cors - a plugin that lets you configure CORS access from a list of domains (or a set of domain wildcards) so you can make JavaScript calls to a Datasette instance from a specific set of other hosts. * 23rd June 2019: Porting Datasette to ASGI, and Turtles all the waydown
* 21st May 2019: The anonymized raw data from the Stack Overflow Developer Survey 2019 has been published in partnership with Glitch,
powered by Datasette. * 19th May 2019: Datasette 0.28- a
salmagundi of new features! * No longer immutable! Datasette now supports databases that change.
* Faceting improvements including facet-by-JSON-array and the ability to define custom faceting using plugins. * datasette publish cloudrun lets you publish databases to Google's new Cloud Run hosting service. * New register_output_renderer plugin hook for adding custom output extensions to Datasette in addition to the default .json and .csv. * Dozens of other smaller features and tweaks - see the releasenotes
for
full details.
* Read more about this release here: Datasette 0.28—and why master should always be releasable * 24th February 2019: sqlite-utils: a Python library and CLI tool for building SQLite databases- a partner tool
for easily creating SQLite databases for use with Datasette. * 31st Janary 2019: Datasette 0.27-
datasette plugins command, newline-delimited JSON export option, new documentation on The Datasette Ecosystem.
* 10th January 2019: Datasette 0.26.1-
SQLite upgrade in Docker image, /-/versions now shows SQLite compileoptions.
* 2nd January 2019: Datasette 0.26-
minor bug fixes, datasette publish now --alias argument. * 18th December 2018: Fast Autocomplete Search for Your Website-
a new tutorial on using Datasette to build a JavaScript autocompletesearch engine.
* 3rd October 2018: The interesting ideas in Datasette- a write-up
of some of the less obvious interesting ideas embedded in theDatasette project.
* 19th September 2018: Datasette 0.25- New
plugin hooks, improved database view support and an easier way to use more recent versions of SQLite. * 23rd July 2018: Datasette 0.24- a
number of small new features * 29th June 2018: datasette-vega, a new plugin for
visualizing data as bar, line or scatter charts * 21st June 2018: Datasette 0.23.1-
minor bug fixes
* 18th June 2018: Datasette 0.23: CSV, SpatiaLite and more- CSV
export, foreign key expansion in JSON and CSV, new config options, improved support for SpatiaLite and a bunch of other improvements * 23rd May 2018: Datasette 0.22.1 bugfixplus we now
use versioneer
* 20th May 2018: Datasette 0.22: Datasette Facets * 5th May 2018: Datasette 0.21: New _shape=, new _size=, searchwithin columns
* 25th April 2018: Exploring the UK Register of Members Interests with SQL and Datasette-
a tutorial describing how register-of-members-interests.datasettes.comwas built
(source code here
)
* 20th April 2018: Datasette plugins, and building a clustered mapvisualization
-
introducing Datasette's new plugin system and datasette-cluster-map, a plugin for
visualizing data on a map * 20th April 2018: Datasette 0.20: static assets and templates forplugins
* 16th April 2018: Datasette 0.19: plugins preview * 14th April 2018: Datasette 0.18: units * 9th April 2018: Datasette 0.15: sort by column * 28th March 2018: Baltimore Sun Public Salary Records- a
data journalism project from the Baltimore Sun powered by Datasette - source code is available here * 27th March 2018: Cloud-first: Rapid webapp deployment usingcontainers
- a tutorial covering deploying Datasette using Microsoft Azure by the Research Software Engineering team at Imperial College London * 28th January 2018: Analyzing my Twitter followers with Datasette - a tutorial on using Datasette to analyze follower data pulled fromthe Twitter API
* 17th January 2018: Datasette Publish: a web app for publishing CSV files as an online database * 12th December 2017: Building a location to time zone API with SpatiaLite, OpenStreetMap and Datasette * 9th December 2017: Datasette 0.14: customization edition * 25th November 2017: New in Datasette: filters, foreign keys andsearch
* 13th November 2017: Datasette: instantly create and publish an API for your SQLite databasesINSTALLATION
pip3 install datasette Datasette requires Python 3.6 or higher. We also have detailed installation instructions covering other options such as Docker.BASIC USAGE
datasette serve path/to/database.db This will start a web server on port 8001 - visit http://localhost:8001/ to access the web interface. serve is the default subcommand, you can omit it if you like. Use Chrome on OS X? You can run datasette against your browser historylike so:
datasette ~/Library/Application\ Support/Google/Chrome/Default/History Now visiting http://localhost:8001/History/downloads will show you a web interface to browse your downloads data: DATASETTE SERVE OPTIONS Usage: datasette serve ... Serve up specified SQLite database files with a web UIOptions:
-i, --immutable PATH Database files to open in immutable mode -h, --host TEXT Host for server. Defaults to 127.0.0.1 which means only connections from the local machine will be allowed. Use 0.0.0.0 to listen to all IPs and allow access from other machines. -p, --port INTEGER Port for server, defaults to 8001 --debug Enable debug mode - useful for development --reload Automatically reload if database or code change detected - useful for development --cors Enable CORS by serving Access-Control-Allow-Origin: *
--load-extension PATH Path to a SQLite extension to load --inspect-file TEXT Path to JSON file created using "datasetteinspect"
-m, --metadata FILENAME Path to JSON file containing license/sourcemetadata
--template-dir DIRECTORY Path to directory containing custom templates --plugins-dir DIRECTORY Path to directory containing custom plugins --static STATIC MOUNT mountpoint:path-to-directory for serving staticfiles
--memory Make :memory: database available --config CONFIG Set config option using configname:value datasette.readthedocs.io/en/latest/config.html --version-note TEXT Additional note to show on /-/versions --help-config Show available config options --help Show this message and exit.METADATA.JSON
If you want to include licensing and source information in the generated datasette website you can do so using a JSON file that looks something like this:{
"title": "Five Thirty Eight", "license": "CC Attribution 4.0 License", "license_url": "http://creativecommons.org/licenses/by/4.0/", "source": "fivethirtyeight/data on GitHub", "source_url": "https://github.com/fivethirtyeight/data"}
Save this in metadata.json and run Datasette like so: datasette serve fivethirtyeight.db -m metadata.json The license and source information will be displayed on the index page and in the footer. They will also be included in the JSON produced bythe API.
DATASETTE PUBLISH
If you have Heroku , Google Cloud Runor Zeit Now v1
configured, Datasette can deploy one or more SQLite databases to the internet with a single command: datasette publish heroku database.dbOr:
datasette publish cloudrun database.db This will create a docker image containing both the datasette application and the specified SQLite database files. It will then deploy that image to Heroku or Cloud Run and give you a URL to access the resulting website and API.See Publishing data
in the
documentation for more details. * © 2020 GitHub, Inc.* Terms
* Privacy
* Security
* Status
* Help
* Contact GitHub
* Pricing
* API
* Training
* Blog
* About
You can’t perform that action at this time. You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refreshyour session.
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0