MySQL-based store for tiddlyweb
Project description
A plugin for TiddlyWeb subclassing tiddlywebplugins.sqlalchemy3 with mysql specifics.
The main additions to sqlalchemy3 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.
The main additions to sqlalchemy3 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.2.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7593cde8336740a818def2b0d5aae3717e8bffc62a0c592276beaffd48e9802f |
|
MD5 | 8c5b87869c4631e914e571eb8708e875 |
|
BLAKE2b-256 | 548c8ff147002edddeda157fea63efd2f42ff58185685427b20d774f4349ea7b |