[sqlite] Is there any existing to open .db-wal file?

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, Sung ___

Re: [sqlite] Storing/editing hierarchical data sets

On Sun, Jul 10, 2011 at 10:52 AM, Christopher Melen wrote: > > Hi, > > > 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

Re: [sqlite] Insert not working for sqlite3

Dear all, 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

Re: [sqlite] Storing/editing hierarchical data sets

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

Re: [sqlite] Storing/editing hierarchical data sets

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

Re: [sqlite] Header pointers in table callback

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,

Re: [sqlite] Insert not working for sqlite3

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. Simon.

Re: [sqlite] Header pointers in table callback

On Mon, Jul 11, 2011 at 11:04 AM, Prakash Reddy Bande wrote: > > 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,

[sqlite] Header pointers in table callback

Hi, 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, char** headers) { map& table

Re: [sqlite] Insert not working for sqlite3

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 complete example. You should be able to run this with a PHP command line -- forget the web

Re: [sqlite] Insert not working for sqlite3

On Mon, Jul 11, 2011 at 2:41 AM, James_21th wrote: > $result=$dbh->query("create table tbl2 (one varchar(10),two > varchar(10));"); > A CREATE statement has no results. In PDO, only SELECT (and similar) return a result, if i'm not mistaken. -- - stephan beal

Re: [sqlite] Question on Shared Cache Mode

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 ? http://www.sqlite.org/sharedcache.html Simon.

Re: [sqlite] Can a sys admin control temporary file location without changing the source code?

On Sat, Jul 9, 2011 at 23:22, Stephan Beal wrote: > On Sun, Jul 10, 2011 at 4:25 AM, Tom Browder > wrote: > > > 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

[sqlite] Question on Shared Cache Mode

Hello, (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 sqlite-users@sqlite.org