Re: [sqlite] Effect of blobs on performance

Hello Dan, On Thu, February 22, 2007 06:08, Dan Kennedy wrote: > * Can include blob operations as part of atomic transactions. me too. Transactions are a major advantage of database blobs. Bye, -- Denis Sbragion InfoTecna Tel: +39 0362 805396, Fax: +39 0362 805

Re: [sqlite] Most appropriate Web based database? (Newbie)

ngines. As a starting point take a look at this: http://builder.com.com/5100-6388_14-1050671.html If the data is critical I would choose PostgreSQL over MySQL. Furthermore there are many useful features of PostgreSQL which are missing in MySQL. BTW, it's your data. :) Bye, -- Denis Sb

Re: [sqlite] Most appropriate Web based database? (Newbie)

ice. Bye, -- Denis Sbragion InfoTecna Tel: +39 0362 805396, Fax: +39 0362 805404 URL: http://www.infotecna.it

RE: [sqlite] Has anyone used sqlite for Pocket PC development?

ble from the development languages we use. Bye, -- Denis Sbragion InfoTecna Tel: +39 0362 805396, Fax: +39 0362 805404 URL: http://www.infotecna.it

Re: [sqlite] performance statistics

a write is in place. Bye, -- Denis Sbragion InfoTecna Tel: +39 0362 805396, Fax: +39 0362 805404 URL: http://www.infotecna.it

Re: [sqlite] performance statistics

eld and is also really useful when something goes wrong (application bug, power outage and so on) because it becomes pretty easy to reprocess all the unprocessed records just by looking at the status. The end results should be pretty similar to the use of temporary tables, but without the need of addition

Re: [sqlite] performance statistics

tail. A lot depends on how much the read and write operations overlap each others. Bye, -- Denis Sbragion InfoTecna Tel: +39 0362 805396, Fax: +39 0362 805404 URL: http://www.infotecna.it

Re: [sqlite] performance statistics

most of the times it is able to cope with both, being at least a bit more than an fopen() replacement. Don't be shy Dr. Hipp! :) Bye, -- Denis Sbragion InfoTecna Tel: +39 0362 805396, Fax: +39 0362 805404 URL: http://www.infotecna.it

[sqlite] OT: Donations?

Hello, might be a bit off topic, but, is there any way to make donations to SQLite? I haven't been able to find informations on the SQLite web site. Bye, -- Denis Sbragion InfoTecna Tel: +39 0362 805396, Fax: +39 0362 805404 URL: http://www.infotecna.it

Re: [sqlite] Best way to get rowID of SELECT DISTINCT

ovide you the first rowid for any Artist in the trax view. Bye, -- Denis Sbragion InfoTecna Tel: +39 0362 805396, Fax: +39 0362 805404 URL: http://www.infotecna.it

Re: [sqlite] New benchmark comparisons

/single thread/no locking typical application. I will never thank enough DRH and the other sqlite developers and contributors for their invaluable work. Bye, -- Denis Sbragion InfoTecna Tel: +39 0362 805396, Fax: +39 0362 805404 URL: http://www.infotecna.it