Recommendation for SQLite in C++ in the style of RC6

[tmighty2]

Hello!

While I am mostly using VB6 or TB, I have to use C++ to create a certain 64bit ATL COM DLL that the Speech Application Programming Interface (SAPI) can consume.
This works fine.

The problem that I have now is that I need to use SQLite within that COM DLL now.
So far I have only used SQLite in VB6 via RichClient in VB6, so I am spoiled.

I would like to ask how other people who might have the same problem / task have solved this problem.

I guess I can make SQLite work with C++ (VS2022) and COM ATL DLL, but I guess it's a bigger task, especially because (as I said) I am so spoiled.

Thank you!

[wqweto]

> The problem that I have now is that I need to use SQLite within that COM DLL now.

This should be quite straighforward as sqlite is originally a C only project. Just include the amalgamated sources in your project and research its API to open/query dbfiles.

cheers,
</wqw>

[Zvoni]

This should be quite straighforward as sqlite is originally a C only project. Just include the amalgamated sources in your project and research its API to open/query dbfiles.

Which is a quagmire of function-calls.
I have looked at the sqlite-source, and I've never been more glad that there are smarter people than me....

EDIT: Maybe here: https://github.com/SRombauts/SQLiteCpp

[tmighty2]

Thank you very much for the suggestion!