How to install tiddlywebplugins.mysql2
- Download and install ActivePython
- Open Command Prompt
- Type
pypm install tiddlywebplugins.mysql2
Lastest release
A plugin for TiddlyWeb subclassing tiddlywebplugins.sqlalchemy2 with mysql specifics.
!!! WARNING !!! This code will only work with mysql versions 5.1 and earlier. Work is in progress with a version that works correctly with 5.5. If you have 5.5 and want to experiment with a test version please post in the tiddlyweb google group: http://groups.google.com/group/tiddlyweb
The main additions to sqlalchemy2 are:
- 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's import to set some mysql my.cnf variables 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);
Thanks to Adrian Hosey <http://adrianhosey.blogspot.com/> for help over some SQL humps.