search

ckolderup / postmarks

a single-user bookmarking website designed to live on the Fediverse
https://postmarks.glitch.me
MIT License
459 stars 38 forks source link

export to CSV #86

Closed ckolderup closed 10 months ago

ckolderup commented 10 months ago

right now we make the SQLite db available for download on the admin page, but a quick export to something friendlier (CSV, JSON, etc) would probably be appreciated. CSV seems most likely to be useful to import into other things, based on experience with bookmarking/read-later/etc services.

UPDATE: re-naming this issue to specifically scope this ticket to CSV, which @PatOConnor43 has made a great start on in #118. I would consider export to other formats in their own tickets with clear naming, details of what the format is, and an explanation for the intended use case if it's not something immediately obvious like another bookmarking service.

andypiper commented 10 months ago

nods I was thinking the same thing. Mastodon exports e.g. following/follows as CSV, which may be a pattern to use for exporting from the activitypub.db file.

ckolderup commented 10 months ago

another point in favor of CSV that just occurred to me-- if we make all fields except URL optional, and make URL the first column, we could a) reasonably detect if the first row is a header column or not and b) accept a file that was just a list of URLs using the same parser? 🤔