tiote¶
Tiote enables django websites to administer PostgreSQL and MySQL databases. It provides a clean and intuitive interface to your database(s) with which you can use Database level functions.
Table of Contents¶
Installation¶
Installation steps can be summarised as making tiote and its associated static fles accessbile by your django project
Requirements¶
Please make sure the following requirements as highlighted below has being met
- sqlalchemy >= 0.6.8
- django >= 1.3
- python-psycopg2 ( enables support for PostgreSQL databases)
- python-mysqldb ( enables support for MySQL databases)
- static-files app for Django versions less than 1.3
- django session app
- Enabled javascript and Cookies in your browser (if not already enabled)
Installation Methods¶
checkout repository¶
Grab a copy of this repository:
git clone git://github.com/dumb906/tiote
Switch your directory into the root folder of the directory and run:
python setup.py install
This makes tiote accessible globally on your python path.
manual setup¶
You can also just make the tiote folder from the project repository be accessible by django’s manage.py
Configuration¶
In the settings.py of your django project add ‘tiote’ to the INSTALLED_APPS settings and django.contrib.sessions if it is not already there. and run:
python manage.py syncdb
Note
If you are running tiote outside the django’s development server. You need to setup serving of static files. See managing static files
In the urls.py of your project, add a url mapping for the tiote application (any address you want):
(r'^<custom_url_map>/', include('tiote.urls')),
Open link <your_project>/<custom_url_map> to begin using tiote. Where <your_project> is the top level of your django project and <custom_url_map> is the url mapping for the application
Upgrade¶
After any upgrade, remember to update the static files since they are usually set once. So if the django static_app is used, after updating the source files run python manage.py runserver
Customisation¶
Tiote comes with some reasonable defaults which take bandwidth and the number of database queries into consideration. But if your needs include more finetuning and plumbling then here are some options with which you can change the default behaviour of tiote.
All this settings are to be entered in settings.py or its equivalent
- TT_SHOW_SYSTEM_CATALOGS Include (set to True) or exclude (set to False) system catalogs. Excluding system catalogs is the default and increases individual page load. This option is only for the PostgreSQL dialect.
- TT_SESSION_EXPIRY: accepts an integer (default 1800) which is the amount of seconds before the session expires (to be asked to log on again). It doesn’t conflict with other sessions from other django applications.
- TT_MAX_ROW_COUNT : accepts an integer (defaults to 30 ) which is the amount of rows displayed in any table under ‘browse’ view of section ‘table’
Project Overview¶
Tiote enables django websites to administer PostgreSQL and MySQL databases. It provides a clean and intuitive interface to your database(s) with which you can use Database level functions. This functions can be summarised as CRUD (Create, Read, Update and Delete). It has been tested both on linux (ubuntu), and epio (https://ep.io) environments.
Frequently Asked Questions¶
This page would be populated with common questions the authors have been asked about tiote
- No use of foriegn keys
- It takes a high amout of database queries to generate all the needed data for a single column to a single table needed foreign relations. This would then increase polynomially for all the columns in a table. Therefore automation and editing of foreign key relations are disabled
Changelog¶
0.2.4 : July 22, 2012¶
column creation. better postgresql constraints’ view bug fixes
0.2.3 : May 27, 2012¶
Viewing, droping and reseting sequences. All under database overview
0.2.2 : May 24, 2012¶
performance optimisations
rewrote the logic for making queries and generating views
now makes use of a lot of SQLAlchemy functions
bug fixes
0.2.0 : April 19, 2012¶
Project files can now be downloaded from pypi