4 ms·
For me it's about proprietary vs. readable - unless it's obviously necessary for performance I think I'd still prefer 'flat file' to sqlite, but basically I jus
by OJFord 4y ago
For me it's about proprietary vs. readable - unless it's obviously necessary for performance I think I'd still prefer 'flat file' to sqlite, but basically I just want something that isn't an incomprehensible blob, that I can use with other tools etc.
Bonus points for some open standard, but some kind of understandable format even if proprietary is miles ahead of proprietary and cryptic.
I wish Fusion360 for example had a sanely git-able on-disk format like:
line 0xdeadbeef (0,0) - (123,456)
line 0x01234567
constraint parallel 0xdeadbeef 0x01234567
Etc., Or something.
(Actually I suppose git - and incremental backups - is the main reason I say I'd still prefer plaintext to db.)
- funstuff007 4y ago> main reason I say I'd still prefer plaintext to db Is there a non-proprietary somewhat sane way to do version control for spreadsheets (Excel and LibreOffice)?
- notriddle 4y agoTell LibreOffice to save the file as Flat XML.
- CRConrad 4y ago> I think I'd still prefer 'flat file' to sqlite, but basically I just want something that isn't an incomprehensible blob, that I can use with other tools etc. An Sqlite database may be a binary blob, but thanks to the Sqlite software being open source and ubiquitous, it's pretty easily comprehensible. Sure, not quite as accessible as plain text[1], but not far from it. So when you need something just a little bit more advanced than plain text (i.e. SQL functionality) it seems like a good compromise that doesn't -- pun intended -- too much compromise openness and accessibility. ___ [1]: But, hey, does "plain" text include UTF-8 nowadays or does it still mean ASCII-only?
- andrewstuart2 4y agoPerhaps it was deliberate, but your last paragraph (plaintext vs db) really just reinforces your point of standards. There's nothing particularly special about plaintext aside from its total ubiquity. Everything today uses and understands ASCII/UTF-8 and we've used that, plus some handy human conventions like limited character count between newline characters, to build up tools like git to help manage the changes in smaller chunks. There's nothing preventing us from doing the same for other formats if they become commonly supported or expected. Much like SQLite and some of the tools cropping up.
- chme 4y ago> There's nothing preventing us from doing the same for other formats if they become commonly supported or expected. Much like SQLite and some of the tools cropping up. True. I mean if it would be common to put source code and text into sqlite files, then most tools would probably also deal with it. However there is a case about simplicity. For instance writing a diff algorithm on plain text files is much simpler and easy to understand, than writing diff algorithms on text or binary structures.
- chmod775 4y ago> For instance writing a diff algorithm on plain text files is much simpler and easy to understand, than writing diff algorithms on text or binary structures. I'd argue the opposite. Coming up with a good, human readable, diff on unstructured text within acceptable runtime is not that easy. LCS is NP-hard and the naive algorithm has unacceptable performance and memory footprint. However diffing something structured, especially when it has unique keys like in most databases, is really easy. Structure gives you an easy way to compare data systematically and is handy to express differences.
- forgotmypw17 4y ago> There's nothing particularly special about plaintext aside from its total ubiquity. But ubiquity is extremely special and useful and essential if you want to maintain ownership of your data.
- tasuki 4y ago> For me it's about proprietary vs. readable - unless it's obviously necessary for performance I think I'd still prefer 'flat file' to sqlite, but basically I just want something that isn't an incomprehensible blob, that I can use with other tools etc. That is not exactly what proprietary means. Though I feel the same - plain text can be versioned and managed by various tools and that is great!
- OJFord 4y agoI was not aware I gave a definition for it. I didn't mean it as an antonym for 'readable', if that's what you mean. Plaintext could be in a proprietary format but that's far better than proprietary compressed database that's a job to work out what even made it (if that wasn't proprietary itself!). Proprietary plaintext might even be better than open standard blobby format, depending on what you want to do with it. (Better for git and backup, worse for opening in competitor tools.)
- MaxBarraclough 4y agoI think their point was that proprietary is not a synonym for bespoke. If your code is Free and Open Source, then its file-format is presumably not proprietary, whether or not it makes use of an existing standard format (like JSON) or solution (like SQLite).
- Blackthorn 4y ago> I wish Fusion360 for example had a sanely git-able on-disk format like: There are two standards for this common to CAD, called IGES and STEP. They are both plaintext, though their gittability is questionable.
- stjohnswarts 4y agoThey are structured text though so I don't think you can just do deltas like like with code. You'd have to treat them like binaries would you not? That's the way we always kept our XML files in git forced to be binaries.