WTFRIT / reddit-ingest

0 stars 0 forks source link

Figure out a good forward-looking db schema to use #4

Open MoralCode opened 1 year ago

MoralCode commented 1 year ago

The current one has a separate comments table but this was recently removed in recent changes to https://github.com/WTFRIT/storage-schema. Is this the best path forward?

I sort of like being able to just have all text snippets in one table (vibes) regardless of where they are from, but this may not be the best way to do it as things get complicated and various data sources have different combinations of things (some have upvotes and total votes for example) and it may overcomplicate the table if too many of the fields are NULL too frequently.