sqlite-utils - my Python library and CLI tool for manipulating SQLite databases

• healthkit-to-sqlite

  2 184 0.0 Python

  Convert an Apple Healthkit export zip to a SQLite database

  

I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.

• swarm-to-sqlite

  1 57 3.5 Python

  Create a SQLite database containing your checkin history from Foursquare Swarm

  

I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• twitter-to-sqlite

  2 395 0.0 Python

  Save data from Twitter to a SQLite database

  

I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.

• inaturalist-to-sqlite

  1 6 0.0 Python

  Create a SQLite database containing your observation history from iNaturalist

  

I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.

• google-takeout-to-sqlite

  1 92 0.0 Python

  Save data from Google Takeout to a SQLite database

  

I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.

• github-to-sqlite

  7 376 6.0 Python

  Save data from GitHub to a SQLite database

  

I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.

• genome-to-sqlite

  1 21 0.0 Python

  Import your genome into a SQLite database

  

I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• pocket-to-sqlite

  1 99 5.4 Python

  Create a SQLite database containing data from your Pocket account

  

I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.

• hacker-news-to-sqlite

  4 43 0.0 Python

  Create a SQLite database containing data pulled from Hacker News

  

I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.

• evernote-to-sqlite

  1 35 0.0 Python

  Tools for converting Evernote content to SQLite

  

I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.

• datasette

  187 8,881 9.2 Python

  An open source multi-tool for exploring and publishing data

I've been working on this for 2.5 years now. The initial goal was to make it as quick and easy as possible to load data from any source into a SQLite database (so you could explore it with my Datasette tool), but over time it has evolved into more of a Swiss army-knife for working with SQLite.

• reader

  30 416 9.2 Python

  A Python feed reader library. (by lemon24)

Looking now through the Python API docs, I found the Quoting characters for use in search thing, which may come in handy for something I'm doing for my feed reader library (deduplicating articles). Not sure if I'll vendor it or add sqlite-utils as a new dependency, but it's good to know someone already solved this problem (I have a prototype, but I haven't really tested it).

• simonw

  9 380 9.9 Python

  https://simonwillison.net/2020/Jul/10/self-updating-profile-readme/

I have GitHub sponsors setup: https://github.com/simonw

Suggest a related project