SQLite in MQL5: new features and performance testing - page 5

[Реter Konow]

Roman:

The inclusion of the databasefile as a resource, most likely, is intended only for unpacking the file on disk, from ex5.
Further work with the database, happens directly to the file.

The database file can be saved in a resource, but only in RAM. It is impossible to normally save THIS resource to disk through ResourceSave. It distorts non-color data.

To include a file as a resource in the EA, it must already be as a resource on disk. But, for now, it cannot normally be saved as a resource. This is what I mean.

[Реter Konow]

It is one thing to save the data in the resource, and another thing to save the resource itself.

You can save everything in the resource, but everything is lost when the computer is switched off. To keep it, you need to save the resource to disk.

Why save to a resource and not to a file? - So that you can integrate it into the EA.

You can integrate the resource into the Expert Advisor if the resource is saved on disk. There is no other way.

At present, only resources with an image can be saved on the disk. The rest of them are distorted. Therefore, not all of the data can be included to the Expert Advisor as a resource.

[Rashid Umarov]

Added function examples - in order of complexity:

• DatabaseReadBind
• DatabaseTransactionBegin
• DatabasePrepare
• DatabaseExecute

[Edgar Akhmadeev]

Rashid Umarov:

Added function examples - in order of complexity:

• DatabaseReadBind
• DatabaseTransactionBegin
• DatabasePrepare
• DatabaseExecute

I wouldn't have guessed that the English documentation contains examples, unlike the Russian one.

[Yury Kulikov]

Реter Konow:

Consequently, not all data can be included in the EA as a resource.

Resource variables

[Реter Konow]

Yury Kulikov:

Resource variables

Not everything can be saved correctly with ResourceSave(), and if everything is saved, not everything can be integrated correctly. More precisely, everything can be integrated, but not everything at once... ))))

[Реter Konow]

Реter Konow:
Not everything can be saved correctly with ResourceSave(), and if everything is saved, not everything can be integrated correctly. More precisely, everything can be integrated, but not everything at once... ))))

Not all data can be integrated correctly into the EA if that data was saved via ResourceSave() and is not an image. That's what I meant to say.

[Rashid Umarov]

Edgar Akhmadeev:

I wouldn't have guessed that the English documentation has examples, unlike the Russian one.

The Russian one didn't have one example, so I gave the English links.

[Yury Kulikov]

Реter Konow:
Not all data can be integrated into the EA in the correct way if this data has been saved via ResourceSave() and is not an image. That's what I meant to say.

Why save data with ResourceSave when FileSave is available?

[Реter Konow]

Yury Kulikov:

Why save data with ResourceSave when FileSave is available?

It's better to save a resource with ResourceSave, because by integrating it into the Expert Advisor, we immediately get its content into an array with ResourceReadImage. It's convenient and fast, but it's not universal. I haven't integrated binary files as resources, so I don't know how to make them readable again.