News for hackers. Stuff that matters.
Re:Appropriate Uses for SQLite by Decabytes on Monday February 12, 2018 @03:58PM (#16362064)
I love SQLite and am currently working on a project that makes extensive use of it. In the book "The Definitive Guide to SQLite" it says that SQLite can scale to 2TB of data Looking at the website it says

  An SQLite database is limited in size to 140 terabytes (247 bytes, 128 tibibytes).

That's ludicrous. I wonder if anyone has come close to that in day to day use.
Re:Appropriate Uses for SQLite by fnord123 on Monday February 12, 2018 @04:24PM (#16362352)
Almost certainly not seeing as the single hw largest device is currently 12TB. Someone would have to pool together 10+ (and more for redundancy) just to store the single file.
Re:Appropriate Uses for SQLite by krylon on Tuesday February 13, 2018 @02:42AM (#16365408)
I have heard of people running ZFS pools that were hundreds of TB in size. Not sure if they were using those for huge SQLite databases. ;-)
Re:Appropriate Uses for SQLite by _kst_ on Monday February 12, 2018 @05:19PM (#16362877)
I presume "247 bytes" is supposed to be "2^47 bytes".