MT4/5 data to a postgres db

[Panikos Stavrou]

Hi all, 

I would like to set up a process that syncs the MT4/5 server data to a postgres db. I would like for it to be live and run continuously to sync the two dbs. 

Can someone point me to the right approach and choice of tools required?

Thank you.

[Dominik Egert]

Well, its for mysql, but should give you an idea on how to go about it...

EDIT:

I just noticed, you will need the MQLplus error library from code base...

I have attached the current version and here is the link to the published version:

https://www.mql5.com/en/code/32083;

Or you remove the corresponding error handling functions from the file lib_mysql.mqh.

[Panikos Stavrou]

Thank you!

Hopefully i can make it work with PostgreSQL as well.

Dominik Egert #:

Well, its for mysql, but should give you an idea on how to go about it...

EDIT:

I just noticed, you will need the MQLplus error library from code base...

I have attached the current version and here is the link to the published version:

https://www.mql5.com/en/code/32083;

Or you remove the corresponding error handling functions from the file lib_mysql.mqh.

[Dominik Egert]

Share if you succeed.

[Carlos Camargo]

Dominik Christian Egert #:

Share if you succeed.

Could you, please, share with us hints or how-to (setup) about PostgreSQL database access of your application? I would like to store some EA data on PostgreSQL.

Thanks,

[Dominik Egert]

See my post #1, it's for MySQL. The integration of PostgreSQL is similar.

You'll need to adapt it on your own.

[Daniela Orellana]

Dominik Christian Egert #:

See my post #1, it's for MySQL. The integration of PostgreSQL is similar.

You'll need to adapt it on your own.

Hi! Can you please share a tutorial or something to help for building a file like pgsql.mqh or  libpq.mqh for database connection with postgresql with mt4 

[Dominik Egert]

Daniela Orellana #:
Hi! Can you please share a tutorial or something to help for building a file like pgsql.mqh or  libpq.mqh for database connection with postgresql with mt4 

Sorry, but you will have to adapt it yourself. I never did it up to today and currently I have no plans to do so.

But it is not very hard, in fact, if you take a close look it's just changing the client DLL and adapting the function calls accordingly. Maybe you would want error messages as well, then you need to adapt the error messages, Copy/paste work....

[Jocimar Lopes]

Daniela Orellana #:
Hi! Can you please share a tutorial or something to help for building a file like pgsql.mqh or  libpq.mqh for database connection with postgresql with mt4 

I couple of weeks ago I took some notes about MQL5 and Postgres connection.

https://www.mql5.com/en/articles/12308

Depending on your needs, it may be of some help.