minus-squarebazzzzzzz@lemm.eetoProgramming@programming.dev•YAML, SQL, or something else? Looking for recommendations for making a database of stories.linkfedilinkEnglisharrow-up4·edit-26 days agoIf scraping is reliable, I’d use the classic python pickle or JSON.dump For a few thousand I would just use a sqlite dB… 3 tables: Story with fields: Id, title, text Meta with fields: Id, story-id, subject, contents Tags with fields Id, story-id, tag Use SQL joins for sorting etc. Sqlite is easily converted to other formats if you decide to use more complex solutions. linkfedilink
minus-squarebazzzzzzz@lemm.eetoWorld News@lemmy.world•Britain issues travel warning for USlinkfedilinkEnglisharrow-up2·7 days agoA pinch of soporconbuttig might do linkfedilink
If scraping is reliable, I’d use the classic python pickle or JSON.dump
For a few thousand I would just use a sqlite dB…
3 tables:
Use SQL joins for sorting etc.
Sqlite is easily converted to other formats if you decide to use more complex solutions.