Monday, June 16, 2008

MySQL to PostgreSQL

Today I spent a majority of my time setting up a PostgreSQL resource for the RODS sample database Dr. Espino sent me last week.

PostgreSQL doesn't support the SQL convention for inserting multiple rows at a time. But, I found a way around it by writing an insert function and re-invoking it (which is apparently faster anyways). Thank you Internet.

Tomorrow, I set up the test pulls, and if that goes quickly, I set up the converter and start producing time and spatial series.

No comments: