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
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