Have you tried using SQLite as your query engine for your * raw * database?

Question

I created my own report generator for our database ( Oracle Berkeley DB engine ). Now I need to add more flexibility, and I'm in a dilemma. Do a partial or fundamental redesign?

• Suppose I have a lot of time.
• I can only read the database, I have no right to modify it.

Inspired from the Anything with SQLite query , I would like to allow SQLite to do the dirty work (grouping, filtering, etc.).

Have you tried this? Any examples? What about performance issues?

Answer 1

It works great for the fact that I use it :-) However, I do not use it together with another database, just stand-alone. There is a list of SQlite Famous Users on its website .

You need to tell us more about your work in order to make any performance assumptions, but I would prefer to do POC and measure performance. Long-term false programming assumptions

There is a good article quickstart sqlite article .

Here 's the C / C ++ API Reference .

, SQLite, SQLite. , ..