The latest International Taxonomic Identification System (ITIS) now makes
its monthly database upgrades available for downloading in multiple formats,
including PostgreSQL and SQLite3.
An application I'm developing will be available in two formats: single user
(SQLite3) and multiuser (PostgreSQL), so I downloaded the May 30th .zip
files for each, unzipped them, then tar'ed and xv compressed them. The file
sizes really surprised me.
File type | Database | File size
------------+------------+-------------
.sql | Postgresql | 358 MB
| SQLite3 | 773 MB
| |
.zip | Postgresql | 461 MB
| SQLite3 | 174 MB
| |
tar.xz | Postgresql | 290 MB
| SQLite3 | 95 MB
So the postgresql.sql file is less than half the size of the sqlite.sql file
but the latter has much more air in it so both the .zip and .xz files are
much smaller.
I've not before done a comparison of database export file sizes on the same
database so I find this interesting.
Regards,
Rich
_______________________________________________
PLUG mailing list
[email protected]
http://lists.pdxlinux.org/mailman/listinfo/plug
