Need temporary table - sqlite?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Need temporary table - sqlite?

Post 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?
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Post by Luke »

nevermind I guess I could just use a separate table or something... :( I am really desperate to try sqlite LOL
Post Reply