Metadata-Version: 1.0
Name: tiddlywebplugins.mysql3
Version: 3.0.6
Summary: MySQL-based store for tiddlyweb
Home-page: http://pypi.python.org/pypi/tiddlywebplugins.mysql3
Author: Chris Dent
Author-email: cdent@peermore.com
License: BSD
Description: A plugin for TiddlyWeb subclassing tiddlywebplugins.sqlalchemy3 with mysql specifics.
        
        The main additions to sqlalchemy3 are:
        
        * Optionally provide a reasonable search interface using mysql's fulltext.
        * Provide field based searches of tiddler attributes and fields.
        * Support finding tiddlers that have geo.lat and geo.long fields
          near a location.
        * Provide an index_query method to allow the plugin to be used as
          an 'indexer' for filters and determine_bag_for_tiddler.
        
        NOTES
        
        It is important to set some mysql my.cnf variables if you are using
        the fulltext indexing otherwise searches will likely fail.
        
        [mysqld]
        ft_min_word_len = 3
        ft_stopword_file = ''
        
        You will need to create a database. I use one called 'tiddlyweb', and
        add the following to tiddlywebconfig.py:
        
            'server_store': ['tiddlywebplugins.mysql', {
                'db_config': 'mysql:///tiddlyweb?charset=utf8&use_unicode=0'}],
            'indexer': 'tiddlywebplugins.mysql',
        
        If you want to use the fulltext indexing capability you will need to
        create the fulltext index:
        
            CREATE FULLTEXT INDEX tiddlytext ON text(text);
        
        Also set 'mysql.fulltext' to True in tiddlywebconfig.py. This makes
        sure the text table is MyISAM.
        
        Note that even if fulltext is not turned on, text searches will still
        work, but not as flexibly.
        
        Thanks to Adrian Hosey <http://adrianhosey.blogspot.com/> for help over
        some SQL humps.
        
Platform: Posix; MacOS X; Windows
