Yeah, I have been amazed for an entire life how many tools the IT industry invented during last 50 years to just disguise a database.
OK, in '70s, '80s or '90s when compute and storage resources were limited and every bit counted, specialized formats did make sense.
But nowadays we'd save enormous efforts by just packaging stuff in SQLite databases. Microsoft's proprietary file formats (Office, Power BI etc.), OpenOffice/LibreOffice OpenDocument format, or almost everything else would fit perfectly.
Documents, files, are all data (called "data files", aren't they?), including executables, which as can be seen in this article are also databases.
Some of it is convergent evolution at work. 60s/70s/80s specialized formats as much predated modern database designs and data structures as coexisted with them. SQLite is the culmination of decades of database design. Some of that was influenced by those specialized formats of previous decades that SQLite could now in theory replace.
(Which is to say a lot of the specialized formats didn't exist just because of compute and storage resource limitations, but also because training/research/standards work came later. Plus complications like software patents. ZIP files have been around since the 1990s but ZIP only became a common general use container format for "everything" almost exactly 14 years later when patents finally expired.)
At first I thought it was still for a word document to be saved in SQL but then I thought about embedded images and it makes complete sense. Makes more sense for a Publisher/Impress app though as they have more self-contained objects. In Word/Writer the main text is one huge run of characters, how would you sqlize that effectively?
Current ooxml/odt formats use a zip file with xml files inside (plus other files like images). I'd guess one way would be to store the xml itself as a blob and another to use a json field, which Sqlite stores in a more efficient format called jsonb: https://sqlite.org/json1.html#jsonb
> why are they falling so far behind in the AI race?
Are they? They provide AI overview to majority of web searches, and that alone requires enormous resources. Anthropic, OpenAI and others only serves their AI customers. Regarding the power of their model, my own experiences are that it doesn't fall behind. I've done many successful projects already, including quite a big one in Pascal. So no, I don't feel any difference between Gemini and others. I think it's just a long lasting fashion to whine about Google and its services.
Yeah we need more power-thirsty, climate-impacting models, so that the coders can produce trillions of new rubbish code for millions of apps that nobody uses. Or that people can generate rubbish cat pictures riding dogs and rubbish fake movies.
I wonder whether I'll be able to live my nice life to the end like I planned before Altman released his first model, or will it all end in a global disaster soon.
Those childish comments are so funny. 3 billion people use Facebook regularly, and there are folks that deem themselves superior to all others who claim "I know nobody who uses Facebook". XD
Christ, pipe down little buddy. These “aha gotcha!” responses belong on reddit—but since you’re craving for one too, I’ll bite:
“It’s not a childish comment in the slightest, and most definitely not a claim of superiority in any way either. It’s simply a fact. I, too, know a grand total of 0 persons who use Facebook. Three billion people may use it regularly but all the people I know are in the other, let’s say >vast majority<, of FIVE billion people who don’t even care about Zuckerberg’s billboard.”
reply