Use existing SQL clients
ParticleDB supports existing SQL client libraries and tools through its compatibility interface. Use familiar connection strings, bound parameters and transaction APIs.
Connect
Section titled “Connect”Use the SQL client address from your server configuration. The default is port 5432. The HTTP API has its own address.
Provide the database name, account, password and TLS settings required by your deployment. Addresses · Authentication.
Verify a query
Section titled “Verify a query”SELECT 1 AS ok;Then test parameters, transactions and the result types your application needs through its actual client library.
Compatibility boundaries
Section titled “Compatibility boundaries”Catalog queries, extensions, lock behavior, migration commands and server settings may differ from PostgreSQL. Test these explicitly rather than relying on a successful connection or a reported server version.
Client guides · ORM integration · Limits
Related
Section titled “Related”This site uses Google Analytics cookies to count visits. Privacy · License