The Charta Platform has been supporting MySQL for quite some time now. A lot of effort already has been spent though to ensure independence from one database management system. Now limited support for PostgreSQL has been added to the platform. Currently it is possible to use the PostgreSQL low level client library functions to connect to a database and execute queries. Also, PostgreSQL support is being added into the SQL abstraction layer of the platform to be able to use PostgreSQL as a full replacement of MySQL. Using PostgreSQL with the SQL abstraction layer is pretty straightforward, however, the TPostgreSQLCompiler currently lacks the ability to compile quite some SQL constructs. As most constructs will turn out to be compatible with standard SQL or MySQL syntax, adding the missing compilation units should be very easy.
Updates on new PostgreSQL features in the platform will be posted to this page. The first new feature probably will be the support for connecting to PostgreSQL using the standard SQL connector functionality. This, for instance, will enable connecting to PostgreSQL from Charta.