Qt and Db usage (asking for suggestions)
-
Hi,
I have an Oracle db, which is extremely busy. I am trying to fetch some data daily (daily stats , trends) from this Oracle Db and store in local pc, and draw charts for desired stats (i will use qwt most probably)
The reason behind storing local information is that it takes too much time (makes you to wait for minutes!) to query from Oracle Db since it is highly used. Best idea seems to me is;
- Update local data once a day (since i have previous data stored locally, it will not take too much time)
- according to user input, draw a chart (by using Qwt). The local stuff will be handled by Sqlite
Questions;
- is sqlite a good choice for local data handling? (Considering C style pointer based functions). It must be flexible and fast
- any good lib I can use instead of Qwt?
- Can I use Qt's Db functions to query data from main Oracle db and after storing locally use sqlite to access/query ?
Thanks
-
[quote author="fnoyanisi" date="1352698234"]
- is sqlite a good choice for local data handling? (Considering C style pointer based functions). It must be flexible and fast[/quote]From my experience using it, yes. In fact it is easier to transfer your app with qslite on it to client PCs as you dont need to install sqlite itself. Unlike other DBs like MySQL.
[quote author="fnoyanisi" date="1352698234"]
2) any good lib I can use instead of Qwt?[/quote]I am putting my attention to "QCustomPlot":http://www.workslikeclockwork.com/index.php/components/qt-plotting-widget/. Using Qwt was hard for me although it was packaged with lots of examples[quote author="fnoyanisi" date="1352698234"]
3) Can I use Qt's Db functions to query data from main Oracle db and after storing locally use sqlite to access/query ?[/quote]AFAIK, yes, but you need the driver used by Qt for Oracle DB, which you will need to build yourself since it wasn't packaged in any binaries of Qt library.