Ask HN: Have you used SQLite as a primary database?

Re:Ask HN: Have you used SQLite as a primary database? by tiborsaas on Monday April 25, 2022 @07:04AM (#31152870)

Yes, I've used it for a side project of mine. It processed like 5 financial transactions in total, so I'm glad I never invested the time to build anything more robust :)

It's also powering another one and I really like the fact that I can just commit the whole DB to the GIT repo.

[ Parent | on HN ]

Re:Ask HN: Have you used SQLite as a primary database? by barryhennessy on Monday April 25, 2022 @07:46AM (#31153181)

Very interesting, what's your workflow? And how big is the DB?

I've never (deliberately) considered committing a DB to git. Although there was that one time when I was straight out of college...

Pro tip: surprising your colleagues in the morning with a 40 minute wait to pull master (because you committed a ???GB db) is a good way to feel like a right eegit.

[ Parent | on HN ]

Re:Ask HN: Have you used SQLite as a primary database? by tiborsaas on Tuesday April 26, 2022 @01:15PM (#31170211)

It's very small, just ~2000 rows, it contains YouTube video ID-s and some metadata.

For backup, I have a small bash script that creates a git commit and pushes it to the github.

[ Parent | on HN ]