[Python-Dev] SQLite module for Python 2.5
carribeiro at gmail.com
Thu Oct 21 06:06:08 CEST 2004
On Wed, 20 Oct 2004 22:53:30 -0500, Skip Montanaro <skip at pobox.com> wrote:
> Bob> By default can mean that Python builds a SQLite wrapper if SQLite
> Bob> is available, just like it does for bsddb, readline, etc.
> >> Then why not MySQLdb, psycopg and sybase-python also? No slight
> >> intended against PySQLite, but those other wrapper modules have been
> >> around quite a bit longer I think.
> Phillip> Well, one difference is that none of the databases you just
> Phillip> listed are embeddable. There has to be a separate database
> Phillip> server process. SQLite, like other "database" modules in the
> Phillip> stdlib, just stores data in a disk file.
> It seems people misunderstood my comment. I should have been more clear. I
> see no reason PySQLite should be accorded better status than any of the
> other relational database wrappers. If MySQLdb, etc aren't included with
> the distribution I don't think PySQLite should be either. I realize it's
> easier to administer a PySQLite database than a PostgreSQL database, but
> from a pure client standpoint there's nothing really easier about it. By
> including PySQLite we'd somehow be blessing it as a better SQL solution than
> the other options. That means it will almost certainly be stretched beyond
> its limits and used in situations where it isn't appropriate (multiple
> writers, writers that hold the database for a long time, etc). That will
> reflect badly on both SQLite and Python.
I think that I understand your argument -- in fact that was my first
impression when the thread started. It sounds perfectly reasonable,
but it really doesn't hold upon closer inspection. In a very similar
situation, the presence of the SimpleHTTPServer on the library hasn't
stopped anyone from using Apache, or from writing their own web server
engines -- some as extensions of the standard module, some as
replacements written from the scratch. Of course, webservers and
database engines are different beasts, and Apache is what it is, a
true benchmark -- but can't similar the same thing be said about MySQL
or PostgreSQL (not to mention Oracle and other commercial offerings)?
Consultoria em Projetos
mail: carribeiro at gmail.com
mail: carribeiro at yahoo.com
More information about the Python-Dev