Re: [sqlite] Sporadic freezes of sqlite

2009-04-26 Thread Pavel Ivanov
I'm using sqlite as an embedded engine in the application acting like server for other applications. Pavel On Sun, Apr 26, 2009 at 4:17 PM, John Stanton wrote: > Sqlite does not use a server.  It is embedded in the application. > > Pavel Ivanov wrote: >> Unfortunately these two options are not f

Re: [sqlite] Sporadic freezes of sqlite

2009-04-26 Thread John Stanton
Sqlite does not use a server. It is embedded in the application. Pavel Ivanov wrote: > Unfortunately these two options are not for me. > I'm not in control of servers hardware, so my application should work > on the given servers and nobody will adjust them for my application. > And about first o

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

2009-04-26 Thread John Stanton
P Kishor wrote: > On Fri, Apr 24, 2009 at 5:27 AM, John Stanton wrote: > >> Sqlte provides COMMIT and ROLLBACK unlike Berkeley. If you can get by >> without the advanced features of Sqlite, then use Berkely and take >> advantage of its simplicity and faster execution. >> > > BDB does supp

Re: [sqlite] Newbie question about using SQLite with Windows Forms application (VS 2005 C++)

2009-04-26 Thread Wiktor Karczewski
Vinnie pisze: >> From: wiktor >> Subject: [sqlite] Newbie question about using SQLite with >> Windows Forms application (VS 2005 C++) >> I'm trying to build a win form application that uses >> sqlite. I have problems with making it work. I would like >> to have the sqlite source included in my pr

Re: [sqlite] corrupt database recovery

2009-04-26 Thread Jim Dodgen
Cool solution. On Sun, Apr 26, 2009 at 6:39 AM, Jim Wilcoxson wrote: > You could do a binary search to find the highest accessible rowid: > >    select rowid where rowid = 2147483647 (fails) >    select rowid where rowid = 1073741824 (fails) >    ... >    select rowid where rowid = 65536 (fails)

Re: [sqlite] corrupt database recovery

2009-04-26 Thread Jim Wilcoxson
You could do a binary search to find the highest accessible rowid: select rowid where rowid = 2147483647 (fails) select rowid where rowid = 1073741824 (fails) ... select rowid where rowid = 65536 (fails) select rowid where rowid = 32768 (works!) select rowid where rowid = 4

Re: [sqlite] Sort order with umlauts

2009-04-26 Thread Igor Tandetnik
"Lukas Haase" wrote in message news:gt0078$n7...@ger.gmane.org > Now I have the problem that I have also words with umlauts. Now they > are sorted this way: > > But I need the umlauts treated as their respective vovels, i.e.: http://sqlite.org/c3ref/create_collation.html Igor Tandetnik _

Re: [sqlite] corrupt database recovery

2009-04-26 Thread Tito Ciuro
Hi Gene, On Apr 25, 2009, at 3:47 PM, Gene wrote: > Every now and again, we have a database that gets corrupt in the > field (bad > coding on our end, not sqlite). How do you corrupt a database with bad coding? Just curious... -- Tito ___ sqlite-use

Re: [sqlite] Sort order with umlauts

2009-04-26 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Lukas Haase wrote: > Now I have the problem that I have also words with umlauts. To get correct sorting and case conversion then the best method is to use the ICU SQLite extension. You can read about it at http://www.sqlite.org/cvstrac/fileview?f=sql