Re: [sqlite] Best method to create a database with a tree structure?

2004-01-18 Thread Stephane Legrand
On Mon, Jan 19, 2004 at 06:52:41AM +0800, John Scott wrote: > > Hello folks, > > I am thinking of to create a database with a tree structure. > ... Hi, A very interesting way is described in the excellent book "Advanced SQL" by Joe Celko: basically, a tree can be viewed as a set of (sub-)sets.

Re: [sqlite] How do I cross compile for FreeBSD

2004-02-10 Thread Stephane Legrand
On Tue, Feb 10, 2004 at 10:18:54AM -0800, Cory Phillips wrote: > A while back I asked if anyone knew where I could get > a binary of sqlite for FreeBSD. I didn't get any > replies, so now I'm wondering if anyone can assist me > with how to do a cross compile with FreeBSD as the > target. I run Re

Re: [sqlite] FreeBSD and SQLite

2004-04-14 Thread Stephane Legrand
On Wed, Apr 14, 2004 at 12:36:53PM -0400, Al Rider wrote: > I do website design for clubs, etc., with a lot of custom, CM php scripts. > SQLite is ideally suited for many of my scripts; but, unfortunately one of > the sites is hosted on a FreeBSD based server. Most of my designs are > Linux; but,