You shouldn’t Use SQLite(hendrik-erz.de)

4 points | by andrewstuart 1 day ago

4 comments

  • stonegray 1 day 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 1 day 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.
  • gnabgib 1 day ago
    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

  • yepyoukno 1 day 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)

    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 1 day 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 1 day ago
    (2021)

Data from the public Hacker News API

UI based on nuxt/hackernews under the MIT License. Copyright © Yuxi (Evan) You & Nuxt core team