If not via ODBC, how do Linux clients talk to Linux-hosted PostgreSQL/MySQL?

In my case I use python and use python modules to connect (there are several pg8000, psycopg2, pymssql, and others). But there are direct connections for C++, C, Pascal, and of course the many web frameworks.

Johnf