• 𝒍𝒆𝒎𝒂𝒏𝒏@lemmy.one
    link
    fedilink
    arrow-up
    2
    ·
    1 year ago

    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 😳

  • observantTrapezium@lemmy.ca
    link
    fedilink
    arrow-up
    1
    ·
    1 year ago

    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 .zip or .db or whatever.

    • dan@upvote.au
      link
      fedilink
      arrow-up
      1
      ·
      edit-2
      1 year ago

      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.