Rapid data analysis with SQLite and Datasette

Datasette is a growing ecosystem of tools built around the idea of small data analysis: what kind of things can you do if your data fits on a thumb drive rather than a Hadoop cluster?

The signature tool is Datasette itself, which provides a web interface and JSON API for SQLite databases, and a mechanism for publishing them to the internet.

Why SQLite? It's fast, free, reliable, and stores data as a single file, so you don't need to spin up an expensive database server in order to start working with data.

Join us in September as we welcome John S. Knight fellow and Django co-creator, Simon Willison to PyRVA to show us his amazing new project, datasette.

He has been building tools for load data into SQLite from all kinds of sources: CSV files, JSON, GIS shapefiles, as well as external API providers like GitHub, Foursquare, and Twitter.

He will demonstrate how to use these tools for use cases ranging from data journalism to personal analytics.

Join us on our Discord server for what promises to be a very popular talk!