[Roadster] Converting TIGER data to a MySQL database
mailinglists at pennysaverusa.net
Mon Feb 13 13:19:49 PST 2006
MyISAM tables ARE portable, e.g. from MAC to PC.
InnoDB tables are not.
At 10:19 PM 2/12/2006, Jeff Garrett wrote:
>You miss one important point: MySQL databases are not (as far as i know)
>portable. Correct me if I'm wrong, but taking a database to a different
>machine (possibly with different type sizes and byte order) may not
>work. This would be a boon for packagers who could run the import on
>the TIGER or other datasets, and publish the resulting databases.
>SQLite doesn't have this problem, and there is a note in TODO suggesting
>moving to SQLite. (It doesn't have spatial indexing, but this is
>probably not be such a slowdown.)
More information about the roadster