[sqlite] any data access and retrieval engine?
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.
Re: [sqlite] any data access and retrieval engine?
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] -
Re: [sqlite] any data access and retrieval engine?
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] -
[sqlite] Re: SQLite GUI app that offers layouts
TB 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?
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 http://www.appl-ecosys.com Voice: 503-667-4517 Fax: 503-667-8863 - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Re: SQLite GUI app that offers layouts
Jaroslaw Staniek wrote: TB 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] -
[sqlite] Potential corruption bug in 2.8.17. Patch attached.
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] -
[sqlite] Trouble with ALTER TABLE/ADD
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.
Re: [sqlite] any data access and retrieval engine?
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] SQLite Performance Issues
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] -