Re: Serial, concurrent, parallel

"Don Y" <blockedofcourse@foo.invalid> wrote in message news:vmc36h$3mt5f$1@dont-email.me...

On 1/16/2025 10:57 AM, Edward Rawde wrote:

Databases can also be backed up as human readable text files.

>
To be fair, a spreadsheet's contents can similarly be exported (CSV).
I'm not sure how the formulae, formats, etc. are handled, though.
And, any non-text entries (that might be supported).

In other words exporting a database as SQL is not in any way similar to exporting a spreadsheet as csv.
You might be better off unzipping the xlsx and parsing the xml if you really want your spreadsheet elsewhere.

>

Just export data as SQL.
This gives me peace of mind that whatever software is or isn't available in the future I can always read my data.

>
The value of SQL as a "dump" format is that you can *import* it into
another SQL DBMS -- as long as the recipient supports the same (or
greater) level of features.  And, the import process is nothing more than
piping the dump file to the recipient DBMS's "console" as it consists
entirely of SQL commands.

I frequently paste an entire SQL dump into the Query tab in HeidiSQL.

>