Re: [sqlite] About ticket #3452

On Fri, Oct 24, 2008 at 03:10:30PM -0700, Roger Binns wrote: > Nicolas Williams wrote: > > I've not run Evolution with SQLite3, so I don't know if it shares the > > cache. I'll ask the user in question to check. > > You'll need to ask the developer :-) According to the user Evolution has been fi

Re: [sqlite] How to generate a scheme

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I'm still feeling my way around sqlite. One thing that would be handy would > be the ability to generate a scheme (schema?) for a particular database, That is something you have to do by hand. The formal process for doing so is known as normalizat

Re: [sqlite] About ticket #3452

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Nicolas Williams wrote: > I've not run Evolution with SQLite3, so I don't know if it shares the > cache. I'll ask the user in question to check. You'll need to ask the developer :-) http://sqlite.org/c3ref/enable_shared_cache.html I don't know if th

Re: [sqlite] SQLITE_CORE use for ??

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 MikeW wrote: > Wondering if there was a way to prevent the FTS3 source getting built, > I looked at the source to find that it would *not* get built if > SQLITE_CORE was defined. SQLITE_ENABLE_FTS3 is what is supposed to cause FTS3 to be included. ie

Re: [sqlite] How to limit the size of the database files?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tobias Müller wrote: >> For an even smaller footprint change, you can write your own >> xFileControl routine and then use sqlite3_file_control to >> query/set values. > > By "write your own xFileControl routine" did you mean that we should > change th

Re: [sqlite] About ticket #3452

On Thu, Oct 23, 2008 at 04:04:58PM -0700, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Nicolas Williams wrote: > > (FYI, Evolution has/had a separate performance problem in that it opens > > a SQLite3 DB handle for the same DB every time you open a mail folder, > > wher

Re: [sqlite] Formatting to

On Fri, 24 Oct 2008 08:24:16 -0400 "Igor Tandetnik" <[EMAIL PROTECTED]> dijo: > > Yes - whatever happened to Title Case ? > > Still wouldn't work so well with, say, "The Definitive Guide To Sqlite" Yes, Igor has a very good point. The problem is the stupidity of English typesetting rules. Many

Re: [sqlite] How to bind a tinyint so that actually uses 1 byte?

> As long as your values are within the range of -128 to +127, your > integers will only take one byte of storage (plus common overhead). > There's an extra byte of meta data for each column value in each row due to manifest typing, so an int will take at least 2 bytes of storage per colu

Re: [sqlite] SQLite 3.6.4 link problem on WindowsCE

On Oct 23, 2008, at 4:34 PM, Shane Harrelson shane-at-sqlite.org | sqlite| wrote: > This was (hopefully) corrected by check-in [5837] yesterday. > Confirmation that this fix works for you would be appreciated. I pulled the tip from CVS, ran configure and make from cygwin then copied sqlite3.

Re: [sqlite] How to generate a scheme

I'm trying to do the exact same thing via a C++ app right now. I don't know if a "schema" can be create other way than via the command line .s . But it may help you to know that there's a table called sqlite_master that contain infos on each tables and indexes of your database. I'm currently itera

Re: [sqlite] SQLITE_CORE use for ??

D. Richard Hipp <[EMAIL PROTECTED]> writes: > > A developer using SQLite in their product should never have to mess > with SQLITE_CORE. The SQLITE_CORE macro is for internal use only. If > you find a case where you think you have to set SQLITE_CORE manually > in order to compile SQLite, tha

Re: [sqlite] Formatting to

"MikeW" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Igor Tandetnik <[EMAIL PROTECTED]> writes: > >> >> Are you sure you would be happy with "Uncle tom's cabin", or >> "Adventures of tom sawyer", or "Oliver twist" ? >> > > Yes - whatever happened to Title Case ? Still wouldn't wor

Re: [sqlite] Formatting to

Igor Tandetnik <[EMAIL PROTECTED]> writes: > > Are you sure you would be happy with "Uncle tom's cabin", or "Adventures > of tom sawyer", or "Oliver twist" ? > > Igor Tandetnik > Yes - whatever happened to Title Case ? MikeW ___ sqlite-users mail

Re: [sqlite] How to bind a tinyint so that actually uses 1 byte?

On Fri, Oct 24, 2008 at 02:49:14AM -0700, dbikash scratched on the wall: > > Hi, > > I am using tinyint in my schema, but while doing paramterized insertion, I > find that there is no specific bind API to insert a tinyint. So I used int > sqlite3_bind_int() instead. > > However, the size of my d

Re: [sqlite] Formatting to "Sentence case"?

"Gilles Ganault" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > A column holds book titles which are all in capital letters ("MY BOOK > TITLE"), and I'd like to reformat them as "My book title". Are you sure you would be happy with "Uncle tom's cabin", or "Adventures of tom sawyer"

Re: [sqlite] How to limit the size of the database files?

Roger Binns wrote: > You can write your own VFS that gives an I/O error on writes that make > the file larger than you want. This won't be much code since you can > just point to existing VFS routines (eg unix/winTruncate, unix/winLock > etc) for most of the code. After a first look, this really

Re: [sqlite] How to bind a tinyint so that actually uses 1 byte?

On Fri, Oct 24, 2008 at 2:49 AM, dbikash <[EMAIL PROTECTED]> wrote: > > Hi, > > I am using tinyint in my schema, but while doing paramterized insertion, I > find that there is no specific bind API to insert a tinyint. So I used int > sqlite3_bind_int() instead. > > However, the size of my database

[sqlite] How to bind a tinyint so that actually uses 1 byte?

Hi, I am using tinyint in my schema, but while doing paramterized insertion, I find that there is no specific bind API to insert a tinyint. So I used int sqlite3_bind_int() instead. However, the size of my database suggests that SQLite might actually be using 4 bytes instead of 1. Is it? How can

Re: [sqlite] Performance Problems with joining and subqueries

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Da Martian wrote: > Regarding using "Case" I didnt know sqlite supported this. In fact looking > at core functions on the web there isnt any mention of a case statement, nor > in aggregate functions. Case is not a function but rather an expression. Y

Re: [sqlite] Performance Problems with joining and subqueries

Hi I do appologise. In my hast, I did copy bits of a larger query. The queries are correct they just have extra bits around the edges. I will post the corrections below. Regarding using "Case" I didnt know sqlite supported this. In fact looking at core functions on the web there isnt any mention

Re: [sqlite] Formatting to "Sentence case"?

Perhaps by doing an UPDATE with: set booktitle = upper(substr(booktitle,1,1)) || lower(substr(booktitle,2)) Regards, -Toby >Hello > >A column holds book titles which are all in capital letters ("MY BOOK >TITLE"), and I'd like to reformat them as "My book title". > >Is there a function in SQLite

[sqlite] Formatting to "Sentence case"?

Hello A column holds book titles which are all in capital letters ("MY BOOK TITLE"), and I'd like to reformat them as "My book title". Is there a function in SQLite that does this, or should I use some external language to do this? Thank you. ___ sqli