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
___
sql
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 hierarchical data set, where each level
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
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 tabl
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 add
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, char** headers)
>
> {
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.
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, absolutely guarantee that
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 = *(( map >*) data);
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
interfa
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
http://wanderinghorse.net/home/
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.
12 matches
Mail list logo