4 ms·
I wonder: Is it like the new Office formats, where it's actually a zipped bundle? In this case, maybe they just zipped up all the files they already had and s
by jdmichal 6y ago
I wonder: Is it like the new Office formats, where it's actually a zipped bundle? In this case, maybe they just zipped up all the files they already had and saved a lot of reimplementation in other parts of the system.
- coliveira 6y agoNo, they're using SQLite3 as the repository.
- yellowapple 6y agoRight, but the individual rows in that SQLite3 database could indeed be entire files, which is what I think the GP was getting at. Basically: using SQLite as if it were an archive format, with file data stored as BLOB-typed columns (and possibly other columns for various metadata). Whether Audacity is actually doing this, I don't know.
- thristian 6y agoAudacity almost certainly isn't doing this, but you can use SQLite to treat an archive as a database: $ echo "select name, sz from zip" | sqlite3 -table mb.zip +---------+--------+ | name | sz | +---------+--------+ | MB.EXE | 125952 | | MB.DOC | 1225 | | MB2.DOC | 9158 | +---------+--------+ ...and to treat a database as an archive: $ sqlite3 new_archive.db -A --create log.txt $ sqlite3 new_archive.db -A --list log.txt
- oblio 6y agoThis is insane, SQLite can open ZIP files? :-))
- mavhc 6y agoAll file formats are now zip files or sqlite files it seems