There are 3 types of files. Renamed txt, renamed zip, and exe
Ah, good ol’ Microsoft Office. Taken advantage of their documents being a renamed .zip format to send forbidden attachments to myself via email lol
On the flip side, there’s stuff like the Audacity app, that saves each audio project as an SQLite database 😳
Nothing wrong with that… Most people don’t need to reinvent the wheel, and choosing a filename extension meaningful to the particular use case is better then leaving it as
.zipor.dbor whatever.Also renamed xml, renamed json and renamed sqlite.
SQLite explicitly encourages using it as an on-disk binary format. The format is well-documented and well-supported, backwards compatible (there’s been no major version changes since 2004), and the developers have promised to support it at least until the year 2050. It has quick seek times if your data is properly indexed, the SQLite library is distributed as a single C file that you can embed directly into your app, and it’s probably the most tested library in the world, with something like 500x more test code than library code.
Unless you’re a developer that really understands the intricacies of designing a binary data storage format, it’s usually far better to just use SQLite.
