News for hackers. Stuff that matters.
Re:What If OpenDocument Used SQLite? by Drakim on Thursday November 02, 2017 @04:52AM (#15608795)
To be fair, you can't read any files without software, you need a text editor even for plaintext.

However, all software is not equal. Any OS comes with a text editor and a ZIP utility by default now. The same is not true for SQLite's format.

Re:What If OpenDocument Used SQLite? by TuringTest on Thursday November 02, 2017 @07:41AM (#15609454)
But it could easily become true if SQLite was a common document format. Back in the 90's and early 2000's, OS didn't come with a ZIP utility either.
Re:What If OpenDocument Used SQLite? by justinclift on Thursday November 02, 2017 @02:17PM (#15612835)
Which OS doesn't come with SQLite?

• Win 10 apparently does (I don't use it, so can't personally verify). Win7/8 don't.

• Every version of OSX for many years does

• Fairly sure the main Linux distro's do

• FreeBSD does, not sure about NetBSD/DragonFlyBSD though.

Checking a local OpenBSD 6.x box just now, sqlite/sqlite3 aren't in the default user path, so maybe that's one that doesn't.

Re:What If OpenDocument Used SQLite? by MrQuincle on Thursday November 02, 2017 @07:21AM (#15609365)
I don't think that's true. Does Ubuntu come with zip by default now?

Normally tar balls are used and zip has to installed afterwards:

apt install zip

I read the article as advocating for more open binary formats. That it is useful to have binary formats is logical. That someone would like to have open ones is I think a nice thought.

Re:What If OpenDocument Used SQLite? by yellowapple on Thursday November 02, 2017 @02:35PM (#15613019)
"Any OS comes with a text editor and a ZIP utility by default now."

The same thing is becoming true of SQLite (and pretty much is true if you exclude older versions of Windows). We're talking about one of the two (estimated) most-widely-deployed software projects in the world today (http://sqlite.org/mostdeployed.html). It's FOSS, ubiquitous, easily embeddable, works remarkably well, and has bindings for pretty much every programming language under the sun. As far as a general-purpose file format goes, a SQLite database is thus pretty close to ideal.

Re:What If OpenDocument Used SQLite? by pyre on Thursday November 02, 2017 @12:26PM (#15611843)
> The same is not true for SQLite's format.

That's not entirely true. Anything that comes with Python installed has SQLite bundled/compiled in. It's just the library, not the cli, but still.

Re:What If OpenDocument Used SQLite? by aeorgnoieang on Thursday November 02, 2017 @11:05AM (#15611049)
Arguably, any OS should come with SQLite too. It's pretty close to being as standard as text (which can be complicated too sometimes).