tiddlywebplugins.mysql3 MySQL-based store for tiddlyweb
Download

tiddlywebplugins.mysql3 Ranking & Summary

tiddlywebplugins.mysql3 Tags

MySQL store TiddlyWeb plugin TiddlyWeb MySQL store

tiddlywebplugins.mysql3 Description

tiddlywebplugins.mysql3 is 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/tiddlywebThe 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.NOTESIt's import to set some mysql my.cnf variables otherwise searches will likely fail.ft_min_word_len = 3ft_stopword_file = ''You will need to create a database. I use one called 'tiddlyweb', and add the following to tiddlywebconfig.py: 'server_store': , '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 for help over some SQL humps.Product's homepage

tiddlywebplugins.mysql3 Related Software