I also had crashing problem on Windows 95 (yes, old Windows 95). I
posted a mail to this list, but was doing it on another email account so
it did not appear in list. I was wondering there might be some subtle
problems in sqlite3_open.
[EMAIL PROTECTED] wrote:
> Hello Team.
>
> I have a problem
I run sqlite3.exe under Windows 95 like this:
C:\sqlite3 test
sqlite>create table t(id);
Then sqlite3 crashes.
Leandro dos Santos Ribeiro wrote:
> Leandro dos Santos Ribeiro wrote:
>
>> D. Richard Hipp wrote:
>>
>>
>>> On Oct 10, 2008, at 4:59 PM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]
I have a customer database which appears corrupt. When I run sqlite3 mydb and
PRAGMA integrity_check I got (literally, no other lines):
Error: database disk image is malformed
However, I can .dump and .read to create a new database. The new database works
fine and the most surprising result is
> Are you using the same sqlite3 binary for both operations?
>
> If a database has a table definition that an older version of SQLite does not
> understand, it will sometimes give this error. If you’re using a newer
> version of SQLite to dump/load the files, there will be no error.
>
Yes, I am
The doc says:
Multi-thread.
In this mode, SQLite can be safely used by multiple threads provided that
no single database connection is used simultaneously in two or more threads.
I have a scenario that every sqlite3_calls around a single database connection
is protected by a recursive mutex, but
ce of memory that has been
> released.
>
> On Sun, Feb 8, 2015 at 3:00 AM, Dan Kennedy wrote:
>
>> On 02/08/2015 04:30 PM, Neo Anderson wrote:
>>
>>> The doc says:
>>>
>>> Multi-thread.
>>> In this mode, SQLite can be safely used by multiple
the thread calls sqlite3_reset or sqlite3_finalize).
>
> In multithread mode, you are taking over this responsibility; if you take
> care, you may nest several selects from different threads into a single
> transaction, but need to be aware of the fact that they will all commit or
> ro
I am utilizing lemon in one of my Apple Store Apps. My parser works fine with
the 'old' lempar.c found in source tree TRUNK/tool/.I also found a
newer version in TRUNK/src, but when I compile myparser.c generated using this
lempar.c, I got compilation errors:test.c:376:7: error: use of
undeclar
I'm trying to implement a VFS with encryption. I cannot find any detailed
documentation about some flags listed on http://www.sqlite.org/c3ref/vfs.html.
For example:
SQLITE_OPEN_MAIN_JOURNAL
SQLITE_OPEN_MASTER_JOURNAL
SQLITE_OPEN_SUBJOURNAL
There is a minimal mention of these flags in source c
I'm studying the demovfs listed on http://www.sqlite.org/vfs.html.
I've got a few questions:
1. By reading the comments, it seems that file read/write operations must be
buffered if it is a journal file. Is this required by sqlite design?
2. The demo uses nonbuffered open/read/write function to
; On 03/20/2013 05:00 PM, Neo Anderson wrote:
> > I'm studying the demovfs listed on http://www.sqlite.org/vfs.html.
> >
> > I've got a few questions:
> >
> > 1. By reading the comments, it seems that file read/write operations
> > must be buffered if it
iting a half of integer field and now power is
down. Can sqlite handle this?
> From: slav...@bigfraud.org
> Date: Wed, 20 Mar 2013 14:02:53 +
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] demovfs question
>
>
> On 20 Mar 2
Thanks.
> From: d...@sqlite.org
> Date: Wed, 20 Mar 2013 12:48:45 -0400
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] demovfs question
>
> On Wed, Mar 20, 2013 at 12:45 PM, Neo Anderson wrote:
>
> > Thanks for your de
I'm trying to implement a encryption VFS, but it turned out it's too tedious
and error prone. The main cause is that my simple VFS does not handle locking
well (or not at all). This leads to database file corruption when inserting
thousands of records (I believe).
Then I turned to the commercia
I'm building a custom library wrapper for Cocoa. I want to handle database
threading issue myself.
>From http://sqlite.org/compile.html#threadsafe:
[quote]
When compiled with SQLITE_THREADSAFE=2, SQLite can be used in a multithreaded
program so long as no two threads attempt to use the same dat
.
> From: d...@sqlite.org
> Date: Thu, 4 Sep 2014 10:07:02 -0400
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] SQLITE_THREADSAFE question
>
> On Thu, Sep 4, 2014 at 9:59 AM, Neo Anderson wrote:
>
>> I'm building a custom l
AFE question
>
> On Thu, Sep 4, 2014 at 10:14 AM, Neo Anderson wrote:
>
>>
>> 2. Fuctions that do not use sqlite3* and sqite3_stmt* such as
>> sqlite3_mprintf do not need mutex protection.
>>
>
> No. sqlite3_mprintf() does require mutex protection. If you disab
Understood. Thanks!
> From: d...@sqlite.org
> Date: Thu, 4 Sep 2014 11:42:52 -0400
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] SQLITE_THREADSAFE question
>
> On Thu, Sep 4, 2014 at 11:32 AM, Neo Anderson wrote:
>
>&
See the following result:
sqlite> select * from sqlite_master order by type;
type|name|tbl_name|rootpage|sql
index|sqlite_autoindex_t_1|t|4|
index|sqlite_autoindex_t3_1|t3|7|
table|t|t|2|CREATE TABLE t(id int primary key, key, value)
table|t2|t2|5|CREATE TABLE t2(id INTEGER primary key, key, valu
Is it possible to handle multiple results using sqlite3_step or any other API
calls?
I want to execute the following SQL in one statement and want to get the two
resultsets.
select 1 a; select 2 b;
___
sqlit
I think it's actually not practical to do this.
> To: sqlite-users@sqlite.org
> From: itandet...@mvps.org
> Date: Sun, 25 Mar 2012 08:42:11 -0400
> Subject: Re: [sqlite] Handle multiple results using sqlite3_step
>
> Neo Anderson wrote:
> > Is it possible to
ers@sqlite.org
> Subject: Re: [sqlite] Handle multiple results using sqlite3_step
>
>
> On Mar 25, 2012, at 9:36 PM, Neo Anderson wrote:
>
> > And I do not want to use big union.
>
> Out of curiosity, why is that? SQLite goes to great length to support
The UP/DOWN arrow keys do not work in sqlite3 for MAC OS X.
For example, I start sqlite3 and hit UP key, then I get:
$ sqlite3 Documents/test.db
SQLite version 3.7.11 2012-03-20 11:35:50
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> ^[[A
Is this a known probl
6.12) and up arrow returns
> last command as expected. Did you install 3.7.11 your self, if so I wonder
> if you missed a component (e.g. one which provides the cmd line
> functionality).
>
> On Fri, May 11, 2012 at 6:33 AM, Neo Anderson wrote:
>
> >
> > The UP/DOW
24 matches
Mail list logo