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

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

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, > >

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

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

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,

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

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

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

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

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

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

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.

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] 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. ___