Import function causes SQLite inconsistencies

ckolderup / postmarks

a single-user bookmarking website designed to live on the Fediverse

https://postmarks.glitch.me

MIT License

456 stars 38 forks source link

Closed andypiper closed 9 months ago

andypiper commented 9 months ago

Importing a set of URLs from the current bulk import function results in some oddness:

URLs appear to have a newline included in the DB value, which then breaks the Atom feed
all of the entries are added simultaneously so they have identical last updated values in the Atom feed
the individual rows of the SQLite DB are not numbered when the values are added from the importer.

Based on #23 this is probably due a bit of a rewrite at some stage.

andypiper commented 9 months ago

OK, this looks like I could have done a better job in a previous PR. Going to submit a new one which should resolve this. 😬