[sqlite] SQLite Performance Issues

[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 of the Trac
developers, and they inform me that SQLite uses a global
writer meaning that only a single thread can write at
any one point in time. This would explain why trac-hacks.org
is so slow at times to load up.

Thoughts/Comments ?

(btw) I really don't want to be using a server-client
rdbms such as MySQL or Postgresql because of the small
overheads in having a server.

cheers
James

-- 
--
-"Problems are Solved by Method"
-
- James Mills <[EMAIL PROTECTED]>
- HomePage: http://shortcircuit.net.au/~prologic/
- IRC: irc://shortcircuit.net.au#se

Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[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 extremely heavy hardware constraints, I have to give up 
>>SQLite finally. 
>>
>>So I'm trying to find a much simpler data access and retrieval engine. 
>>
>>Could anyone give me some help on this issue?(some guidance on how to make a 
>>DARE or is there any open-source one available?) 
>>
>>thanks in advance. 
> 
> 
> The Berkeley DB engine and it's related engines might be suitable for
> your situation.  They don't give relational access, but they do give
> fast key=>value retreival and that might be suitable.  The SleepyCat DB
> engine from SleepyCat Software is probably the best, but for a
> commercial application the licensing fees mean that you have to be well
> funded and expect a good return on the product.
> 
> Clay Dowling
Berkely DB is still quite bloated.  What do you require for data access?
 For an embedded system you might find something which matches your
needs very well and has a tiny footprint.

I can give you some B* Tree code which is suitable for a high
performance simple and lightweight embedded application or some AVL tree
code which would suit a simpler smaller scale memory resident embedded
data access application.  You would have to adapt it to your
application, but could expect to get your database access in 20K or less
of executable image.  Of course you have no SQL.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Trouble with ALTER TABLE/ADD

[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
(top 4).

Okay, my question...I have this table in the first version of an application
I have created:

CREATE TABLE topic(id integer primary key, title string, namespace integer,
content blob, meta blob, x integer, y integer, w integer, h integer);

In order to upgrade existing databases I run various commands to add the
needed tables and store the current version of the database

ALTER TABLE topic ADD COLUMN type_id integer;

This works fine when I run it on the sqlite3 command line, but fails in the
Delphi units. Any thoughts? Has anyone ahd trouble running ALTER TABLE from
the Delphi bindings?

--
Isaac Raway
Entia non sunt multiplicanda praeter necessitatem.

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

[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 to false.

--- vdbe.c~ 2005-12-19 12:42:25.0 -0500
+++ vdbe.c  2006-10-22 16:32:45.0 -0400
@@ -2937,7 +2937,7 @@
   if( pOp->p2 & OPFLAG_NCHANGE ) db->nChange++;
   if( pOp->p2 & OPFLAG_LASTROWID ) db->lastRowid = pNos->i;
   if( pOp->p2 & OPFLAG_CSCHANGE ) db->csChange++;
-  if( pC->nextRowidValid && pTos->i>=pC->nextRowid ){
+  if( pC->nextRowidValid && pNos->i>=pC->nextRowid ){
 pC->nextRowidValid = 0;
   }
 }

Cheers,

Derrell

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[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 proprietary apps such as FileMaker, AppleWorks, 4D etc.
>>
>> Anyone know of a GUI app that offers layouts (ie form creation), 
>> especially on a Mac (but even other platforms)?
>>
>> Is there a conventional way to store the layout information in the 
>> SQLite database itself, so it can be moved from one SQLite GUI app to 
>> another, and retain compatible forms?
> 
> This is one of Kexi features.
> 
> http://kexi-project.org
> http://en.wikipedia.org/wiki/Kexi
> 
> It works on Mac too (installable using Fink).
> 
you can also see [gnome-db,mergeant] and glom.  Gnome-DB/mergeant
supports sqlite -- I'm not sure about glom.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[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 collection they put out (at half the current
price), and the authors provided outstanding support. The ISAM provided in
this database toolkit was well designed and implemented.

  I had no idea the company was still in business since I migrated from DOS
to linux almost a decade ago.

Rich

--
Richard B. Shepard, Ph.D.   |The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)|Accelerator
 Voice: 503-667-4517  Fax: 503-667-8863

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Re: SQLite GUI app that offers layouts

[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, AppleWorks, 4D etc.


Anyone know of a GUI app that offers layouts (ie form creation),  
especially on a Mac (but even other platforms)?


Is there a conventional way to store the layout information in the  
SQLite database itself, so it can be moved from one SQLite GUI app to  
another, and retain compatible forms?


This is one of Kexi features.

http://kexi-project.org
http://en.wikipedia.org/wiki/Kexi

It works on Mac too (installable using Fink).

--
regards / pozdrawiam, Jaroslaw Staniek
 Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
 Kexi & KOffice: http://www.kexi-project.org, http://www.koffice.org
 KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[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 the extremely heavy hardware constraints, I have to give up
> SQLite finally.
>
> So I'm trying to find a much simpler data access and retrieval engine.
>
> Could anyone give me some help on this issue?(some guidance on how to
> make a DARE or is there any open-source one available?)
>
> thanks in advance.

A (very) simple library I have used years ago on embedded systems:
http://www.mixsoftware.com/product/database.htm
Commercial but inexpensive.

HTH
- Uwe

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[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 constraints, I have to give up 
> SQLite finally. 
> 
> So I'm trying to find a much simpler data access and retrieval engine. 
> 
> Could anyone give me some help on this issue?(some guidance on how to make a 
> DARE or is there any open-source one available?) 
> 
> thanks in advance. 

The Berkeley DB engine and it's related engines might be suitable for
your situation.  They don't give relational access, but they do give
fast key=>value retreival and that might be suitable.  The SleepyCat DB
engine from SleepyCat Software is probably the best, but for a
commercial application the licensing fees mean that you have to be well
funded and expect a good return on the product.

Clay Dowling
-- 
CeaMuS, Simple Content Management
http://www.ceamus.com

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] any data access and retrieval engine?

[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 SQLite 
finally. 

So I'm trying to find a much simpler data access and retrieval engine. 

Could anyone give me some help on this issue?(some guidance on how to make a 
DARE or is there any open-source one available?) 

thanks in advance.