[sqlite] Re: Which is most appropriate encoding ?

2006-07-14 Thread Hussain KH
Which is the best encoding for Indic Scripts? For Malayalam? If UTF16, then what is the specification for defining a text field? I use Windows XP with Service Pack2; SQLite336, SQLitedll336 and SQLiteODBC68 Regards, Hussain On 6/28/06, RohitPatel <[EMAIL PROTECTED]> wrote: > FWIW, if

[sqlite] SQL Like expr not case sensitive Bug

2006-07-14 Thread Pasquale Imbemba
Hi, is there any news about when this bug (read: http://www.sqlite.org/lang_expr.html) will be fixed? Cheers Pasquale

[sqlite] How to port the SQLite

2006-07-14 Thread Vivek R
Hi , I am New bee to the group and SQLite. Can anyone explain me How to port the SQLite to DVD or Consumer products or any other Embedded Systems. Where I can look for it ? What and all things to be considered while porting. Which is the best version to port to consumer product which runs

[sqlite] Searching for the sqlite3 struct to use with asm

2006-07-14 Thread cusdom
Hi at all, I wanna use sqlite3 with masm but i could not found the sqlite3 struct. I only found typedef struct sqlite3 sqlite3; in sqlit3.h. Can someone help me? Greetings, cusDom

Re: [sqlite] sqlite3_column_text question

2006-07-14 Thread Alexei Alexandrov
Still I can't understand why sqlite3_column_text returns (unsigned char *), but sqlite3_bind_text takes (const char *). What am I missing? On 6/30/06, Alexei Alexandrov <[EMAIL PROTECTED]> wrote: > > Perhaps because it is returning UTF8 and that needs to be unsigned, not signed? > Hmm, why

Re: [sqlite] SQL Like expr not case sensitive Bug

2006-07-14 Thread drh
Pasquale Imbemba <[EMAIL PROTECTED]> wrote: > Hi, > > is there any news about when this bug (read: > http://www.sqlite.org/lang_expr.html) will be fixed? > It isn't a bug. That is the way LIKE works. But you can change the behavior using: PRAGMA case_sensitive_like=ON; -- D. Richard Hipp

Re: [sqlite] Searching for the sqlite3 struct to use with asm

2006-07-14 Thread drh
[EMAIL PROTECTED] wrote: > Hi at all, I wanna use sqlite3 with masm but i could not found the > sqlite3 struct. I only found typedef struct sqlite3 sqlite3; in > sqlit3.h. Can someone help me? struct sqlite3 is an opaque structure. Treat it like a void*. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] sqlite3_column_text question

2006-07-14 Thread drh
"Alexei Alexandrov" <[EMAIL PROTECTED]> wrote: > Still I can't understand why sqlite3_column_text returns (unsigned > char *), but sqlite3_bind_text takes (const char *). What am I > missing? > Why does signed vs. unsigned char matter to you? Perhaps the interface could be more consistent. But

Re: [sqlite] "no such column" problem with multi level sub queries

2006-07-14 Thread Martin Jenkins
No doubt Igor or one of the others will be able to explain *why* your SQL fails but changing line 1 from > 1: SELECT testlog.error, to > 1: SELECT error, works with Python 2.5 using the built-in sqlite (3.3.4) on XP and with Python 2.4 and pysqlite (2.8.16) on Debian Sarge. Martin John

Re: [sqlite] Re: Memory exhaust

2006-07-14 Thread Martin Jenkins
Robert Wallner wrote: Even the smallest sql statement (like PRAGMA temp_store = 1) triggers this behaviour when using sqlite 3.3.x. I forgot to mention that I connect to a :memory: database and then attach 2 database to the connection. I've been using the apsw and pysqlite wrappers for some

[sqlite] Major projects using SQLite

2006-07-14 Thread Jon García de Salazar Bilbao
Hi, Could you give examples of some major software projects using SQLite? Thanks, Jon. - PLEASE NOTE --- This message, along with any attachments, may be confidential or legally privileged. It is intended only

Re: [sqlite] Major projects using SQLite

2006-07-14 Thread Jay Sprenkle
On 7/14/06, Jon García de Salazar Bilbao <[EMAIL PROTECTED]> wrote: Hi, Could you give examples of some major software projects using SQLite? I created an events management website for a local convention. sqlite was used for the storage and management of all the events at the convention.

Re: [sqlite] Major projects using SQLite

2006-07-14 Thread Martin Jenkins
Jon García de Salazar Bilbao wrote: Hi, Could you give examples of some major software projects using SQLite? Thanks, Jon. Solaris 10 - http://blogs.sun.com/roller/page/eric_boutilier/20050405 Martin

RE: [sqlite] Major projects using SQLite

2006-07-14 Thread James Moore
Many, many PHP based sites (Including parts of PHP.net itself IIRC).. http://www.php.net/sqlite - James -Original Message- From: Martin Jenkins [mailto:[EMAIL PROTECTED] Sent: 14 July 2006 15:16 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Major projects using SQLite Jon García

Re: [sqlite] Major projects using SQLite

2006-07-14 Thread Craig Morrison
Jon García de Salazar Bilbao wrote: Hi, Could you give examples of some major software projects using SQLite? Thanks, Jon. FireFox 2.0.. -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/

Re: [sqlite] How to port the SQLite

2006-07-14 Thread Christian Smith
Vivek R uttered: Hi , I am New bee to the group and SQLite. Can anyone explain me How to port the SQLite to DVD or Consumer products or any other Embedded Systems. Where I can look for it ? What and all things to be considered while porting. Which is the best version to port to consumer product

Re: [sqlite] Major projects using SQLite

2006-07-14 Thread G. Roderick Singleton
On Fri, 2006-07-14 at 15:16 +0100, Martin Jenkins wrote: > Jon García de Salazar Bilbao wrote: > > Hi, > > Could you give examples of some major software projects using SQLite? > > Thanks, Jon. > > Solaris 10 - http://blogs.sun.com/roller/page/eric_boutilier/20050405 > > Martin

Re: [sqlite] Major projects using SQLite

2006-07-14 Thread Bill King
Jon García de Salazar Bilbao wrote: Hi, Could you give examples of some major software projects using SQLite? Thanks, Jon. Trolltech's qtopia mobile phone platform is using sqlite for pim, contacts, and document metainfo. http://www.trolltech.com/products/qtopia

Re: [sqlite] Major projects using SQLite

2006-07-14 Thread drh
=?iso-8859-1?Q?Jon_Garc=EDa_de_Salazar_Bilbao?= <[EMAIL PROTECTED]> wrote: > > Could you give examples of some major software projects using SQLite? * Apple OS-X * Solaris 10 * Firefox * Monotone * SymbianOS (used in cellphones) * YUM * America Online (AOL) * PHP * Philips MP3 players * POPFile

AW: [sqlite] Major projects using SQLite

2006-07-14 Thread Michael Ruck
You can add Orb (www.orb.com) to the list. Mike -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 14. Juli 2006 17:04 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Major projects using SQLite

Re: [sqlite] "no such column" problem with multi level sub queries

2006-07-14 Thread John Cruz
Thanks Martin for the quick response. However, that was the original query and that didn't work. I've even tried using alias on that (SELECT error as x. tt.error=x) to no avail. I did tried setting the statement before to tt.error=error and that yields me an output but the value of

Re: [sqlite] Re: Memory exhaust

2006-07-14 Thread Eduardo
At 17:43 13/07/2006, you wrote: Even the smallest sql statement (like PRAGMA temp_store = 1) triggers this behaviour when using sqlite 3.3.x. I forgot to mention that I connect to a :memory: database and then attach 2 database to the connection. Perhaps the 2 database attached are converted to

[sqlite] Re: Memory exhaust

2006-07-14 Thread Robert Wallner
I think I found the problem. I used a version of pysqlite compiled against sqlite3.2.8. When used with the shared library from any sqlite 3.3.x version, every sql operation eats all memory. Thank you all for the help On 7/14/06, Eduardo <[EMAIL PROTECTED]> wrote: At 17:43 13/07/2006, you

[sqlite] how to flush database to disk?

2006-07-14 Thread joe
I've just lost a couple of days' worth of data when my app crashed. (Well, the data wasn't a total loss thanks to backup plans, but the database itself essentially reverted to its state of 2 days ago.) This is despite my app doing a COMMIT after every modification of the DB. It's acting as

Re: [sqlite] how to flush database to disk?

2006-07-14 Thread Will Leshner
On 7/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: It's acting as though all the changes were held in memory, or somehow journaled, and when the crash happened, the changes were all lost or rolled back. What I need is a way to force the database to save its data to disk while my app

Re: [sqlite] how to flush database to disk?

2006-07-14 Thread joe
On Jul 14, 2006, at 22:22 UTC, Will Leshner wrote: > COMMIT should write the data to disk. Did you check errors after the > COMMIT to be sure there wasn't some kind of error? Yes, I checked, no error was ever reported. Also, I very clearly had all my data accessible while the app was running,

Re: [sqlite] how to flush database to disk?

2006-07-14 Thread Kees Nuyt
On Fri, 14 Jul 2006 16:37:49 -0600, you wrote: >On Jul 14, 2006, at 22:22 UTC, Will Leshner wrote: > >> COMMIT should write the data to disk. Did you check errors after the >> COMMIT to be sure there wasn't some kind of error? > >Yes, I checked, no error was ever reported. Also, I very clearly

Re: [sqlite] how to flush database to disk?

2006-07-14 Thread joe
On Jul 14, 2006, at 22:53 UTC, Kees Nuyt wrote: > How many SQL commands are in your typical transaction? One. > Do you start them with a "BEGIN" ? No, I'm using implicit transactions. > If you never do a "BEGIN", every SQL command is > one transaction, and "COMMIT" has no meaning. Yes, I'm

Re: [sqlite] how to flush database to disk?

2006-07-14 Thread Kees Nuyt
On Fri, 14 Jul 2006 16:59:55 -0600, you wrote: >On Jul 14, 2006, at 22:53 UTC, Kees Nuyt wrote: > >> How many SQL commands are in your typical transaction? > >One. > >> Do you start them with a "BEGIN" ? > >No, I'm using implicit transactions. Ok, I see. >> If you never do a "BEGIN", every SQL

Re: Re: [sqlite] how to flush database to disk?

2006-07-14 Thread Will Leshner
On 7/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Yet my observations indicate that the database hadn't written anything to disk in two days (or if it had, it somehow decided to roll back the last two days' worth after the crash). Any insight on that? It really sounds like you've

Re: Re: [sqlite] how to flush database to disk?

2006-07-14 Thread joe
On Jul 15, 2006, at 00:27 UTC, Will Leshner wrote: > Since I happen to know this is being done with REALbasic, are you > calling COMMIT yourself, explicitly, or are you calling the Commit > method? I suppose there could be a bug in the REALbasic plugin that is > somehow preventing a commit from

Re: [sqlite] how to flush database to disk?

2006-07-14 Thread joe
On Jul 14, 2006, at 23:43 UTC, Kees Nuyt wrote: > The syntax descriptions about PRAGMA synchronous= could shed > some light. http://www.sqlite.org/pragma.html#modify > Note: The default for the "synchronous" PRAGMA is version > dependent. That's interesting. What is "the F_FULLFSYNC syncing

Re: [sqlite] Major projects using SQLite

2006-07-14 Thread Jim Dodgen
I am using SQLite for a internal project. I has been under heavy use for over 18 months. It is a CGI application/web service constructed of 31,000 lines of PERL and embedded SQL. It has worked flawlessly. Even upgrades (currently 3.3.5) have been pretty smooth. SQLite rules! thanks to DRH