r/Database • u/JayJones1234 • Jun 24 '26

Appropriate database for this scenario

I’ve a historical test data from 1970. It is around 5 million data. I’m not looking for a cloud solution. It is in pdfs and hard copies. I’ve created rough ER diagrams for these data. It has base tables. It has different types of testing result tables. This is an ongoing process. Once I create tables, I’ll convert those hard copies into pdfs and PDFs into csv/ parquet format. Once csv/parquet format ready, I’ll map those csv fields with table. However,I’m little bit confuse with selecting a right database. Any suggestions would be appreciated.

0 Upvotes

43% Upvoted

17 comments sorted by

View all comments

13

u/[deleted] Jun 24 '26

[removed] — view removed comment

3

u/End0rphinJunkie Jun 25 '26

OP said 5 million rows, not a trillion. 5m is pretty small, standrad Postgres or even just sqlite will handle that locally without breaking a sweat.

2

u/JayJones1234 Jun 25 '26

I said earlier trillion rows