Skip to main content

Save data from Pinboard to a SQLite database

Project description

Save data from Pinboard to a SQLite database.

Inspired by (and using libraries from) Simon Willison's Dogsheep project. You're probably going to want to run Datasette on the resulting db.

How to install

$ pip install pinboard-to-sqlite

Authentication

Run:

$ pinboard-to-sqlite auth

This will direct you to https://pinboard.in/settings/password to find your API token, which you'll then paste into the terminal. This'll get saved in an auth.json file, which subsequent commands will pick up.

To save to a different file, see the -a / --auth flag.

Fetching posts

Run:

$ pinboard-to-sqlite posts pinboard.db

Where pinboard.db is the name of the database you'd like to save posts to. Note that the API this uses has a rate limit of once per minute, so don't run this command more than once per minute (I don't know why you would). This doesn't seem to be enforced fairly loosely, but be careful anyway.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pinboard-to-sqlite-1.2.0.tar.gz (3.2 kB view hashes)

Uploaded Source

Built Distribution

pinboard_to_sqlite-1.2.0-py3-none-any.whl (3.9 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page