4 ms·

You shouldn’t Use SQLite

4 points by andrewstuart 4mo ago

gnabgib 4mo ago
Flagged several times.. you're feeling lucky? 2024 (7 points, 26 comments) https://news.ycombinator.com/item?id=39937543 https://news.ycombinator.com/item?id=39937543 2022 (1 point, 3 comments) https://news.ycombinator.com/item?id=32473183 https://news.ycombinator.com/item?id=32473183 .. safe 2022 (6 points, 11 comments) https://news.ycombinator.com/item?id=31189341 https://news.ycombinator.com/item?id=31189341
- andrewstuart 4mo ago
  I guess it raises emotions eh?
yepyoukno 4mo ago
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 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?
- ifh-hn 4mo ago
  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.
Aachen 4mo ago
(2021)
stonegray 4mo ago
> 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.
- rekabis 4mo ago
  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.

4 points by andrewstuart 4mo ago

Flagged several times.. you're feeling lucky? 2024 (7 points, 26 comments) https://news.ycombinator.com/item?id=39937543 https://news.ycombinator.com/item?id=39937543 2022 (1 point, 3 comments) https://news.ycombinator.com/item?id=32473183 https://news.ycombinator.com/item?id=32473183 .. safe 2022 (6 points, 11 comments) https://news.ycombinator.com/item?id=31189341 https://news.ycombinator.com/item?id=31189341

andrewstuart 4mo ago
I guess it raises emotions eh?

yepyoukno 4mo ago

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 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?

ifh-hn 4mo ago
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.

Aachen 4mo ago

(2021)

stonegray 4mo ago

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

rekabis 4mo ago
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.