title: SQLAlchemy - SQLite for testing and Postgresql for development - How to port?
body: <p>I want to use sqlite memory database for all my testing and Postgresql for my development/production server.</p>
  
  <p>But the SQL syntax is not same in both dbs. for ex: SQLite has autoincrement, and Postgresql has serial </p>
  
  <p>Is it easy to port the SQL script from sqlite to postgresql... what are your solutions?</p>
  
  <p>If you want me to use standard SQL, how should I go about generating primary key in both the databases?</p>