If you were to guess, which of these components is installed in most devices world-wide?
-
@bagder Hmm, that's a tricky one, if we just count the number of instances I think sqlite is higher than libcurl or OpenSSL because those would likely depend on dynamically linked libraries installed once per machine, but sqlite is often embedded and thus installed multiple times... but you're asking specifically about which one is installed in most devices, not most installed overall.
@Varpie libcurl is also embedded and installed numerous times on for example every smartphone...
-
If you were to guess, which of these components is installed in most devices world-wide? (it's impossible to actually *know*)
@bagder if it's number of installs it's probably sqlite since we all have that installed multiple times per device but if each device is only worth one point I assume it's much closer.
My entirely unsubstantiated guess is that curl is much more common in IOT devices than sqlite and thus, wins here.
-
If you were to guess, which of these components is installed in most devices world-wide? (it's impossible to actually *know*)
@bagder I voted sqlite, because there are more embedded devices that need a database than those that need networking. And out of those, not all use libcurl for networking.
The other two options I'm not sure. Every general-purpose device definitely ships with (likely several copies of) both.
-
@Varpie libcurl is also embedded and installed numerous times on for example every smartphone...
@bagder I don't know how it's done on iOS, but on Android as far as I know the "native" (Kotlin/Java) implementations don't use libcurl, but Room uses sqlite, so it is more likely for apps to create a new instance of sqlite than libcurl. That being said, they depend on OpenSSL for HTTPS calls, so maybe OpsnSSL is the winner on Android devices, as basically all apps make HTTPS calls but not all apps have a local DB with sqlite, and libcurl installations don't scale linearly with the number of apps...
-
If you were to guess, which of these components is installed in most devices world-wide? (it's impossible to actually *know*)
@bagder I voted for OpenSSL. When BlackBerry 10 devices shipped they had three different versions of OpenSSL in them (all with different vulnerabilities of course).
-
@bagder that one was tricky, and the question is open for several interpretations. but with 100% sqlite, i guess my guess is correct
-
If you were to guess, which of these components is installed in most devices world-wide? (it's impossible to actually *know*)
@bagder Since I had to build some SBOMs lately, I can tell that zlib is everywhere (including the linux kernel). In a typical configuration of curl and sqlite, zlib is a dependency, and it can also be a dependency to OpenSSL (although I think it is more esoteric configuration, not sure), but I'd estimate it has to be zlib by a large margin.
-
If you were to guess, which of these components is installed in most devices world-wide? (it's impossible to actually *know*)
@bagder I would've given the point to libcurl but it feels like every Android app uses sqlite. Also would libcurl even work without openssl?
-
I deliberately chose to use the exact same wording for the question as when I ran the same poll back in late 2021.
@bagder I was very tempted by sqlite ... on all the Androids for example, but not on Windows by default. OpenSSL is out, because there are other implementations. libz follows closely on a general-purpose OS and anything with web; but libcurl covers protocols other than HTTP; FTP and friends have been around for a lot longer, and there are a lot of IoT devices ...
-
If you were to guess, which of these components is installed in most devices world-wide? (it's impossible to actually *know*)
@bagder Hmm. It's like asking if there are more windows or doors in the world?
-
If you were to guess, which of these components is installed in most devices world-wide? (it's impossible to actually *know*)
@bagder do they have to be devices that are still active? i would imagine the mp3 players and Game Boys of days past would have more need of decompression than networking or databases. but the majority of them are in landfills or drawers nowadays.
-
If you were to guess, which of these components is installed in most devices world-wide? (it's impossible to actually *know*)
@bagder There's no way it isn't sqlite.
-
If you were to guess, which of these components is installed in most devices world-wide? (it's impossible to actually *know*)
@bagder i wonder why so many people bet on sqlite. IMHO it's the newest competitor in this game, and the are so many alternatives to it.
My bets are on zlib. I don't know any device that don't use an compressed kernel, compressed partitions, or libs. -
@bagder I guess it is not zlib/sql? You could technically be okay without those. SSL/libcurl not so much if you want to communicate (securely) with the internet.
-
@bagder i wonder why so many people bet on sqlite. IMHO it's the newest competitor in this game, and the are so many alternatives to it.
My bets are on zlib. I don't know any device that don't use an compressed kernel, compressed partitions, or libs. -
@bagder I guess libcurl and sqlite are scoring very hig.
Given whos writing, probably libcurl, I guess ?
@paolo_lulli @bagder the only reason i voted sqlite is it's also kindof a default thing with offline devices, so little embedded crap that would never even dream of anything internet. i'm pretty sure there are about 5 sqlite instances in my 1 meter range where i'm sitting now: an (electric) piano, a looper, a crappy projector, my watch (also libcurl!), and something else I can't think of now.
-
-
@bagder Hmm. It's like asking if there are more windows or doors in the world?
-
-
If you were to guess, which of these components is installed in most devices world-wide? (it's impossible to actually *know*)
@bagder Isn't libz basically a kernel dependency now days? So if you run linux you'd have it installed... unless you chose not to compress your kernel.
libcurl as a second if you want to talk over a network.
Then sql, cause everything needs a database now days.
Lastly OpenSSL because "security is out of scope for our LAN only thingamajig that's definitely never going to be connected to the Internet".But I'm basing this on a guess that Linux use trumps network use, which might be naïve.
