MySQL-based store for tiddlyweb
Project description
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.
!!! 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.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Close
Hashes for tiddlywebplugins.mysql3-3.0.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | cc5730192b351c4424bdca801407e185f3d64c3e7679d23882ba08d1c95a4bcb |
|
MD5 | fb2ab314f8bfdd1cd4723165028d6a68 |
|
BLAKE2b-256 | a5bbfa8ca1f0d5f5b65b99b468d69005f768513bd3bbe08f692e83456639a32b |