Skip to content
Save data from Pinboard to a SQLite database.
Python
Branch: master
Clone or download
jacobian ⬆️ upgrade to recent pytest
I have no clue why I was using 3.0...
Latest commit e848a1e Nov 8, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github/workflows 📌 I believe this works on Python 3.6 Nov 7, 2019
pinboard_to_sqlite add --since / --since-date for incremental updates Nov 7, 2019
tests represent tags as a JSON array Nov 7, 2019
.gitignore 🎉 it works Nov 7, 2019
LICENSE 📄 wftpl Nov 7, 2019
README.md 🎉 it works Nov 7, 2019
poetry.lock ⬆️ upgrade to recent pytest Nov 8, 2019
pyproject.toml ⬆️ upgrade to recent pytest Nov 8, 2019
pytest.ini

README.md

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.

You can’t perform that action at this time.