On Sep 16, 2008, at 12:09 PM, Jeff Godfrey wrote: > Patrick wrote: >> I was just wondering if anyone had an opinion on the most ideal >> language >> to use with SQLite? >> >> I love Python but I LOVE SQLite, I would learn another language >> just to >> use it better-Patrick >> > According to a paper written by Richard Hipp (the creator of SQLite), > Tcl is the ideal language. Here's a quote from the mentioned paper: > > "The increasing popularity of SQLite is seen in the fact that the main > website daily serves about a gigabyte of data to around 3000 unique IP > addresses. SQLite has been eagerly embraced by PHP, Perl, and Python > programmers. What most of these enthusiastic users fail to realize is > that SQLite bindings for the three P-languages are an afterthought. > SQLite was designed from the beginning to be used with Tcl. Tcl > bindings > have been in the SQLite core since before version 1.0 and almost > half of > the SQLite source code base consists of regression test scripts > written > in Tcl. SQLite wants to be programmed in Tcl, not those other > languages."
SQLite is a TCL extension that has escaped into the wild. SQLite was originally written to support a large program written in Tcl/Tk. SQLite would have never existed where it not for TCL. SQLite could not maintain its current quality without the extensive TCL-based test suite. The language bindings for TCL are the most natural and easy-to- use of any language I have seen. The statistics in the quote above are dated. Recently we have been getting about 11,000 unique IPs per day at the website and the amount of TCL code in the source tree (all of the regression tests) is approaching 75%. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
