On Nov 22, 2007 1:04 PM, Daniel Önnerby <[EMAIL PROTECTED]> wrote:
> In the future I am using UTF8 encoded databases since the conversion of
> strings is a small thing for the system. The advantages of using UTF8
> are many:
> 1. Faster in most cases
> 2. Smaller databases (30% smaller in benchmark
On 11/22/07, Tara_Nair <[EMAIL PROTECTED]> wrote:
> I just recently started to use Sqlite3 version 3.5.2 on an ARM-LINUX
> based embedded platform.
> Sqlite3-v3.5.2. has a dependency on libc, ld and libpthread versions 2.2.3.
Er.. it should depend on whatever versions you link it against when
you
Hello all,
I just recently started to use Sqlite3 version 3.5.2 on an ARM-LINUX
based embedded platform.
Sqlite3-v3.5.2. has a dependency on libc, ld and libpthread versions 2.2.3.
My sorrow is that the rest of my application and the libraries on my
ramdisk are of version 2.1.3. It doesn't seem t
Hi all:
I've just downloaded, compiled and installed SQLite3 3.5.2 on my mac.
Everything is working fine but the version number. I know OS X 10.4 comes
with SQLite built-in on /usr/bin. I installed 3.5.2 on /usr/local and
updated my PATH so that is all right. Look at what I get:
xabita:/ xabriel
3.5.2 from the ZIP file,
Compiled under Visual Studio 2005.
Static Library
SQLITE_OMIT_AUTHORIZATION
SQLITE_OMIT_AUTOVACUUM
SQLITE_OMIT_BLOB_LITERAL
SQLITE_OMIT_DATETIME_FUNCS
_CRT_SECURE_NO_DEPRECATE
SQLITE_MEMORY_SIZE=100
SQLITE_CORE
A couple weeks ago I reported a crash when I used the
SQL
When I started using SQLite I found it natural to use the sqlite3_open16
and use UTF16 encoding on strings since my applications always use
wchar_t when handeling strings. I never questioned this until now when I
decided to do some benchmark, and I found it interesting enough to share
with you.
At 2:47 PM + 11/22/07, Alberto Simões wrote:
Is it just me, or SQLite announcements for new releases are not being
sent to this list?
At least I didn't see 3.5.0, 3.5.1 and 3.5.2 announcements. I am aware
of them just because complain about them :)
I saw the 3.5.0 announcement on this list,
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: quinta-feira, 22 de novembro de 2007 12:58
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] SQL error: database disk image is malformed -
SQLITE3.5.1
>
>
> There is a good description of the things that can cause d
Dennis Cote schrieb:
> Thomas Damme wrote:
>> We set "page_size" and "cache_size" both at 8KB because it had the best
>> performance on the device.
>>
> Do you have 64 MB of ram to dedicate to sqlite for its cache? That's
> what you are telling it by setting the cache to 8K pages of 8K each.
No
Thomas Damme wrote:
We set "page_size" and "cache_size" both at 8KB because it had the best
performance on the device.
Do you have 64 MB of ram to dedicate to sqlite for its cache? That's
what you are telling it by setting the cache to 8K pages of 8K each.
Dennis Cote
Oh, maybe I should also tell you this:
We set "page_size" and "cache_size" both at 8KB because it had the best
performance on the device.
Thomas Damme schrieb:
> Hello Folks,
>
> we are running a SQLite-Database(version 3.3.5) on a
> WinCE-device(version 4.2). The database is about 90 MB and res
Hello Folks,
we are running a SQLite-Database(version 3.3.5) on a
WinCE-device(version 4.2). The database is about 90 MB and resides on a
USB-Stick. The database itself contains of about 500 records with BLOBs
from 1KB to 100 KB.
When we are running an "PRAGMA integrity_check" the device stops an
Salles, Joaquim Campos wrote:
Now running the command "PRAGMA integrity_check":
sqlite> PRAGMA integrity_check;
*** in database main ***
Main freelist: 138691677 of 4 pages missing from overflow list starting
at 2972
On tree page 322 cell 0: 3 of 4 pages missing from overflow list
starting at 2
Hi
Is it just me, or SQLite announcements for new releases are not being
sent to this list?
At least I didn't see 3.5.0, 3.5.1 and 3.5.2 announcements. I am aware
of them just because complain about them :)
Cheers
ambs
--
Alberto Simões
--
Hi,
I am not clear on when this flag must be enabled.
SQLITE_THREAD_OVERRIDE_LOCK
What are the implications of enabling this.
Thanks,
Kiran
***
This e-mail and attachments contain
I'm using SQLITE 3.5.1 - in Linux, Had Red 7.1, with a single thread
application - and 2 different programs accessing the same database. I am
getting the following message:
SQL error: database disk image is malformed.
I copy the database to windows and run with sqlite and also get the same
message
Thanks
On Nov 22, 2007 6:35 PM, Dennis Povshedny <[EMAIL PROTECTED]> wrote:
> Hi!
>
> Place the limit clause at the end.
>
> select * from databaseentry where Sub="BarsandPubs" order by Button_Name
> limit 5;
>
> Regards,
> Dennis
>
>
> Xeepe Phone Solution Team
> http://en.xeepe.com
> mailto:[EMA
Hi!
Place the limit clause at the end.
select * from databaseentry where Sub="BarsandPubs" order by Button_Name
limit 5;
Regards,
Dennis
Xeepe Phone Solution Team
http://en.xeepe.com
mailto:[EMAIL PROTECTED]
sip:[EMAIL PROTECTED]
-Original Message-
From: nishit sharma [mailto:[EMAIL
After making command i m getting this error
select * from databaseentry where Sub="BarsandPubs" limit 5 order by
Button_Name;
SQL error: near "order": syntax error
can anybody help
regards
Nishit
-
To unsubscribe, send
Hi Vincent,
On 11/21/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote:
> I have a primary key that auto increments and has apparently
> overlapped back on to itself.
>
> INSERT into mytable(id,name) values(NULL,'test');
>
> .. is giving me "primary key must be unique" errors.
>
> How can I reset the
20 matches
Mail list logo