Re: [sqlite] Lite Network wrapper
Hi - looks great. Do you have a plan to share also the source code of server ? Regards Radu Lodina On 11/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > This is a wrapper for SQLite that allows multiple connections accross a > network to a single threaded SQLIte server (all clients are serviced on > the same connection). It also adds a simple security layer. > > It was designed for general purpose db use and IPC for > embedded/automation systems, allthougth the performance suprised me! I > expected latency to drop when running large queries, as all other > clients must wait for completion before they can start executing. In > order to improve that I buffered the result sets so they can be dumped > quickly out of the way, and SQLite can pump them out very quickly :-) > > There is a C client source which is similar to the > sqlite_execute/callback interface. > > There is also a VB example, but it is not much good :-) > > Windows and Linux binaries statically linked to SQLite 3 are available, > they should run without 'extra' libraries. > > The underlying protocol is a very simple TCP/IP based system, not RPC's. > It allows clients to be easily implemented into anything with sockets, > such as application scripting languages for example. > > More info and downloads: > > http://users.iol.it/irwin > > > > >
[sqlite] How to speed up create index on temp database?
Hello: I run sqlite in embedded system which use nand flash. So I have to reduce write count. Save index in master database will cause much write. I try to dynamic create index on temp database. But the speed is not very well. example: create table employee (id int primary key not null, name); insert 1 record to table; create index temp.idx_name on employee (name); create index will use 24.519761 sec with gprof, I see most time was used in sqlite3BtreeInsert, which called 10001 times. Anyone can give me suggestion to improve the speed? CPU: 96MHz mips32 Memory: 16M File System: tmpfs (so all run in memory) SQLite: 3.2.7
Re: [sqlite] Compiling SQLite and MAX_ATTACHED databases
> #define MAX_ATTACHED 10 > > Is this a per-process limit, or a per-sqlite3 handle limit? It's per-handle. Also, if you haven't found it already, this page has some of the compilation options you can set: http://www.sqlite.org/compile.html __ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com
Re: [sqlite] Lite Network wrapper
[EMAIL PROTECTED] wrote: This is a wrapper for SQLite that allows multiple connections accross a network to a single threaded SQLIte server (all clients are serviced on the same connection). It also adds a simple security layer. Very cool, wish I hade more time to evaluate it :( Interested in the protocol, it looks simple eniugh to integrate into a webapp. -- Lindsay
[sqlite] Lite Network wrapper
This is a wrapper for SQLite that allows multiple connections accross a network to a single threaded SQLIte server (all clients are serviced on the same connection). It also adds a simple security layer. It was designed for general purpose db use and IPC for embedded/automation systems, allthougth the performance suprised me! I expected latency to drop when running large queries, as all other clients must wait for completion before they can start executing. In order to improve that I buffered the result sets so they can be dumped quickly out of the way, and SQLite can pump them out very quickly :-) There is a C client source which is similar to the sqlite_execute/callback interface. There is also a VB example, but it is not much good :-) Windows and Linux binaries statically linked to SQLite 3 are available, they should run without 'extra' libraries. The underlying protocol is a very simple TCP/IP based system, not RPC's. It allows clients to be easily implemented into anything with sockets, such as application scripting languages for example. More info and downloads: http://users.iol.it/irwin
Re: [sqlite] Book recommendation
El Jueves, 10 de Noviembre de 2005 18:44, escribió: (...) > > I do not think that's necessary on my part... using version 7... > Programming Ruby > The Pragmatic Programmers’ Guide > Second Edition > http://www.amazon.com/gp/product/0974514055/103-2642709-1351861?v=glance >=283155=glance > > 800+ pages, all functions work -- no issues found. (...) > nor with any of dozens of other pdf's that i've downloaded/read/deleted.. > Have you tried the sqlite book with version 7? I can read PDF files with acroread 7. No problem there. It's ebooks, and in particular, the SQLite ebook I bought from Amazon, that I'm having problems with. From Adobe's web site: "Does the Acrobat eBook Reader run on Linux? We do not currently plan to develop a version for the Linux platform, but we may in the future if that platform becomes more widely used." Regards. -- Alfredo J. Cole Grupo ACyC
Re: [sqlite] Book recommendation
I picked up a copy and it does cover the version 2 API. I'm still working my way through the concepts part, so I'll see what the API part is like in a bit. Joe Dan Kennedy wrote: I'm 99% certain this book covers the sqlite v2 C/C++ API. Which is similar, but not exactly the same as v3 (the current). The other APIs it covers, TCL and PHP, I think are still pretty much the same. That said the book is pretty readable. --- Joe Halpin <[EMAIL PROTECTED]> wrote: I'm looking for a good tutorial (online or paper) to help me get the concepts behind using the C/C++ API. Could anyone recommend the book by Chris Newman "SQLite: A practical guide to using, administering and programming the database bundled with PHP5"? I'm looking primarily to use the API rather than the command line tool. Thanks Joe __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com
Re: [sqlite] Book recommendation
Reid Thompson wrote: Alfredo Cole wrote: El Miércoles, 9 de Noviembre de 2005 14:21, Joe Halpin escribió: > I'm looking for a good tutorial (online or paper) to help me get the > concepts behind using the C/C++ API. Could anyone recommend the book by > Chris Newman "SQLite: A practical guide to using, administering and > programming the database bundled with PHP5"? > > I'm looking primarily to use the API rather than the command line tool. > > Thanks > > Joe It's a good book. Get the paperback edition, unless you are using Windows and want to save money. There is no Acrobat reader for ebooks on Linux. Regards. Adobe does provide Acrobat Reader for LINUX. there's also xpdf. and google may provide others
Re: [sqlite] Book recommendation
El Jueves, 10 de Noviembre de 2005 11:33, escribió: > Alfredo Cole wrote: > > El Miércoles, 9 de Noviembre de 2005 14:21, Joe Halpin escribió: > > > I'm looking for a good tutorial (online or paper) to help me get the > > > concepts behind using the C/C++ API. Could anyone recommend the book > > > by Chris Newman "SQLite: A practical guide to using, administering > > > and programming the database bundled with PHP5"? > > > > > > I'm looking primarily to use the API rather than the command line > > > tool. > > > > > > Thanks > > > > > > Joe > > > > It's a good book. Get the paperback edition, unless you are using > > Windows and want to save money. There is no Acrobat reader for ebooks on > > Linux. > > > > Regards. > > Adobe does provide Acrobat Reader for LINUX. Sure. But try reading an ebook with it. If things have changed, I'll be glad to try again. Regards. -- Alfredo J. Cole Grupo ACyC