this is a very open-ended question that can't be answered with a single document. SQLAlchemy will allow for standard SQL and DDL to work across both platforms transparently as well as differences in INSERT mechanics, and additionally transactional semantics will work. But beyond that you would need to be familiar with what database features you wish to use that may require special attention.
General dialect documentation is at; http://docs.sqlalchemy.org/en/latest/dialects/sqlite.html http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html On Fri, Mar 23, 2018 at 5:30 PM, Rich Shepard <rshep...@appl-ecosys.com> wrote: > I'm starting to write an application which will have two versions. One is > single-user with sqlite3 as the backend, the other is multi-user with > postgres as the backend. The single-user version will be written first. > > Both will be placed on github as F/OSS applications. > > Please point me to the docs where I can learn what differences I need to > make to accommodate both versions. > > Rich > > -- > SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- You received this message because you are subscribed to the Google > Groups "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.