Solved

.net app with sqlite db

Posted on 2013-02-06
2
378 Views
Last Modified: 2013-02-11
Hi -
I have a sqlite database that uses Write-Ahead Log (wal). So the main db does not update live.

I need to right an app in .net (vb) that gets real time stats.

If I copy the db file and the wal file to my local hard drive, is there anyway to flush/merge the data to update the main db.

e.g
file 1: test.db (main db)
file 2: test.db-wal (wal file holding current information)

want to flush test.db-wal into test.db  so the the most resent information is in the main db

Thanks in advance
0
Comment
Question by:doctor069
2 Comments
 
LVL 11

Accepted Solution

by:
madgino earned 500 total points
ID: 38862961
The synchronization between wal and main is called "checkpoint"
It seems that doing a "checkpoint" is not possible using .NET library, at least there is nothing documented about this.

The operation seems to be available from the C library, you have below the documentation but I couldn't find an example.

Theoretically you can call C libraries from .NET.

http://www.sqlite.org/c3ref/wal_checkpoint_v2.html
http://www.sqlite.org/c3ref/wal_checkpoint.html



https://www.google.com/#hl=en&q=using+c+library+in+.net
0
 

Author Closing Comment

by:doctor069
ID: 38877120
Thanks for the insight. I looked for a .net solution but there is nothing out there...
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question