damned-lies r1114 - branches/djamnedlies

[stephaner svn gnome org]

Author: stephaner
Date: Tue Oct 28 14:52:39 2008
New Revision: 1114
URL: http://svn.gnome.org/viewvc/damned-lies?rev=1114&view=rev

Log:
2008-10-28  StÃphane Raimbault  <stephane raimbault gmail com>

	* README:
	* settings_sample.py: Notes about databases configuration.


Modified:
   branches/djamnedlies/ChangeLog
   branches/djamnedlies/README
   branches/djamnedlies/settings_sample.py

Modified: branches/djamnedlies/README
==============================================================================
--- branches/djamnedlies/README	(original)
+++ branches/djamnedlies/README	Tue Oct 28 14:52:39 2008
@@ -15,8 +15,44 @@
 ============
 
 1 - Rename settings_sample.py in settings.py
+
 2 - Review and fill in settings in stats/conf/settings_sample.py and
-    rename it to settings.py
-3 - Run python manage.py syncdb
+    rename it to settings.py (please refer to Database configuration
+    below for more informations).
+
+3 - Run 'python manage.py syncdb'
+
 4 - Configure Sites in admin interface to define the 'View on site'
     link.
+
+
+Databases
+=========
+
+It's important to use the Unix Domain Socket connection to obtain good
+performances.
+
+PostgreSQL
+----------
+
+You just need to define DATABASE_ENGINE = 'postgresql_psycopg2' and DATABASE_NAME. Leave DATABASE_HOST setting empty to use UDS.
+
+MySQL
+-----
+
+Create a database in UTF8, either with default-character-set = utf8
+under [mysqld] section in the my.cnf file or with an explicit 'create
+database bla charset=utf8;'
+
+In settings.py:
+
+DATABASE_HOST = '/var/run/mysqld/mysqld.sock'
+
+DATABASE_OPTIONS = {
+    'read_default_file': '/etc/mysql/my.cnf',
+    "init_command": "SET storage_engine=INNODB"
+}
+
+
+
+

Modified: branches/djamnedlies/settings_sample.py
==============================================================================
--- branches/djamnedlies/settings_sample.py	(original)
+++ branches/djamnedlies/settings_sample.py	Tue Oct 28 14:52:39 2008
@@ -10,6 +10,7 @@
 
 ADMINS = (
     ('Claude Paroz', 'claude 2xlibre net'),
+    ('Stephane Raimbault', 'stephane raimbault gmail com'),
 )
 
 MANAGERS = ADMINS
@@ -21,6 +22,17 @@
 DATABASE_HOST = ''             # Set to empty string for localhost. Not used with sqlite3.
 DATABASE_PORT = ''             # Set to empty string for default. Not used with sqlite3.
 
+# If you can't use PostgreSQL :-/, here is the MySQL configuration:
+#
+# DATABASE_HOST = '/var/run/mysqld/mysqld.sock'
+#
+# DATABASE_OPTIONS = {
+#    'read_default_file': '/etc/mysql/my.cnf',
+#    'init_command': 'SET storage_engine=INNODB'
+# }
+# 
+# Please refer to the README file to create an UTF-8 database with MySQL.
+
 # Local time zone for this installation. Choices can be found here:
 # http://en.wikipedia.org/wiki/List_of_tz_zones_by_name
 # although not all choices may be available on all operating systems.