[sqlite] SQLite Performance Issues

2006-10-22 Thread James Mills
Hi Folks, I'm wanting to use SQLite in an embedded web application that will serve as a proxy and possible serve up many connections at once. I'm talking here of high-traffic through this web app. Question is, how will SQLite perform under these kinds of conditions ? I've been speaking to a few

Re: [sqlite] any data access and retrieval engine?

2006-10-22 Thread John Stanton
Clay Dowling wrote: > Sarah wrote: > >>Hi,all >> >>First of all, I want to thank all the guys on this mailing list for their >>warm help. >> >>After 1 more month of work, I finally make SQLite work on my embedded >>environment. SQLite is really great! Many thanks,Drh. >> >>But, due to the

[sqlite] Trouble with ALTER TABLE/ADD

2006-10-22 Thread Isaac Raway
Hi, this is my first question on this list. First, a brief introduction: I've been using sqlite for about the past year or so and so far I'm very happy with it. As far as databases, I have experience with MySQL, SQL Server and of course Access. My language skills include Delphi, PHP, Tcl, and VB

[sqlite] Potential corruption bug in 2.8.17. Patch attached.

2006-10-22 Thread Derrell . Lipman
This was likely a typo. In its current state, it's accessing uninitialized memory. It looks like it's conceivable that an incorrect nextRowid could be later used if the uninitialized value happens to be a small integer (smaller than pC->nextRowid) and the "valid" flag therefore doesn't get set

Re: [sqlite] Re: SQLite GUI app that offers layouts

2006-10-22 Thread Reid Thompson
Jaroslaw Staniek wrote: > T said the following, On 2006-10-18 01:47: > >> There seem to be several SQLite GUI apps around. But I haven't seen >> any that offer building of layouts, ie positioning test frames for >> fields on a page for form data entry or printing. This feature is >> typical of

Re: [sqlite] any data access and retrieval engine?

2006-10-22 Thread Rich Shepard
On Sun, 22 Oct 2006, Uwe Sander wrote: A (very) simple library I have used years ago on embedded systems: http://www.mixsoftware.com/product/database.htm Commercial but inexpensive. Uwe, WOW! I used the MIX tools years ago when I developed my applications in C on DOS. I had the entire

[sqlite] Re: SQLite GUI app that offers layouts

2006-10-22 Thread Jaroslaw Staniek
T said the following, On 2006-10-18 01:47: There seem to be several SQLite GUI apps around. But I haven't seen any that offer building of layouts, ie positioning test frames for fields on a page for form data entry or printing. This feature is typical of proprietary apps such as FileMaker,

Re: [sqlite] any data access and retrieval engine?

2006-10-22 Thread Uwe Sander
Am Sonntag, 22. Oktober 2006 17:10 schrieb Sarah: > Hi,all > > First of all, I want to thank all the guys on this mailing list for their > warm help. > > After 1 more month of work, I finally make SQLite work on my embedded > environment. SQLite is really great! Many thanks,Drh. > > But, due to

Re: [sqlite] any data access and retrieval engine?

2006-10-22 Thread Clay Dowling
Sarah wrote: > Hi,all > > First of all, I want to thank all the guys on this mailing list for their > warm help. > > After 1 more month of work, I finally make SQLite work on my embedded > environment. SQLite is really great! Many thanks,Drh. > > But, due to the extremely heavy hardware

[sqlite] any data access and retrieval engine?

2006-10-22 Thread Sarah
Hi,all First of all, I want to thank all the guys on this mailing list for their warm help. After 1 more month of work, I finally make SQLite work on my embedded environment. SQLite is really great! Many thanks,Drh. But, due to the extremely heavy hardware constraints, I have to give up