Fast access to a PostgreSQL database from AutoHotKey

Question

I'm searching for a way to interact with a PostgreSQL database from an AHK script. All the ways I currently found include running psql.exe from the command-line and then parsing output. Of course, this leads to incredibly poor performance (execute process each time).

The question is, are there any ways to interact with database directly? Something that would allow you to connect and send queries via DllCall or another similar method known from other languages?

The library should make it possible to do something like:

psql_connection := psql_connect("localhost", "5432", "postgres", "dbpass", "TestDB")
rows := psql_query(psql_connection, "select * from TestTable limit 10") ; returns array of objects

Answer 1

You can use a combination of an ADO wrapper and an ADO driver e.g. this.

Further references:

ActiveX Data Objects @ Wikipedia

PostgreSQL connection strings

Using PostgreSQL on Windows with ADO and VB

Answer 2

You can use this library: https://autohotkey.com/board/topic/83542-func-adosql-uses-ado-to-manage-sql-transactions-v503l/

Or if feeling adventurous, use ComObjCreate("") for ADODB.Connection where you can use methods from https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/connection-object-properties-methods-and-events

;test - may not be accurate
connection := ComObjCreate("ADODB.Connection")
connection.Open("Provider =PostgreSQL OLE DB Provider; Data Source =localhost; location =DBTest; User ID =postgres; password =pass")
recordset := connection.Execute("SELECT * FROM tablename")