Thank you Chris, that is all very informative and helpful! On May 27, 9:11 pm, Christopher Arndt <[EMAIL PROTECTED]> wrote: > 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 > > "VisualStudio" installation error as didpysqlitewith TG and Python > > 2.4? > > SQLite refers to the same SQL database engine aspysqlite. 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. > > pysqliteis a Python wrapper/interface to te SQLite C library. It comes > in 4 flavours > > 1)pysqlite1.x is an old, obsolete interface to SQLite version 2 > > 2)pysqlite1.1.x is interface to SQLite version 3 with and API > compatible topysqlite1.x > > 3)pysqlite2.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 ofpysqlite2. 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 installingpysqlite(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 -~----------~----~----~----~------~----~------~--~---
