The mandatory like to prevent TONU. :P On Mon, Oct 19, 2009 at 6:04 AM, Girish Venkatachalam <[email protected]> wrote: > And my experience with it has been really pleasant though I learnt it only > now.
For those who are interested, I have a little more to say about sqlite. 1) It does not run as a server. So in languages, you can have only one open connection on the database and you cannot have 2 writers. I learnt this the hard way with sqlite-jdbc. I did not do my groundwork and later found that it is documented in http://www.zentus.com/sqlitejdbc/usage.html). I don't remember having any such problem in sqlite in ruby or python though. Maybe I just did it right 2) Listing the tables that are present is very simple sqite>.tables <LIST OF TABLES> 3) Your database IS A SINGLE FILE! 4) .schema prints the table's create statements. 5) It lacks some SQL standard features like triggers. and privileges.But then, I never needed them in my apps 6) Queries are evil-fast ---- Ashok `ScriptDevil` Gautham _______________________________________________ To unsubscribe, email [email protected] with "unsubscribe <password> <address>" in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
