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 100 ) which is the amount of rows displayed in any table under ‘browse’ view of section ‘table’
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
using pypi
Install from pypi with the handle tiote. i.e.:
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:
This makes tiote accessible globally on your python path.
You can also just make the tiote folder accessible by django 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:
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
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.
Screenshots of tiote
Browsing a Table:
Editing a Table:
Full view of a single table entry:
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
Search
Please activate JavaScript to enable the search
functionality.
From here you can search these documents. Enter your search
words into the box below and click "search". Note that the search
function will automatically search for all of the words. Pages
containing fewer words won't appear in the result list.