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 details)

Uploaded Source

Built Distribution

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

Uploaded Python 3

File details

Details for the file pinboard-to-sqlite-1.2.0.tar.gz.

File metadata

  • Download URL: pinboard-to-sqlite-1.2.0.tar.gz
  • Upload date:
  • Size: 3.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.0.0b3 CPython/3.8.0 Linux/5.0.0-1023-azure

File hashes

Hashes for pinboard-to-sqlite-1.2.0.tar.gz
Algorithm Hash digest
SHA256 b66fcfed1e56b3850b62ec192abfc2d22eef20dca7071700fdd7ef8a7ca0148d
MD5 dc4a62a6e44069ecedbfb5ea24f54e00
BLAKE2b-256 f25449d150d8ac45db4c96544c3a0744d28ebdb9a3e90b6e8db45d4047038b6a

See more details on using hashes here.

File details

Details for the file pinboard_to_sqlite-1.2.0-py3-none-any.whl.

File metadata

File hashes

Hashes for pinboard_to_sqlite-1.2.0-py3-none-any.whl
Algorithm Hash digest
SHA256 0acd75a4a1a674a441fb413cec708791fe519f63c657b3f9b185dbab2d0c08f1
MD5 2fb497d24e6e3be1dd26102454c29a98
BLAKE2b-256 5c506fafacf6205b7162ee71f8ed206782bfbc6dc4161a0a8b088b501558d46d

See more details on using hashes here.

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