U++ forum: Welcome to the forum

Re: Sql object [message #56202 is a reply to message #56198]

Mon, 08 February 2021 06:42

dolik.rce
Messages: 1791
Registered: August 2008
Location: Czech Republic

Ultimate Contributor

Hi mubeta,

Years ago, I've been trying something similar. I've come with a solution, where the sql code was compiled as dynamic library, so the final program didn't even require mysql libraries to run, unless it was configured to use mysql. You can find the code on my github, if you're intrested: https://github.com/dolik-rce/thewatchdog/tree/master/src/Dyn amicSql

Note however few important things:

The code is pretty old, ~7 years, it might not work with current U++.
I do not use the code anymore, and don't maintain it, so I cannot guarantee or support it in anyway.
It also needed little patch of U++ sources: https://github.com/dolik-rce/thewatchdog/blob/master/patch/M ySql.patch
Only MySql and SQLite are implemented, but adding more options should be easy
Actually the worst part was not to allow dynamic selection of engine, but to write queries in a way that is compatible with both sqlite and mysql. In theory there is ANSI SQL, which should be a common subset of all SQL languages, but reality is much different

Anyway, I hope this helps, or at least inspires you (or someone else in future) Smile

Best regards,
Honza

Report message to a moderator