SQLAlchemy - SQLite for testing and Postgresql for devlopment - How to port?

Posted by StackUnderflow on Stack Overflow See other posts from Stack Overflow or by StackUnderflow
Published on 2010-04-26T20:59:45Z Indexed on 2010/04/26 21:03 UTC
Read the original article Hit count: 294

Filed under:
|
|
|

I want to use sqlite memory database for all my testing and Postgresql for my development/production server.

But the SQL syntax is not same in both dbs. for ex: SQLite has autoincrement, and Postgresql has serial

Is it easy to port the SQL script from sqlite to postgresql... what are your solutions?

If you want me to use standard SQL, how should I go about generating primary key in both the databases?

© Stack Overflow or respective owner

Related posts about postgresql

Related posts about sqlite