4 ms·
In terms of installations, sure. In terms of total data, probably not. In terms of important data, 100% not. Important data needs guarantees, and its privacy
by TZubiri 2y ago
In terms of installations, sure.
In terms of total data, probably not.
In terms of important data, 100% not. Important data needs guarantees, and its privacy is second to its longevity.
Server side and centralized beats client side decentralized for all but sensitive consumer data.
- TheRealPomax 2y agoI'm not sure I buy the "important data" one: my Lightroom catalog, to me, constitutes incredibly important data. Losing it and just having the base files would destroy over a decade of work. It also happens to be a SQLlite3 database. And the same is true for a slew of other applications that (quite rightly) use SQLite databases as their file format. You might be thinking of things like financial transactions, or medical records, but that's not the only kind of important data there is.
- hehdhdjehehegwv 2y agoThe number of societal-wide problems that occur if your Lightroom database gets corrupted is zero. The amount of hell that would be unleashed if the financial systems layers upon layers of database transactions got broken is impossible to comprehend. So if you mean “important” as “necessary for society to function”, then no, your browser bookmark files, contact list, or the other two dozen things your laptop and phone use SQLite for are not important.
- tibbar 2y agoThis is a false equivalence, as one user’s particular usage of SQLite is not comparable to all financial instructions’ databases. Better to compare to the prospect of all smartphones being irreversibly corrupted at once.
- hehdhdjehehegwv 2y agoLiterally all smartphones dying at once is preferable because they are all backed up into heavy duty databases. You can restore every phone from the cloud in this thought experiment. You can not restore a data center from a pile of phones.
- wavemode 2y agoThe goalposts keep moving here. You can just take any arbitrary definition of important and use it to exclude SQLite deployments. It's all semantics, and also irrelevant to the original article anyway, since nowhere does it argue that SQLite holds the most data (important or otherwise).
- hehdhdjehehegwv 2y agoI didn’t comment earlier so I can’t move a goalpost I never set down. I agree with the root comment that there may be more instances of SQLite, the most important data is not in SQLite. For what it’s worth, I have used any number of databases over the years and SQLite is very good for a number of things. None of those things are the core infrastructure that stores your emails, money, and other must have, shared, high availability data. There are different tools for different jobs, that’s fine.
- TZubiri 2y agoHow do you physically store it? An external disk? I venture a guess that for each sqlite db holding important work data, you have dozens or hundreds of traditional db datasets, that are critical to your work. And yes, I mean your bank, but also messaging apps, online services. If you backup your hard drive in the cloud at all, you are already depending on trad dbs for the very use case supposedly highlighting your dependence on sqlite.
- deleted 2y ago[deleted]
- out_of_protocol 2y ago+1 So is contacts list, sms messages, Whatsapp data, browser data etc etc. whese are separate installations of sqlite, hundreds per phone. And they ARE important, at least to me.
- TZubiri 2y agoInteresting. My contacts are stored in my sim chip or google(server), also they are shared with many apps (server), whatsapp msgs are backed up to google drive (server), and itself stored on server side whatsapp servers. Broswer data is sqlite yes, but it is also flushed every couple of months, and is by design ephemeral.
- alganet 2y agoHow would you go about measuring that, or determining what's important? Huge SQL for servers is just a different use case. Someone's temporary browser data or settings for my android alarm app could be just as important and sensitive as an average record on those big servers. Fortunatelly, SQL fits the role of a small transactional engine very well to support those small use cases for a large number of applications. It deserves the good reputation.
- TZubiri 2y agoWe don't need to measure everything, we may talk about variables that are hard or subjective to measure.
- II2II 2y ago> In terms of total data, probably not. > In terms of important data, 100% not. Choosing not to focus upon quantity or quality is likely the reason why SQLite is so popular. It is a lot easier to manage and develop for SQLite than it is to do the same for large databases that require high availability and reliability under heavy loads. There are many more applications for small databases that contain data that is important to the end user even though that data may not be important to anyone else.
- TZubiri 2y agoYou can also use a plain file system, it allows data to be exported more easily and through un unbiased app like a file explorer. I'd say if the data is important and client side, you'd probably want it to be accesible in a protocol format rather than a sqlite file format. It's cool that sqlite is open source and u can technically recover the data, but at the end of the day excel data is more accesible, which defeats the ethos of open sourceness
- simonw 2y agoYou may be shocked to learn how much of the world's "important data" lives in Excel files.
- novariation 2y agoFun fact: my (french) company audited the french navy and found out they share important nuclear submarine maintenance data as excel files through email.
- ARandomerDude 2y agoFormer US military officer here. This does not surprise me at all. I wasn’t in subs but we absolutely did this for maintenance of other multimillion dollar assets.
- strogonoff 2y agoA lot of world’s important data is on paper. As far as important data served from a relational database is concerned, MySQL most likely beats the hell out of everything in terms of popularity. The bulk of SQLite’s usage has to be various runtime caches, file data, and so on.
- TZubiri 2y agoPostgresql superseded mysql ever since the maria fork/oracle acquisition.
- yndoendo 2y agoWould you classify a nurse call system as requiring important data retention and access? Mapping backbone devices with passive and interactive end user devices with means to communicate whom should provide assistance? Works great there too with μC/OS-II. Competition was using Windows XP and Microsoft Access. Only time ever using Oracle has been with internal business analytics, not very important.
- TZubiri 2y agoNo I would not, the application is important and critical, but the data? What data are you holding? Historical auditable data regarding calls? I have some experience with hospitals, and deep data like this would never be used for diagnostics or even epidemiology tracing.
- arh68 2y agoRight. In terms of installations, I bet textfiles still win. Doesn't mean much, does it?
- TZubiri 2y agoGross theoretical error. Text files are a (ambiguous and undefined) file format, while sqlite is an application.
- bob1029 2y ago> Server side and centralized beats client side decentralized SQLite works on the server too. Important data can live in a SQLite database.
- ysabri 2y agoI remember reading or seeing this post about how SQLite can really scale and supports a really high amount of transactions per second. I don't know if it supports distrubuted loads that well, which might be the reason why it's use didn't pick up server side.