WebSite X5Help Center

 
Jürgen Z.
Jürgen Z.
User

X5 and POSTGRES  en

Автор: Jürgen Z.
Просмотрено 1102, Подписчики 1, Размещенный 0  

Hello everybody,

I'd like to out a X5 made website on top of an MES system, where all data, products, descriptions, pictures are already ready accessible in an POSTGRES database.

Can I change to DB access of X5 permanently from MySQL to POSTGRES ? Or should I modify the DB access in the scripts manually ?

Thanks for your help,

J.K.

Размещено
3 Ответы
Jürgen Z.
Jürgen Z.
User
Автор

yell... I'd like to put a X5 made website ... innocent

Читать больше
Размещено От Jürgen Z.
Axel  
Axel  
User

Hello Guy,

From my point of view it's not possible... undecided

WSX5 is based on MySQL and if you try to change the connectiviy code manually all  others commands are hardcoded.

By example inside the code there is probably some  commands like:

$connection_id=mysql_pconnect($hostname, $username, $password);  
mysql_select_db($database, $connection_id);

to establish the connection with the DB.

And in PostGres the connectivity is more:

$connection_id=pg_connect("host=$hostname dbname=$database user=$username   password=$password");

And some functions are a little bit different like into MySQL: 

$result_data = mysql_query("query goes here", $connection_id);

and with Postgres:

$result_data = pg_exec($connection_id, "query goes here").

Hope this helps

Enjoy

https://wsx5.afsoftware.fr

Читать больше
Размещено От Axel  
Jürgen Z.
Jürgen Z.
User
Автор

Hello, 

thanks for yor answer. It's pity that X5 can'tr use POSTGRES directly. I was doing/testing some stuff in HTML/php/JS to access the PG database and I tested a way to get around that problem ... Makes probably more work, but it does work ..

Cheerio,

Jürgen

Читать больше
Размещено От Jürgen Z.