HDB++ : is there any odbc driver?

General Development
1

Hi tangoers,
in HDB++ repositories, I’ve seen several plugins for databases : Cassandra, MariaDB, TimescaleDB, PostgreSQL, sqlite and ElasticSearch.
I also saw some explanations on the HDB++ presentation.

I wonder if it was discussed to develop ODBC driver?

2

Hi @gauron, sure ODBC is an old standard but with huge survival qualities. Early in my career (circa 2000) I worked with it and found direct ODBC usage cumbersome, so I typically used ADO over an ODBC driver instead. I’ve also wondered why HDB++ doesn’t use an ORM layer, but in practice that would hide database-specific strengths (e.g., Timescale hypertables), so the choice to write several DB backends makes probably sense. What’s your specific use case?

3

Hi @AlexK,
It’s much more a principle question.
We encountered a similar case with ArchivingRoot and we would have been happy if we could change MariaDb for PostgreSQL.

For HDB++, I do not see a specific issue for my usecase since a postgreSQL plugin already exists.