Tests : Maria DB missing.

[rathnadhar]

Namaskara,

Thanks for this wonderful library.

I am coding a OSS based trader. I wanted to use SQLPP11.

I cloned the git repository and built it. However I am not seeing any file (or section related to Mariadb). I see sections on Mysql, PostGresql and SQL lite. Mariadb seems missing. Can I go head and use mySql for MariaDB backend?

I will be wonderful if you can add tests for Mariadb.

With Warm Regards, Rathnadhar K V

[rbock]

Hi Rathnadhar,

Thanks for the nice feedback!

Admittedly, it has been a while since last I tested with MariaDB (and right now, I cannot test it myself), but you should be able to use instead of MySQL. Please give it a try and let me know whether it worked?

That said, true, I should add tests for MariaDB.

Best, Roland

[MeanSquaredError]

@rathnadhar

sqlpp11 works fine with MariaDB, just use the MySQL connector and connect to the MariaDB database. Also all sqlp11 MySQL tests pass correctly with a MariaDB backend.

MariaDB and MySQL are pretty much the same database.

EDIT: All of the PRs that I submit are tested with PostgreSQL, MySQL (I actually use a MariaDB database) and SQLite3. The last PR that I submitted was 2-3 weeks ago, so I am pretty sure that the MySQL/MariaDB connector works fine.

[MeanSquaredError]

Essentially when the CMake option BUILD_MARIADB_CONNECTOR is enabled it checks if MariaDB is installed, but the user should use the MySQL connector, because MariaDB is (mostly) the same database as MySQL, so there is no point in duplicating the code.

The situation with SQLite3 and SQLCipher connectors is similar. We only have code for the SQLite3 connector and if the user wants to connect to an SQLCipher database, then he should use the SQLite3 connector.

I think that this is mostly a documentation issue and it could be resolved by updating the documentation.

[rbock]

Thanks for the confirmation, @MeanSquaredError !

Yes, it is primarily a documentation issue. It might still make sense to add a tests that make use of an actual MariaDB backend (same with SQLCipher).

[rathnadhar]

Thanks for the feedback, I will test with MariaDB and will revert with the results.

Again, Thank you so much.

Regards, [image: photograph]

Rathnadhar K V CEO E @.*** Akshobhya Investments introcard.in/rathnadhar [image: facebook icon] https://www.facebook.com/rathnadhar/ [image: twitter icon] https://twitter.com/RathnadharKV [image: linkedin icon] https://www.linkedin.com/in/rathnadhar [image: https://www.rotary.org] https://www.rotary.org

On Sat, Sep 14, 2024 at 4:04 PM Roland Bock @.***> wrote:

Hi Rathnadhar,

Thanks for the nice feedback!

Admittedly, it has been a while since last I tested with MariaDB (and right now, I cannot test it myself), but you should be able to use instead of MySQL. Please give it a try and let me know whether it worked?

That said, true, I should add tests for MariaDB.

Best, Roland

— Reply to this email directly, view it on GitHub https://github.com/rbock/sqlpp11/issues/599#issuecomment-2350945723, or unsubscribe https://github.com/notifications/unsubscribe-auth/ANWFAAD2BXPICFUXCSBGYXLZWQGJTAVCNFSM6AAAAABOGV54BOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGNJQHE2DKNZSGM . You are receiving this because you authored the thread.Message ID: @.***>

[rbock]

Since you did not report back, I assume this is resolved?