Connect to Postgres from Swift

Question

In a Swift app, how does one connect to a Postgres database server?

• In Java, we use JDBC with an compliant driver to connect to a Postgres server, communicate SQL, and get a result set.
• In a Win32 app, we use ODBC with a compliant driver to do the same.

How to do the equivalent from Swift?

Answer 1

You can try to use PostgresClientKit

Answer 2

You may use Postgres C API libpq. However, at least a thin layer of Swift will be needed to make it object-oriented and ARC compliant. An example implementation of that layer may be like so: stepanhruda/PostgreSQL-Swift.