337
you are viewing a single comment's thread
view the rest of the comments
[-] lysdexic@programming.dev 0 points 1 year ago

A database carry the schema, structure, that allow you to validate that you are still having the structure you want.

So do all file formats.

SQLite is both a file and a database, but what I’m saying is that people shouldn’t mess with the file, but the database interface instead.

The same holds for all file formats: don't go around licking random bits in a file, use a client instead.

I have nothing against third party clients, the important thing is keeping the structure.

That's what file format clients are for, and anyone can even roll out their own if they want it.

The facts a DB use the Filesystem behind the scenes, is an implementation details the user shouldn’t be much concerned about, some DB can do without Filesystems.

That's really besides the point. The point is that it doesn't make sense to frame using databases over files as using a higher level client over persisted data.

[-] Kuinox@lemmy.world 1 points 1 year ago

So do all file formats.

I don't think you understand what I'm saying.
json, XML files for examples doesn't have schemas by defaults. Schema exists but are totally optional, and are most of the times never there.

The same holds for all file formats: don’t go around licking random bits in a file, use a client instead

Most of the time the file was written by something not implemented to be used by third party.

That’s really besides the point.

As far as I'm aware, I'm the one making the point here.

this post was submitted on 01 Sep 2023
337 points (96.2% liked)

Programming

17248 readers
393 users here now

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you're posting long videos try to add in some form of tldr for those who don't want to watch videos

Wormhole

Follow the wormhole through a path of communities !webdev@programming.dev



founded 1 year ago
MODERATORS