wiki:DataBaseInstalation
Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": No module named svn). Look in the Trac log for more information.

Version 2 (modified by jorge.vargas, 13 years ago) (diff)

--

This page is inteded to be use by either SQLObject or SQLAlhemy and even though it's not directly TG related it's a must.

NOTE: please note that even though SQLALchemy support is now primitive it's the way to go in the future.

For now it's just a bunch of links because I intent it to be created by everyone

From  http://www.sqlobject.org/SQLObject.html#dbconnection-database-connections

SQLObject Supported Backends

  • MySQL
  • Postgres
  • SQLite
  • Firebird
  • Sybase
  • MAX DB
  • MS SQL Server

From  http://www.sqlalchemy.org/trac/browser/sqlalchemy/trunk/lib/sqlalchemy/databases

SQLAlchemy Supported Backends

  • firebird
  • mssql
  • mysql
  • oracle
  • postgres
  • sqlite

First we'll assume you already have a database backend install and working, since if you want a ORM you are probably sick of SQL and therefore have a funtional database :)

The process of installing a db is very diferent for each one so please  google it.

pause while you install the db engine

So now that we have a working db we need some python bindings for it, that is a library that lets python programs interact with the db backend.

Linux

There many ways to install

  • look if the package is in your package manager.
  • if not then make a package for it.
  • look if it is available from  http://www.python.org/pypi and easy_install it.
  • build from source.

Which way to go depends on you, although most distros prefer to manage all install, easy_install is probably the easiest way.

MySql

You will need  mysqldb it may be call mysql-python on your package manager and it is call that way in pypi.

Best Approach

  • Use your package manager

if that fails

  • Install development tools (gcc,make,etc.)
  • Install mysql developement tools
    easy_install mysql-python
    

SqlLite

You will need  pysqlite

Best Approach

  • Use your package manager

As easy as the above

easy_install pysqlite

PostgreSql

TODO

Windows

In Windows there is basically one way to install packages, an exe file (aka installer), provided by the package author or users. Installing from source is a pain and should be your last resource. If you do choose to go this way you will need VisualStudio? or the equivalent TODO add link to MC visual C compiler, NOTE it's not an easy task.

MySql

You will need  mysqldb mysql-python is the name in in pypi.

As of May 3 2006 there is NO installer for the lastest version so easy_install WILL fail.

Best Approach

 mysql-python Downloads and get the lastest exe/zip.

if that fails

  • TODO if I ever get this (got a week trying to compile it, post it here)

SqlLite

You will need  pysqlite

Best Approach

  • easy_install pysqlite

PostgreSql

TODO

MacOS

MySql

TODO

SqlLite

TODO

PostgreSql

TODO