You shouldn’t Use SQLite

hendrik-erz.de

4 points·andrewstuart··7 comments

It is confusing that the new link provided in the header was not posted instead:

(Link: https://www.hendrik-erz.de/post/should-you-use-sqlite)

In which the author clearly says:

> About a year ago I fervently advocated against using SQLite for storing research data, but was since proven absolutely wrong. In this article I explain where and why I was wrong, and share the real reasons why I think we shouldn't use SQLite for research: A lack of skills and time.

From the top of this article:

> Update 29 Aug 2022: There is now an update to this article where I acknowledge problems with the arguments I brought forth below. Please read the update here: Should you use SQLite?

Was about to say this. Read both and the second article whilst relevant to the author who, having learned both R and python (seemingly), cannot see themselves learning SQL because... Reasons, still advocates for not using databases.

> I didn’t google that because the actual maximal size doesn’t matter since no single disk will have 281 Terabytes of space.

You can buy 245TB SSDs right now and while not yet commonplace there are multiple companies making drives of that size.

More than that: does this guy not know of ZFS and RAID arrays? Like, you only need a little more than two dozen 24Tb drives in a stripe to get to that size. Twice that if you want redundancy.

Flagged several times.. you're feeling lucky?

2024 (7 points, 26 comments) https://news.ycombinator.com/item?id=39937543

2022 (1 point, 3 comments) https://news.ycombinator.com/item?id=32473183

.. safe 2022 (6 points, 11 comments) https://news.ycombinator.com/item?id=31189341

I guess it raises emotions eh?

(2021)

Reply on news.ycombinator.com