[sqlite] strip debug info, add it to README file?

2006-02-18 Thread Jose Da Silva
Hi sqlite list, By default, linux gcc does not appear to remove information and therefore final binaries tend to be larger than they need to be if you use stable versions of compiled binaries. Many people don't tend to realize this and therefore compile files larger than necessary if their

[sqlite] sqlite, odbc, any gotchas?

2006-02-19 Thread Jose Da Silva
If read a bit already and see limitations and benefits in SQlite. Our office still wants to use the GUI present in MS-Access. I like the simplicity of maintaining SQLite plus it's rollback features etc. Later, there are aspirations for a webbrowser interface to same database. Anyone have

Re: [sqlite] Older sources

2006-02-20 Thread Jose Da Silva
On February 19, 2006 06:45 pm, Manfred Bergmann wrote: > Hi there. > I would need the sources of an older version (3.1.2) of SQLite. > Are they still available for download? If nobody has it, go to google and search for these 3 words: sqlite 3.1.2 rpm or sqlite 3.1.2 tar.gz The response is many

Re: [sqlite] sqlite, odbc, any gotchas?

2006-02-21 Thread Jose Da Silva
top > of the database. Access does tend to trash its database files if used > by multiple users on a network. If you connect to sqlite files via > odbc they should be ok though. Backup your mdb file to be safe! > > On 2/19/06, Jose Da Silva <[EMAIL PROTECTED]> wrote: > >

Re: [sqlite] sqlite, odbc, any gotchas?

2006-02-21 Thread Jose Da Silva
On February 21, 2006 12:48 pm, Jay Sprenkle wrote: > Sqlite has been very fast for me. If you need raw blazing Well, sqlite is definitely fast in relation to other sqls, but every sql has overhead, and they all can't match direct access of a flattish-file-format by a computer doing it's own

Re: [sqlite] Can sqlite manage a ramdisk file and a nvram file at same time.

2006-02-21 Thread Jose Da Silva
On February 21, 2006 05:43 pm, Jiao wrote: > all > I 'm designing an embedded system,Our system have limited flash,there > are much datas required to manage, but not all the data required to > save into flash,just leave them in ramdisk. so I intend to design two > db file ,one in flash and another

Re: [sqlite] Strange execution times

2006-02-22 Thread Jose Da Silva
On February 22, 2006 05:59 am, Adrian Ho wrote: > On Wed, Feb 22, 2006 at 11:11:45AM +0200, Ulrich Sch?bel wrote: > > I tried your script and got, after a slight modification, quite > > consistent results. When I tried it as is, I got slightly varying > > time results with a peak in the 50 to 100

Re: [sqlite] Re: what is on my computer

2006-02-27 Thread Jose Da Silva
On February 27, 2006 06:29 pm, [EMAIL PROTECTED] wrote: > [EMAIL PROTECTED] wrote: > > look i have over 600 temp file i cannot remove or delete why is > > this. they all start with sqlite_ then there is another over 600 > > files with 3k memory, but the sqlite_ files have ok memory > > I'm

Re: [sqlite] SQLite memory leak on Windows CE

2006-03-14 Thread Jose Da Silva
On March 14, 2006 12:03 pm, [EMAIL PROTECTED] wrote: > Hi all, > I am having real problems with SQLite on Windows CE (.NET 4.1 and > Pocket PC 2003). I have tried everything and it seems that there is a > memory leak with SQLite on Windows CE. I have test it with SQLite > versions 3.2.2 and 3.3.4

Re: [sqlite] RE:Re: [sqlite] SQLite memory leak on Windows CE

2006-03-15 Thread Jose Da Silva
On March 14, 2006 01:49 pm, [EMAIL PROTECTED] wrote: > Hello again, > Thank for your answers: > first of all thank you who pointed that i should use a close(db) at > line 17 and call sqlite3_free_table(result) even if there was an > error, but these solutions didnĀ“t solve my problem (the

Re: [sqlite] planning to use sqlite for a project involving huge data

2006-05-03 Thread Jose Da Silva
On May 2, 2006 09:42 pm, E Tse wrote: > Hi all, > I am planing to use sqlite for a project involving huge data. The > planned sqlite file (which will contain a single table) will grow to > more than 4g in size. Has anyone try that before and what problems > have you encountered? Some operating