[sqlite] Locking queries

Hi, As per my understanding I see that SQLite supports only database locking, as opposed to table/row locking. Does anyone know if you can read from a locked database ? (i.e. if one application has locked the database for writing, then can another application read/query it whilst its locked?

Re: [sqlite] Locking queries

On 8/23/07, Pavan [EMAIL PROTECTED] wrote: As per my understanding I see that SQLite supports only database locking, as opposed to table/row locking. Does anyone know if you can read from a locked database ? (i.e. if one application has locked the database for writing, then can another

Re: [sqlite] Client/Server approach

You do not need a server to manage 5 clients on the same machine, only if they are on a network. Sreedhar.a wrote: Hi, I am working in sqlite 3.3.6. I want 5 clients to browse at the same time with good performance. I enabled threadsafe and defined SQLITE_ENABLE_MEMORY_MANAGEMENT . I think

RE: [sqlite] Update Columns in One Table Using Values From Another Table

Hrmm... I wonder if this would work (complete guess, totally untested) INSERT OR REPLACE INTO core SELECT Core.A, Updates.B, Core.C, Updates.D FROM Core INNER JOIN Updates ON (Core.A = Updates.A) Idea being, I guess, to get the rows that you ultimately want from the sub-select and then

[sqlite] Disabling tcl bug?

Hi, When trying to install 3.4.2 without tcl (--disable-tcl) it all works ok during compilation, but when trying to install, the install script tries to run the tclsh command. Is this normal? Thank you -- Alberto Simões

Re: [sqlite] FTS2 suggestion

Would it not be more useful to first implement potter stemmer algorithm, and then to implement n-gram (as I understand n-gram is for cross column fuzzy search?). What is the general game plan for FTS3 with regard to fuzzy search? Thanks in advance Cesar D. Rodas [EMAIL PROTECTED] wrote:

[sqlite] R: [sqlite] Disabling tcl bug?

When trying to install 3.4.2 without tcl (--disable-tcl) it all works ok during compilation, but when trying to install, the install script tries to run the tclsh command. Is this normal? Thank you If you're building on Windows, using MSYS, I think it isn't normal, and I wrote a few days ago

Re: [sqlite] FTS2 suggestion

Porter stemmer is already in there. The main issue with Porter is that it's English only. There is no general game-plan for fuzzy search at this time, though if someone wants to step into the breech, go for it! Even a prototype which demonstrates the concepts and problems but isn't

[sqlite] Enumerating rows in a view

Hi all, When I create a table, SQLite enumerates the rows in the rowid column. When I create a view, is there any way to enumerate the output rows? For example, say I have a table: create table Planets( Name text collate nocase ); insert into Planets values( 'Mercury' ); insert into Planets

[sqlite] Are parenthesis really needed?

Hi there, Is there any sort of expression inside a query that needs to be surrounded by parenthesis? My program will receive queries built to run in MySQL, Oracle and Postgrees. The problem, as posted before, is that SQLite has problems with parenthesis around JOINs... So, what I want to do is

Re: [sqlite] Are parenthesis really needed?

Won't most arithmetic expressions such as : SELECT (col1 + col2) * col3 FROM table require parenthesis ? Regards, -- Olivier LE FLOCH On 25 août 07, at 00:01, Bruno S. Oliveira wrote: Hi there, Is there any sort of expression inside a query that needs to be surrounded by parenthesis?

[sqlite] Re: Are parenthesis really needed?

Bruno S. Oliveira [EMAIL PROTECTED] wrote: Is there any sort of expression inside a query that needs to be surrounded by parenthesis? My program will receive queries built to run in MySQL, Oracle and Postgrees. The problem, as posted before, is that SQLite has problems with parenthesis around

Re: [sqlite] Are parenthesis really needed?

I don't think so: for example logical operations need to be contained like in a ON or WHERE clause example WHERE ((a = X AND b = Y) OR z = W) AND x = foo if you remove the parenthesis then it will evaluate differently Bruno S. Oliveira wrote: Hi there, Is there any sort of expression

Re: [sqlite] Problem opening a new SQLite3 database file

On 8/23/07, Dennis Achá [EMAIL PROTECTED] wrote: I cannot open a new SQLite3 database file through the command prompt. In the windows run window, I type SQLite3 mydatabase.db3 and I get the following error message: snip Using Start Menu/Run is not the most flexible way of running the

Re: [sqlite] Looking for a cryptographic library

Search for the following on the web: BeeCrypt, CryptoPP, OpenSSL Ray Hurst [EMAIL PROTECTED] wrote: Hi all: I'm writing an application that uses SQLite to store user's data, and need a library to crypt some stuff, including passwords and data. The goal is to crypt before insert and

Re: [sqlite] Are parenthesis really needed?

--- Bruno S. Oliveira [EMAIL PROTECTED] wrote: Is there any sort of expression inside a query that needs to be surrounded by parenthesis? My program will receive queries built to run in MySQL, Oracle and Postgrees. The problem, as posted before, is that SQLite has problems with parenthesis