Programmatic
Last updated
Last updated
Doltgres ships with a built-in Postgres compatible server. To start the server for your Doltgres database, you run doltgres. The doltgres command starts a Postgres compatible server on port 5432. By default, a user named postgres with a password of password is created, along with the postgres database.
Once a server is running, any Postgres client should be able to connect to Doltgres SQL Server in the exact same way it connects to a standard Postgres database. For instance, if you are running a Doltgres sql-server locally, you can connect to it with the psql client like so:
We explicitly support the programmatic clients outlined in this document through integration testing. Tests are run on GitHub pull requests to Doltgres in a Ubuntu environment in a Docker container. If you would like another Postgres compatible client supported and tested, .
The test code linked to below is a good way to get started connecting to a Doltgres SQL server if you are not familiar how to connect to Postgres in your language of choice. The code establishes a connection, runs some simple queries, verifies the output comes back as expected, and closes the connection.
Doltgres client support and tests for compatibility are still being built out. If you have a particular client you would like to see supported, please let us know by .