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-users

Re: [sqlite] Sort order with umlauts

2009-04-26 Thread Igor Tandetnik
Lukas Haase lukasha...@gmx.at 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

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 =

Re: [sqlite] corrupt database recovery

2009-04-26 Thread Jim Dodgen
Cool solution. On Sun, Apr 26, 2009 at 6:39 AM, Jim Wilcoxson pri...@gmail.com 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 =

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

2009-04-26 Thread Wiktor Karczewski
Vinnie pisze: From: wiktor siri...@o2.pl 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

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 jo...@viacognis.com 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

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