Connect to a PostgreSQL Database


John Clarke
Is it possible to create an application that connects to a PostgreSQL Database and runs queries against it ?

DecSoft

Hello John,

Absolutely yes. Our apps can connect with any kind of server databases, with the right server's stuff, of course. You can take a look at the Database sample app, which include the PHP scripts (for the server) and uses a MySQL database (in the server). From such PHP scripts (in this case) we can connect with any kind of database engine instead of MySQL, PostgreSQL, for example.

In fact, client apps are completely abstracted about the server's software, language and database. What our client apps do is to made HTTP calls and get and process HTTP responses. So, supose you ask to the server for the "users" of your app. You made a specific HTTP call and your server's response consists in an array of "users" in a JSON, ready to be used by your app.

Then you can process and do whatever you need with the server's response, and, you never know (not need to know) where the server pick that "users" information: can connect to any kind of database, read certain server's file, use PHP, ASP, etc., etc. The client app is completely abstracted about the server, so, the answer is yes, you can deal with PostgreSQL databases, but also with MySQL, MariaDB, Oracle, etc.


Everybody can read the DecSoft support forum for learning purposes, however only DecSoft customers can post new threads. Purchase one or more licenses of some DecSoft products in order to give this and other benefits.

This website uses some useful cookies to store your preferences.

I agree. Hide this note. Give me more information.