Re: [sqlite] documentation on the webserver

2006-10-14 Thread Peter Cunderlik
Can you possibly put a version specific copy of the API reference up instead of just a single page? Each time you change it just clone the page and change the new page instead. AFAIK the docs online are the ones for the most recent version of SQLite. The 3.1.14 docs should be in the 3.1.14

Re: [sqlite] Problems opening db in win9x and utf8 filename

2006-08-08 Thread Peter Cunderlik
On 8/8/06, John Stanton <[EMAIL PROTECTED]> wrote: Our Sqlite applications work not only on Win98 and Win2000 but also on Linux, AIX and Solaris. Where did we go wrong? Irony aside, you wouldn't believe how many systems claiming to be i18n aware fail miserably when handling other than Latin-1

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

2006-08-07 Thread Peter Cunderlik
On 8/7/06, wqual <[EMAIL PROTECTED]> wrote: Hi list, I have sqlite 3.2.1 installed on my computer. Now, I need to replace some substrings in my sqlite-table (for example, replace 'strasse' with 'str.' , german 'รค' with 'ae' etc.). Can I search for the substrings and replace them by another one?

Re: [sqlite] Problems opening db in win9x and utf8 filename

2006-08-05 Thread Peter Cunderlik
On 8/5/06, Costas Stergiou <[EMAIL PROTECTED]> wrote: Hello, I am encountering a problem trying to open a sqlite3 db (ver 3.3.6) using the sqlite3_open function. According to the docs, the file path should be utf8 encoded. If in the path there are non-ansii chars, the following method fails in

Re: [sqlite] Reading the same table from two threads

2006-07-26 Thread Peter Cunderlik
On 7/26/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: It has been suggested that I add a mutex to every SQLite database connection. This would cause access to a database connection to automatically serialize even when two or more threads try to use that connection at once, thus preventing

Re: [sqlite] Using SQLite with MinGW Studio

2006-07-25 Thread Peter Cunderlik
In the ld command line, don't use the "lib" prefix, specify "sqlite3.dll.a" instead of "libsqlite3.dll.a". Peter On 7/25/06, Hat Keinen <[EMAIL PROTECTED]> wrote: Hello, I'm using the MinGW Developer Studio (on windows/windows version), http://www.parinyasoft.com/ Currently I'm trying to get

Re: [sqlite] test program won't run anymore! sqliteBtreeOpen: Assertion 'seizeof...

2006-07-24 Thread Peter Cunderlik
I'd try the following: 1. make completely sure you're linking against the correct SQLite library. Are you linking dynamically or statically? 2. turn all optimizations off (CFLAGS="" before running ./configure), compile, link and test your app. 3. grab the pre-configured SQLite sources

Re: [sqlite] real time gui updates

2006-06-28 Thread Peter Cunderlik
On 6/28/06, Rob Menegon <[EMAIL PROTECTED]> wrote: I have an application that displays data retrieved from various SQLite tables. As the data within the tables changes I want these changes reflected in the application real time. Can someone advise on the best way of doing this? Try

Re: [sqlite] suggesiton needed for using SQL lite in a situation

2006-06-22 Thread Peter Cunderlik
1) I make 1 DB having data for so many users. 2) I make seperate DB for each user Second approach implies that you'd have to do your own database files (users) management when adding/removing users. It also means you have'd have several database files to keep, so the simplicity of handling

Re: [sqlite] DLLs containing user-defined SQL functions

2006-06-08 Thread Peter Cunderlik
How does introducing a new shared library format that supports automatic bidirectional linking (as in Unix) break backwards compatibility? Nobody says they have to stop supporting DLLs. Just provide something better in addition to DLLs... Despite disliking many of the Win32 "features", I see

Re: [sqlite] Multithreading. Again.

2006-06-02 Thread Peter Cunderlik
> 1. As of SQLite 3.3.5, there is no multithreading (MT) problem with > the SQLite itself. All problems come from the underlying OS libraries. I would argue that this has always been the case. But beginning in version 3.3.1, SQLite has taken additional steps to partially work around problems in

[sqlite] Multithreading. Again.

2006-06-01 Thread Peter Cunderlik
libraries) and SQLite (compile-time options/defines) and possible problems with multithreading. Thanks for your time. Peter Cunderlik