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.


Todo el mundo puede leer el foro de soporte de DecSoft para aprender del mismo, sin embargo, sólo los clientes de DecSoft pueden abrir nuevos hilos. Compre una o más licencias de productos de DecSoft y obtendrá este y otros beneficios.

Este sitio utiliza "cookies" útiles para almacenar sus preferencias.

Bien. Ocultar esta nota. Obtener más información.