I am trying to investigate .db-wal file gathered from sudden power off.
Is there any existing to open and list up all records of .db-wal file?
Or do I have to check each frame and record by myself using sqlite spec.?
Thanks and Regards,
On Sun, Jul 10, 2011 at 10:52 AM, Christopher Melen
> I am developing an application which analyses audio data, and I have recently
> been looking into Sqlite as a possible file format. The result of an analysis
> in my application is a
This time the code below work perfectly!
exec("drop table if exists tbl2");
$dbh->exec("create table tbl2 (one varchar(10),two varchar(10))");
$dbh->exec("insert into tbl2 values('test1a','test2a')");
$dbh->exec("insert into tbl2 values('test1b','test2b')");
$dbh->exec("insert into tbl2
I can see adding a forward/reverse link to the tables making it a linked-list
type structure much like your btree.
By default each node is linked to the one in front and back. Then you adjust
those pointers for cut/paste operations.
You could also do the cut/paste just by copying to a new
Many thanks for your neat, simple suggestion, Michael. Sometimes you can miss
the wood for the btrees...
Using tables seems a very attractive way to maintain such a hierarchy. The
problem is that I need to be able to operate on the structure in a way not
limited to just updating nodes and
On 7/11/2011 11:04 AM, Prakash Reddy Bande wrote:
> We were looking at the ways we can optimize our application. Our app
> does a simple sqlite3_exec and sends the callback as below. The data
> is just a map
> int sqlite3TableCallback(void* data, int ncols, char** values,
On 11 Jul 2011, at 2:18pm, Black, Michael (IS) wrote:
> If CREATE has no return why do I get a return?
Whoever wrote that isn't familiar with SQLite's habits. They don't know that
most SQLite functions return a result code rather than some piece of data
relating to the operating.
On Mon, Jul 11, 2011 at 11:04 AM, Prakash Reddy Bande
> Well, the bottom line, is it safe to assume that char** headers will be
> pointing to the same address through out the query (i.e. each time callback
> is called for a matching row).
We cannot positively,
We were looking at the ways we can optimize our application. Our app does a
simple sqlite3_exec and sends the callback as below. The data is just a
int sqlite3TableCallback(void* data, int ncols, char** values, char** headers)
If CREATE has no return why do I get a return?
To be clear I'm using PHP 5.3.6 and it most definitely gets a return
But I re-wrote this according to some PDO examples I found. This is a more
You should be able to run this with a PHP command line -- forget the web
On Mon, Jul 11, 2011 at 2:41 AM, James_21th wrote:
> $result=$dbh->query("create table tbl2 (one varchar(10),two
A CREATE statement has no results. In PDO, only SELECT (and similar) return
a result, if i'm not mistaken.
- stephan beal
On 11 Jul 2011, at 7:17am, Sreekumar TP wrote:
> (1) In SQLite versio 3.5.o an above we can enable the "shared cache" mode.
> Is the shared cache shared between two processes ? OR is shared only
> between the threads in the process ?
On Sat, Jul 9, 2011 at 23:22, Stephan Beal wrote:
> On Sun, Jul 10, 2011 at 4:25 AM, Tom Browder
> > sqlite db files and making sure that directory is writable by my web
> > server. I make sure that the directory is not used for anything
(1) In SQLite versio 3.5.o an above we can enable the "shared cache" mode.
Is the shared cache shared between two processes ? OR is shared only
between the threads in the process ?
sqlite-users mailing list
Mail list logo