buffalob schrieb: > Would the SQLite db you mention be a good alternative in that regard? > I take it that despite the name similarity it won't give me the same > "Visual Studio" installation error as did pysqlite with TG and Python > 2.4?
SQLite refers to the same SQL database engine as pysqlite. SQLite is a C library, implementing an SQL database engine, which stores the database in a single file. It can be directly incorporated into a program, there is no need to run a database server as with e.g. MySQL or PostgreSQL. pysqlite is a Python wrapper/interface to te SQLite C library. It comes in 4 flavours 1) pysqlite 1.x is an old, obsolete interface to SQLite version 2 2) pysqlite 1.1.x is interface to SQLite version 3 with and API compatible to pysqlite 1.x 3) pysqlite 2.x is an DB-API compatible interface to SQLite version 3. This is the version most commonly in use with Python atm and the one normally used with TurboGears and SQLObject/SQLAlchemy 4) sqlite3 is a version of pysqlite 2. that has been incorporated into the standard library for Python 2.5 and (I think) slightly adapted but still very similar to 3) > Or would something like MySQL be better for me at that point? No, I think not. I never had any problems installing pysqlite (though it used to be more difficult on Windows, but now the Windows version ships with a prebuilt SQLite C library). If your installation problems persist, just ask for help here. With MySQL or other database servers you'd have to learn about creating databases, database users and authentication for connecting to the database and so on. Eventually, if you're serious about web development, you'll have to learn about these things, but for getting started and for applications that don't have many users, SQLite is a good solution. When You really want to look into a "big" database system, I'd recommend checking out PostgreSQL instead of MySQL. There are a lot of reasons for this but the most important IMHO is that unicode support is much better with Postgres. Chris --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
