Welcome, guest | Sign In | My Account | Store | Cart

Notice! PyPM is being replaced with the ActiveState Platform, which enhances PyPM’s build and deploy capabilities. Create your free Platform account to download ActivePython or customize Python with the packages you require and get automatic updates.

Download
ActivePython
INSTALL>
pypm install tiddlywebplugins.mysql2

How to install tiddlywebplugins.mysql2

  1. Download and install ActivePython
  2. Open Command Prompt
  3. Type pypm install tiddlywebplugins.mysql2
 Python 2.7Python 3.2Python 3.3
Windows (32-bit)
2.1.14 Available View build log
2.1.13 Available View build log
2.1.12 Available View build log
2.1.11 Available View build log
2.1.10 Available View build log
2.1.9 Available View build log
2.1.8 Available View build log
2.1.7 Available View build log
2.1.5 Available View build log
2.1.4 Available View build log
2.1.3 Available View build log
2.1.2 Available View build log
2.1.1 Available View build log
2.0.9 Available View build log
2.0.8 Available View build log
2.0.7 Available View build log
2.0.6 Available View build log
2.0.4 Available View build log
2.0.2 Available View build log
2.0.0 Available View build log
Windows (64-bit)
2.1.14 Available View build log
2.1.13 Available View build log
2.1.12 Available View build log
2.1.11 Available View build log
2.1.10 Available View build log
2.1.9 Available View build log
2.1.8 Available View build log
2.1.7 Available View build log
2.1.5 Available View build log
2.1.4 Available View build log
2.1.3 Available View build log
2.1.2 Available View build log
2.1.1 Available View build log
2.0.9 Available View build log
2.0.8 Available View build log
2.0.7 Available View build log
2.0.6 Available View build log
2.0.4 Available View build log
2.0.2 Available View build log
2.0.0 Available View build log
Mac OS X (10.5+)
2.1.14 Available View build log
2.1.13 Available View build log
2.1.12 Available View build log
2.1.11 Available View build log
2.1.10 Available View build log
2.1.9 Available View build log
2.1.8 Available View build log
2.1.7 Available View build log
2.1.5 Available View build log
2.1.4 Available View build log
2.1.3 Available View build log
2.1.2 Available View build log
2.1.1 Available View build log
2.0.9 Available View build log
2.0.8 Available View build log
2.0.7 Available View build log
2.0.6 Available View build log
2.0.4 Available View build log
2.0.2 Available View build log
2.0.0 Available View build log
Linux (32-bit)
2.1.14 Available View build log
2.1.13 Available View build log
2.1.12 Available View build log
2.1.11 Available View build log
2.1.10 Available View build log
2.1.9 Available View build log
2.1.8 Available View build log
2.1.7 Available View build log
2.1.5 Available View build log
2.1.4 Available View build log
2.1.3 Available View build log
2.1.2 Available View build log
2.1.1 Available View build log
2.0.9 Available View build log
2.0.8 Available View build log
2.0.7 Available View build log
2.0.6 Available View build log
2.0.4 Available View build log
2.0.2 Available View build log
2.0.0 Available View build log
Linux (64-bit)
2.1.14 Available View build log
2.1.13 Available View build log
2.1.12 Available View build log
2.1.11 Available View build log
2.1.10 Available View build log
2.1.9 Available View build log
2.1.8 Available View build log
2.1.7 Available View build log
2.1.5 Available View build log
2.1.4 Available View build log
2.1.3 Available View build log
2.1.2 Available View build log
2.1.1 Available View build log
2.0.9 Available View build log
2.0.8 Available View build log
2.0.7 Available View build log
2.0.6 Available View build log
2.0.4 Available View build log
2.0.2 Available View build log
2.0.0 Available View build log
 
Author
License
BSD
Lastest release
version 2.1.14 on Mar 7th, 2012

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'}],

System Message: WARNING/2 (<string>, line 32)

Definition list ends without a blank line; unexpected unindent.

'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.

Subscribe to package updates

Last updated Mar 7th, 2012

Download Stats

Last month:8

What does the lock icon mean?

Builds marked with a lock icon are only available via PyPM to users with a current ActivePython Business Edition subscription.

Need custom builds or support?

ActivePython Enterprise Edition guarantees priority access to technical support, indemnification, expert consulting and quality-assured language builds.

Plan on re-distributing ActivePython?

Get re-distribution rights and eliminate legal risks with ActivePython OEM Edition.