Page 1 of 1

Need temporary table - sqlite?

Posted: Tue Dec 04, 2007 11:42 am
by Luke
I am building an order-management console with cakephp right now (and actually enjoying it!). I need to write an order importer. This importer will be able to import from multiple sources (amazon, miva / website orders, ebay, storefront, anything else in csv format). I want the user to be able to manipulate the data a bit (delete records, rearrange things, etc) before actually importing it into the more permanent mysql database. So what I was thinking is that some sort of temporary database would allow me to easily manipulate the data before importing it. I've been searching for an excuse to use sqlite and I'm hoping this is it. Isn't this where sqlite shines? How should I go about this?

Posted: Tue Dec 04, 2007 2:13 pm
by Luke
nevermind I guess I could just use a separate table or something... :( I am really desperate to try sqlite LOL