Discussion of article "How to Access the MySQL Database from MQL5 (MQL4)" - page 23

 
MQLMySQL repository version 3.0 has been released and published on GitHub: https: //github.com/elugovoy/MQLMySQL-Project

Any further fixes and updates will be made in the GitHub repository.

Code page UTF-8 is now supported.

The project retains 3 directories for:
-MQL4 x86 - feature set
-MQL5 x64 (old style) - feature set
-MQL5 x64 (classes) - classes for MQL5

All details in README.md

Thanks for any support and accept PayPal: https//www.paypal.me/elugovoy
elugovoy/MQLMySQL-Project
elugovoy/MQLMySQL-Project
  • elugovoy
  • github.com
The problem of interaction of MQL with databases is not new, however it's still relevant. Use of databases can greatly enhance the possibilities of MetaTrader: storage and analysis of the price history, copying trades from one trading platform to another, providing quotes/trades in real time, heavy analytical computations on the server side...
 
Shorttimer:
Great library. Too bad it doesn't support Cyrillic alphabet.

Version 3.0 does.

 
Valentin Dobroletov:

has anyone converted to UTF-8 ?

Version 3.0 includes work with UTF-8

 
procomK:
Dear experts, please advise me.
For 2 years 32-bit permvar2.dll (from MessageBoxW(uint hWnd,string lpText,string lpCaption,uint uType);

int PVInit(string);
int PVValue(int,string,int);
int PVGetValue(int,string);

Compiles, but gives error :
'C:\Program Files\ForexClub MT5\MQL5\Libraries\permvar2.dll' is not 64-bit version
Cannot load 'C:\Program Files\ForexClub MT5\MQL5\Libraries\permvar2.dll' [193]

If calling permvar.dll
#import "stdlib.ex5"
#import "permvar.dll"

Message :
unresolved import function call

Can it be initiated differently ?

This is a bit off-topic, but MT5 terminal gives you a hint - your library is 32-bit, under MT5 you need a version compiled for x64. It will not work otherwise. Ask the developers if there is a 64-bit version.

 
Dmitry Melnichenko:

Maybe a little late but still.... I need to know for testing:

1. Is the Expert Advisor run on different terminals? Or on the same terminal but on different charts?

For different terminals DLL is loaded into its own memory area and there should be no such collisions.

2. the WHERE phrase is framed in brackets, in principle it should not affect, but still it is not a standard SQL.

3. what does the SqlModifyClient(ticket, open_ticket) function return ?

4. what version of MQLMySQL.dll is used?

I will try to test

 
The latest release has in-house DatabaseXXX functions that implement in-house Sqlite bases.
Документация по MQL5: Работа с базами данных
Документация по MQL5: Работа с базами данных
  • www.mql5.com
Важной особенностью данного движка является то, что вся база данных находится в единственном стандартном файле, который находится на компьютере пользователя. Простота реализации достигается за счёт того, что перед началом исполнения транзакции записи файл, содержащий базу данных, блокируется. При этом...
 
Renat Fatkhullin:
The latest release has in-house DatabaseXXX functions that implement in-house Sqlite bases.

This is great

 
Eugeniy Lugovoy:

Version 3.0 includes work with UTF-8

Great news! Thank you!

 
Eugeniy Lugovoy:
The MQLMySQL library version 3.0 is released and published on GitHub: https://github.com/elugovoy/MQLMySQL-Project

Any further fixes & updates would be made in GitHub repository.


Codepage UTF-8 is supported now.


Project keeps 3 directories for:
- MQL4 x86 - function set
- MQL5 x64 (old school) - function set
- MQL5 x64 (classes) - classes for MQL5

<Deleted>


Happy New Year & good luck in development!

Eugene

Hi Eugeniy, thank you so much for your contribution. It´s very usefull and really works! 

 

Eugeniy Lugovoy:

The MQLMySQL library version 3.0 is released and published on GitHub: https://github.com/elugovoy/MQLMySQL-Project

Any further fixes & updates would be made in GitHub repository.


Codepage UTF-8 is supported now.


Project keeps 3 directories for:
- MQL4 x86 - function set
- MQL5 x64 (old school) - function set
- MQL5 x64 (classes) - classes for MQL5

<Deleted>


Happy New Year & good luck in development!

Eugene

Hi, wow thanks for all of this, there's a problem with my notifications so I've only just seen that you did this several months later.

Thanks very much, great work.

Peter