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

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

Re: [sqlite] Size of fields

SQLite mostly ignores type info. See and #q11. Also . - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

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

Hi Martin, You are talking about standard Parent/Child relationships here but because you have unlimited number of entries you fold it into one table and have a Parent_ID column. So if you have your required details as being these columns Name SomethingElse Then a standard table might be

[sqlite] performance tester for SQLite

Hi all, I programmed a little performance tester for SQLite. Check this page to download: http://www.inside.net/sqlite/ Feedback welcome (in particular comparisons with the Linux version). cheers - Balthasar Indermuehle All science is either physics or stamp collecting. Ernest Rutherford

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

Hello folks, I am thinking of to create a database with a tree structure. BUt it seems to be a hard work. I would like to have a tree structure embbeded into the database like: Root folder which contains two other folders "books" and "music". If a click on books, only the entries in the

Re: [sqlite] SQLite Browser (Mac OS 10.3)

Yes... in OS X, everything that happens is written on in an app called Console. I write the author a while back too and he asked that I attempt to launch it again with Console running and then send him whatever errors/messages appear, but... strangely... I am still getting nothing in the

[sqlite] Constraint violation on INSERT/UPDATE

I submitted a file to my database, where I just put some unique's on... Now I had a double there somewhere ... And now the whole transmission is not submitted... So I went looking into the sqlite source... And I figured out I should use OE_Ignore (first of all, is that correct if I just want

Re: [sqlite] How to link under Windows

Hi Erik, So basically, I'd be very grateful if anyone using SQLite on Windows could point out how to link it and where to get hold of the correct sqlite.h. Just get http://sqlite.org/sqlite_source.zip. /eno - To unsubscribe,

Re: [sqlite] How to link under Windows

Erik, You will need to use one of the .Net Wrappers or the .NET data providers. http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers regards Greg O Erik Jälevik wrote: I'm just about to write some code using SQLite from Visual Studio .NET under Win XP. I am however, not sure how I go about linking

[sqlite] New function, strpos

Hi, I've been using sqlite for some time, and it lacked a function, strpos, so I just added a first simple version of it. It does not support UTF8, because 1) I don't really understand it, and 2) I don't need it ;) The patch is attached. strpos(string, substring, n) which will return the

RE: [sqlite] Performance...there must be a reason

> -Original Message- > From: Tim Anderson [mailto:[EMAIL PROTECTED] > Sent: 17 January 2004 22:45 > To: [EMAIL PROTECTED] > Subject: [sqlite] Performance...there must be a reason > What I can't work out is why. The same database is used. The > same Sqlite dll is used. The same pragmas