-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Zbigniew Baniewski wrote:
> How one should handle this? SQLite has UTF-8 by default.
You seem to doubt being all Unicode is a good thing :-) Read this
http://www.joelonsoftware.com/articles/Unicode.html
> What C-function (Linux) could be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Fin Springs wrote:
> Under what circumstances could one expect to get SQLITE_SCHEMA back
> from sqlite3_exec()?
When using the sqlite3_prepare_v2 api, SQLite attempts to reprepare
statements five times when the schema changes(*). In theory another
How one should handle this? SQLite has UTF-8 by default. This makes
a bit of conversion necessary before INSERTion (and the opposite after
SELECTion, and so on...) - am I right? Or perhaps it can be notified at
C-level about client-encoding - and is able to convert on its own?
What C-function
Hmm, it didn't help. I can still easily reproduce the TortoiseSVN bug.
The only reliable workaround is to use different journal_mode (or
implementing renaming of the journal file before deleting it).
Best regards,
F.
On Wed, Oct 15, 2008 at 2:33 PM, Shane Harrelson <[EMAIL PROTECTED]> wrote:
>
I have an application that uses SQLite 3.5.7. I have recently started
seeing occasional SQLITE_SCHEMA errors being returned by
sqlite3_exec() that I don't understand.
The application doesn't do ALTER TABLE. It creates the database file
afresh on each run (it's created in a RAM file system).
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jonathon wrote:
> I am interested in writing my own tokenizer for sqlite3. I've gone through
> Google, as well as the sqlite documentation and unfortunately, I haven't
> found anything helpful.
See the source directory
At 03:01 PM 10/15/2008, Jay A. Kreibich wrote:
>On Wed, Oct 15, 2008 at 01:38:16PM -0500, David Clark scratched on the wall:
> > Ok I want to convert a large application which uses ad-hoc data
> > structures and file formats to a sqlite database. But before I do that
> > I am working on a proof
I don't mean to pick on the OP, but this is such a commonly asked question
for people new to SQLite (including me not so long ago) that maybe putting
something like what you just said many places on the website (besides just
the Wiki) would help. Perhaps on the INSERT doc page? And maybe make it
Alberto Tellaeche <[EMAIL PROTECTED]>
wrote:
> Tank you very much for the response.
> the array is as expected, sprintf is woking fine. Also I get the same
> error if I write the SQL command directly in the sqlite3_exec()
> function, so this is not the error...
Show the CREATE TABLE statement for
On Oct 15, 2008, at 4:01 PM, Jay A. Kreibich wrote:
>
> Issue the command "BEGIN", do 100 to 1 INSERTs, issue a "COMMIT".
> You should see a very noticeable difference in speed.
>>
Just to amplify Jay's words: On a workstation, SQLite should do at
least 50,000 INSERTs per second. But
On Wed, Oct 15, 2008 at 01:38:16PM -0500, David Clark scratched on the wall:
> Ok I want to convert a large application which uses ad-hoc data
> structures and file formats to a sqlite database. But before I do that
> I am working on a proof of concept test to show that yea it will work
> once
On Oct 15, 2008, at 11:31 AM, Igor Tandetnik wrote:
> Alberto Tellaeche <[EMAIL PROTECTED]>
> wrote:
>> work perfectly well, but I am having a very annoying problem with
>> sqlite3_exec() function. The code just after the example above is:
>>
>> memset(orden_SQL,0,200*sizeof(char));
>>
Tank you very much for the response.
the array is as expected, sprintf is woking fine. Also I get the same error if
I write the SQL command directly in the sqlite3_exec() function, so this is not
the error...
Thank you again for the interest,
Regards
alberto
- Mensaje original
De:
Hello all,
I am interested in writing my own tokenizer for sqlite3. I've gone through
Google, as well as the sqlite documentation and unfortunately, I haven't
found anything helpful. I am interested in writing my own tokenizer so that
I could perform "partial string" matches in sqlite's
Sorry, I should have stated that I am not defining SQLITE_MUTEX_NOOP
explicitly. SQLITE_MUTEX_NOOP is defined implicitly if you let
SQLITE_THREADSAFE default to 1 and define SQLITE_OS_OTHER=1 (i.e. do not
use SQLITE_OS_UNIX, SQLITE_OS_WIN or SQLITE_OS_OS2). I know this won't
affect many people,
Ok I know this is not what sqlite was designed for. But via a odbc
driver or any other extension tool is it possible to have remote
clients read/write/query sqlite tables?
The reason I ask. We have remote installations that generate data in
local tables. Then we have hit those
Ok I want to convert a large application which uses ad-hoc data
structures and file formats to a sqlite database. But before I do that
I am working on a proof of concept test to show that yea it will work
once conversion is done.
But alas my first test is failing miserably. Well, it works it
Hi guys,
We are using sqlite as our database and noticed some weird odbc driver
problem.
"malformed database schema (deleteUserGroupsByUsers) - no such
table: main.Users (11)"
If I open the database with other tool such as sqlite studio, or firefox
plug in, there is no problem - the schema
I found a small compile error when SQLITE_MUTEX_NOOP is defined with the
amalgamation source:
sh4gcc -ansi -fsigned-char -mruntime=os21 -ml -c -O0
-DSQLITE_OS_OTHER=1 -DSQLITE_32BIT_ROWID=1 -DSQLITE_INT64_TYPE=long
-DSQLITE_OMIT_AUTHORIZATION -DSQLITE_OMIT_AUTOINCREMENT
-DSQLITE_OMIT_AUTOINIT
On Oct 15, 2008, at 1:31 PM, Dave Toll wrote:
> I found a small compile error when SQLITE_MUTEX_NOOP is defined with
> the
> amalgamation source:
>
SQLITE_MUTEX_NOOP is an internal symbol that gets set if and only if
you define SQLITE_THREADSAFE=0. You should not set SQLITE_MUTEX_NOOP
I searched all the archives to no avail, so I'm probably just making this up,
but I was positive that someone posted an SQLite interface written in Liberty
Basic in the last month or two. If you are the person who posted such a
program, if you know who did, or if you are neither but have done
Karl Lautman <[EMAIL PROTECTED]> wrote:
> So, I create a table as follows:
>
> CREATE TABLE IF NOT EXISTS Lists (
> wID integer,
> ltitle text,
> llink text,
> units text,
> date text,
> ListsID integer,
> new integer
> , CONSTRAINT Lists_pk PRIMARY KEY (ListsID))
Be aware that, in order to
On 10/15/2008 09:27 AM, Karl Lautman wrote:
> To insert data I do (this is in Python):
>
>
>
> x = dcur.execute('insert into Lists values (?, ?, ?, ?, ?, ?)', (123,
> 'YouTube Videos','http://www.youtube.com', 'views', '10/14/08', 4))
Just add NULL for the primary key value. SQLite will
So, I create a table as follows:
CREATE TABLE IF NOT EXISTS Lists (
wID integer,
ltitle text,
llink text,
units text,
date text,
ListsID integer,
new integer
, CONSTRAINT Lists_pk PRIMARY KEY (ListsID))
To insert data I do (this is in Python):
x = dcur.execute('insert into
>Hi all,
>
>I have a Perl Catalyst app using SQLite as storage. It has been running
>for several months without any problem.
>Now in the last few days we had several crashes of SQLite (file gets
>corrupted). This is just incomprehensible because all development and
>production engineers claim
Alberto Tellaeche <[EMAIL PROTECTED]>
wrote:
> work perfectly well, but I am having a very annoying problem with
> sqlite3_exec() function. The code just after the example above is:
>
>memset(orden_SQL,0,200*sizeof(char));
>sprintf(orden_SQL,"update ALUMNO set nota=%0.1f where
>
Hello colleagues;
I am new to sqlite, and I have recently started to use it from the command line
(sqlite3.exe) and in C programs.
In my C example program I open de database at the beginning and close it
beforte the end of the program.
Examples like:
memset(orden_SQL, 0,
That's a tricky one. Databases like random access, but DVD-ROM not so
much :) Maybe delete indexes to force a full table scan?
On Wed, Oct 15, 2008 at 5:47 AM, Christophe Leske <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> i am using a 120MB database in an embedded project (a DVD-ROM project)
>
Hello, Aaron.
Have you tried Mr. Griggs' solution yet? Please be aware that posting
the same question for the *third* time in a row will not make it any
more visible, but will dramatically increase the chance that people will
become annoyed and will not help you.
Thank you for your
Hi there,
i am using a 120MB database in an embedded project (a DVD-ROM project)
and was wondering what I can do to speed up its reading using diverse
PRAGMA statements.
The database is locked, meaning that no data is being inserted or
deleted from it. I am solely after speeding up its reading
"jm cuaz" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Is there a workaround to execute this kind of SQL statement inSQLite :
>
> "UPDATE VariablesPointages INNER JOIN Sociétés ON Sociétés.Mois =
> VariablesPointages.Mois
> SET VariablesPointages.CodSoc = Sociétés.CodSoc,
>
Possibly HW (memory, disk, etc.) failures?
On Wed, Oct 15, 2008 at 2:54 AM, Dami Laurent (PJ) <
[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I have a Perl Catalyst app using SQLite as storage. It has been running
> for several months without any problem.
> Now in the last few days we had several
Version 3.6.1 (IIRC) had changes to improve the error detection and retry
logic for this condition (typically caused when a 3rd party application
opens the SQLite journal file.)
HTH.
-Shane
On Mon, Oct 13, 2008 at 12:52 PM, Doug <[EMAIL PROTECTED]> wrote:
> I'm using SQLite 3.5.6 on Windows
Hi all,
I have a Perl Catalyst app using SQLite as storage. It has been running
for several months without any problem.
Now in the last few days we had several crashes of SQLite (file gets
corrupted). This is just incomprehensible because all development and
production engineers claim that
Regarding:
"iv got a database which was made my a program called BluePhoneElite,
its a Mac OS X piece of software which pairs with a mobile phone over
bluetooth to allow messages and calls to be managed from the computer...
awesome piece of software untill it breaks.
Somehow the database has
Heya guys,
iv got a database which was made my a program called BluePhoneElite, its a
Mac OS X piece of software which pairs with a mobile phone over bluetooth to
allow messages and calls to be managed from the computer... awesome piece of
software untill it breaks.
Somehow the database has
Try
http://sqlite.org/releaselog/3_6_4.html
On Wed, Oct 15, 2008 at 8:17 AM, Alexey Pechnikov <[EMAIL PROTECTED]>wrote:
> Hello!
>
> В сообщении от Wednesday 15 October 2008 16:11:47 D. Richard Hipp
> написал(а):
> > For a summary of changes and enhancements
> > that have occurred in version
On Oct 15, 2008, at 8:11 AM, D. Richard Hipp wrote:
> SQLite version 3.6.4 is now available for download on the SQLite
> website:
>
> http://www..sqlite.org/download.html
>
> SQLite version 3.6.4 is considered a stable release. Upgrading from
> version 3.6.3 is optional. For a summary
Hello!
В сообщении от Wednesday 15 October 2008 16:11:47 D. Richard Hipp написал(а):
> For a summary of changes and enhancements
> that have occurred in version 3.6.4 visit
>
> http://www.sqlite.org/3_6_4.html
Document Not Found
The document /3_6_4.html is not avaivable on this server
SQLite version 3.6.4 is now available for download on the SQLite
website:
http://www..sqlite.org/download.html
SQLite version 3.6.4 is considered a stable release. Upgrading from
version 3.6.3 is optional. For a summary of changes and enhancements
that have occurred in version
"TW" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> I have this query:
>
> SELECT title, artist, hd, bank, bookmark, genre, class, classnumber
> FROM music
> WHERE classnumber=6 OR classnumber=7
> AND hd="B"
> UNION
> SELECT title, artist, hd, bank, bookmark, genre, class,
Hi,
I have this query:
SELECT title, artist, hd, bank, bookmark, genre, class, classnumber
FROM music
WHERE classnumber=6 OR classnumber=7
AND hd="B"
UNION
SELECT title, artist, hd, bank, bookmark, genre, class, classnumber
42 matches
Mail list logo