Hi ! I want to use SQLite database like the FireBird database: with big isolation level. What's that meaning ?
I have an application that periodically check some input directory, process the elements in it, and copy them into a global database. It is like a daemon, working in the background. The end-user uses an another GUI application, that can create reports from this database. Ok. In FireBird I can do it fine that the user's app use another transaction with READ REPEATABLE style, and the daemon use another transaction too, with same style. This style is correctly separate two transactions, the user see full consistent state in database. If daemon has been finished the work, commit and close it's transaction - but that is not confused the user's reporter program. Example: I open the database for create reports from a master-detail table. Example bills. The code get every bills. If daemon see a new data, it is get it, and put to the database. Now it is see a new data. It is make insert/update sqls. The reporter tool read the bill 002 head. The daemon write this head, and append a new subitem to bill's subitems table. Commit. If ISOLATION LEVEL is low, the report can see the new subitems of the bill, but the bill's head is not same - inconsistency we get. Example: Bills head have 3 items, the total charge is 600$. In low Isol. level when the daemon is add new records to this bill, the head total is remaining 600$, but calculated subtotals are bigger than this. In the big isolation level (repeatable read) the reporter not see the any changes in the database only what it makes. I can do same effect if I create "transaction aliasing code". I need to extend my tables with recversion field that containing a timestamp value. And every SQL I need to extend with where timestamp is... But it is very ugly solution... Please help me: have the SQLite same tr. isol. mechanism like FireBird ? http://www.dotnetfirebird.org/transaction-isolation-levels http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;KNOWLEDGEBASE;ID='377' http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;KNOWLEDGEBASE;ID='128' http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;KNOWLEDGEBASE;ID='129' Thanx for your help: dd
