this post was submitted on 28 Mar 2025
33 points (100.0% liked)

Programming

19246 readers
247 users here now

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you're posting long videos try to add in some form of tldr for those who don't want to watch videos

Wormhole

Follow the wormhole through a path of communities !webdev@programming.dev

founded 2 years ago
MODERATORS
snowe@programming.dev
Ategon@programming.dev
MaungaHikoi@lemmy.nz
33
YAML, SQL, or something else? Looking for recommendations for making a database of stories. (lemm.ee)
submitted 3 days ago by Bubs@lemm.ee to c/programming@programming.dev
39 comments fedilink hide all child comments
 

Short version of the situation is that I have an old site I frequent for user written stories. The site is ancient (think early 2000's), and has terrible tools for sorting and searching the stories. Half of the time, stories disappear from author profiles. Thousands of stories and you can only sort by top, new, and 30-day top.

I'm in the process of programming a scraper tool so I can archive the stories and give myself a library to better find forgotten stories on the site. I'll be storing tags, dates, authors, etc, as well as the full body of the text.

Concerning the data, there are a few thousand stories- ascii only, and various data points for each story with the body of many stores reaching several pages long.

Currently, I'm using Python to compile the data and would like to know what storage solution is ideal for my situation. I have a little familiarity with SQL, json, and yaml, but not enough to know what might be best. I am also open to any other solutions that work well with Python.

you are viewing a single comment's thread
view the rest of the comments
[–] bazzzzzzz@lemm.ee 4 points 3 days ago* (last edited 3 days ago)

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:

  • 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.