[sqlite] Re: SQL and SQLite pronounciation?

* Dennis Cote <[EMAIL PROTECTED]> [2007-04-04 22:30]: > I prefer "ess cue el" and "ess cue light" myself. That’s what I say. Regards, -- Aristotle Pagaltzis // - To unsubscribe, send email to

Re: [sqlite] Data integrity in extreme situations

--- [EMAIL PROTECTED] wrote: > It has already been reported that Apple Mail keeps all its metadata > in an SQLite database. (There was quite a stir in the Mac community > a few weeks ago when somebody discovered and blogged that you could > substantially increase the speed of Apple Mail by

Re: [sqlite] Default sqlite memory management policy

"Rich Rattanni" <[EMAIL PROTECTED]> wrote: > On 4/3/07, Rich Rattanni <[EMAIL PROTECTED]> wrote: > > All: > >I was wondering exactly how SQLite handles freeing memory used > > from the heap when compiled without SQLITE_ENABLE_MEMORY_MANAGEMENT? > > > >Will absolutely no memory be freed, or

Re: [sqlite] Re: Default sqlite memory management policy

On Wed, 2007-04-04 at 23:36 -0400, Rich Rattanni wrote: > On 4/3/07, Rich Rattanni <[EMAIL PROTECTED]> wrote: > > All: > >I was wondering exactly how SQLite handles freeing memory used > > from the heap when compiled without SQLITE_ENABLE_MEMORY_MANAGEMENT? > > > >Will absolutely no memory

[sqlite] Re: Default sqlite memory management policy

On 4/3/07, Rich Rattanni <[EMAIL PROTECTED]> wrote: All: I was wondering exactly how SQLite handles freeing memory used from the heap when compiled without SQLITE_ENABLE_MEMORY_MANAGEMENT? Will absolutely no memory be freed, or is there some default memory management scheme used? Let

Re: [sqlite] Data integrity in extreme situations

Yves Goergen <[EMAIL PROTECTED]> wrote: > Hi, > > I'm intending to use the SQLite database in a desktop e-mail > application. Since most e-mails are quite valuable to me, I'd like to > know if SQLite databases can get corrupted during normal use and > exceptional situations like a sudden

Re: [sqlite] Math functions

Please see http://sqlite.org/contrib under extension-functions.tgz. On 4/4/07, Nathan Biggs <[EMAIL PROTECTED]> wrote: Does anyone know if there is a floor function in sqlite, or of a way to implement it.

[sqlite] Re: Math functions

Nathan Biggs <[EMAIL PROTECTED]> wrote: Does anyone know if there is a floor function in sqlite, or of a way to implement it. cast(expr as integer) truncates towards zero, in case it helps. Igor Tandetnik - To

Re: [sqlite] SQL and SQLite pronounciation?

On Wednesday, April 04, 2007 Martin Pelletier wrote: > I use a twist on the various versions listed so far: "es cue el-ait". > Hearing "sequel" for SQL always makes me cringe. Yeah. In some circles, "sequel" is reserved for the original SEQUEL query language were first published in 1974 by Don

Re: [sqlite] Re: SQL help

Igor, Amazing. Thanks very much for your help. You get credit in my code comments :-)) -Clark - Original Message From: Igor Tandetnik <[EMAIL PROTECTED]> To: SQLite Sent: Tuesday, April 3, 2007 12:20:57 PM Subject: [sqlite] Re: SQL help Clark Christensen

Re: [sqlite] SQL and SQLite pronounciation?

Personally, I use "sequel" and "sequel-light". I think I remember from DRH's Google presentation video he uses "ess cue el ite" for his product. -Clark - Original Message From: Dennis Cote <[EMAIL PROTECTED]> To: sqlite-users Sent: Wednesday, April 4, 2007

Re: [sqlite] SQL and SQLite pronounciation?

I use a twist on the various versions listed so far: "es cue el-ait". Hearing "sequel" for SQL always makes me cringe. Dennis Cote wrote: I have a simple question; how do you pronounce SQL and SQLite? -- Martin Pelletier Informatique / Software Development Infodev Electronic Designers

RE: [sqlite] SQL and SQLite pronounciation?

re: "S. Q. Lite... that is my pronunciation..." And calling it "squirrelite" is simply a tongue-in-cheek affectionate affectation ;-) - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] SQL and SQLite pronounciation?

S. Q. Lite... that is my pronunciation and as I read in a book that is its pronunciation On 04/04/07, Alberto Simões <[EMAIL PROTECTED]> wrote: On 4/4/07, Joel Cochran <[EMAIL PROTECTED]> wrote: > I prefer the "ess cue ell" version. And I can never remmeber that there is > only one "el", so I

[sqlite] sqlite server

I've revived the sqlite server demo at http://www.it77.de/sqlite/sqlite.htm and updated the API to sqlite 3. This project defines a very simple sqlite server which operates local sqlite databases, and a simple client which links with a lightweight library containing a plug-compatible subset

Re: [sqlite] Math functions

yes you can implement math functions with user defined functions by the sqlite3_create_function. sqlite.org is your freind :) 2007/4/4, Nathan Biggs <[EMAIL PROTECTED]>: Does anyone know if there is a floor function in sqlite, or of a way to implement it.

[sqlite] Math functions

Does anyone know if there is a floor function in sqlite, or of a way to implement it.

Re: [sqlite] SQL and SQLite pronounciation?

On 4/4/07, Joel Cochran <[EMAIL PROTECTED]> wrote: I prefer the "ess cue ell" version. And I can never remmeber that there is only one "el", so I end up saying "ess cue ell light" even though I know its wrong. Join the club, Joel. I do the same, myself. With the only difference that I

Re: [sqlite] SQL and SQLite pronounciation?

I prefer the "ess cue ell" version. And I can never remmeber that there is only one "el", so I end up saying "ess cue ell light" even though I know its wrong. -- Joel Cochran On 4/4/07, Dennis Cote <[EMAIL PROTECTED]> wrote: Hi All, I have a simple question; how do you pronounce SQL and

Re: [sqlite] SQL and SQLite pronounciation?

On 4/4/07, Dennis Cote <[EMAIL PROTECTED]> wrote: Hi All, I have a simple question; how do you pronounce SQL and SQLite? See-quell See-que-lite -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial

[sqlite] SQL and SQLite pronounciation?

Hi All, I have a simple question; how do you pronounce SQL and SQLite? I have heard some people pronounce SQL like "sequel", others like "squeal", and others like three words "ess cue el". Which do you prefer? How about SQLite? Is it "ess cue light" or something else like "sequel light"?

Re: [sqlite] Data integrity in extreme situations

On 4/4/07, Yves Goergen <[EMAIL PROTECTED]> wrote: Hi, I'm intending to use the SQLite database in a desktop e-mail application. Since most e-mails are quite valuable to me, I'd like to know if SQLite databases can get corrupted during normal use and exceptional situations like a sudden

Re: [sqlite] What query should I use?

try the DISTINCT keyword ? - Original Message - From: "erw2" <[EMAIL PROTECTED]> To: Sent: Wednesday, April 04, 2007 4:14 PM Subject: [sqlite] What query should I use? Hi, I have a table with a following data: IdText1 Text2 Text3 Text4

[sqlite] Data integrity in extreme situations

Hi, I'm intending to use the SQLite database in a desktop e-mail application. Since most e-mails are quite valuable to me, I'd like to know if SQLite databases can get corrupted during normal use and exceptional situations like a sudden application/OS crash, power failure or access blocking

[sqlite] Re: What query should I use?

erw2 <[EMAIL PROTECTED]> wrote: I have a table with a following data: IdText1 Text2 Text3 Text4 --- 11001 11 test03 test13 21002 11 test01 test11 31003 12 test04 test12 41004 12 test02 test34 5

[sqlite] What query should I use?

Hi, I have a table with a following data: IdText1 Text2 Text3 Text4 --- 11001 11 test03 test13 21002 11 test01 test11 31003 12 test04 test12 41004 12 test02 test34 51004 12 test06

Re: [sqlite] Newbee Question

You have to link against sqlite's shared lib, e.g. in linux $ gcc -L/path/to/sqlite/stuffs -I/path/to/sqlite/stuffs -lsqlite prog.c (the 2nd is a capital i, the 3rd a small L) Cheers, M. Manese On 4/4/07, nshaw <[EMAIL PROTECTED]> wrote: I upgraded from 3.3.1.3 to 3.3.1.4. Up till now,