Re: [sqlite] Does SQLite have a fulltext search like MySQL?

On Tue, Jul 12, 2005 at 01:26:19PM +0530, Siddharth Vijayakrishnan wrote: > On 7/11/05, Henry Miller <[EMAIL PROTECTED]> wrote: > > For full text search I find the lucene/clucene > > http://lucene.apache.org/ > > http://sourceforge.net/projects/clucene/ > > > > to be good solutions. The licenses

Re: [sqlite] atomic db replacement

On Mon, Mar 14, 2005 at 11:50:45AM -0700, Ara T Howard wrote: > > > does anyone have a strategy for doing massive updates to a db and > > atomicly> replacing it in a multi-process situation? > > > > Assuming you have a cgi-like application with many processes that just > > looks up a row, display

Re: [sqlite] Is there any way to enable recursive triggers?

> So do we put recursion limits on UPDATE and INSERT triggers > only and let DELETE triggers run as long as they like? > That works as far as I know, but it seems kind of arbitrary. > > Surely somebody else has been down this road before me and > can offer a little guidance? Why don't give this b