{ "info": { "author": "Chris Dent", "author_email": "cdent@peermore.com", "bugtrack_url": null, "classifiers": [], "description": "tiddlywebplugins.mysql3\n=======================\n\n_A plugin for [TiddlyWeb](http://tiddlyweb.com) subclassing\n[tiddlywebplugins.sqlalchemy3](https://github.com/cdent/tiddlywebplugins.sqlalchemy)\nwith MySQL specifics._\n\nThe main additions to sqlalchemy3 are:\n\n* Optionally extend the search interface using mysql's fulltext.\n* Support finding tiddlers that have geo.lat and geo.long fields\n near a location.\n\nSetup\n-----\n\nMySQL 5.5 or beyond is required for full Unicode support.\n\nIt is important to set some mysql my.cnf variables if you are using\nthe fulltext indexing otherwise searches will likely fail.\n\n```\n[mysqld]\nft_min_word_len = 3\nft_stopword_file = ''\n```\n\nYou will need to create a database:\n\n```\ncreate database tiddlyweb character set = utf8mb4 collate = utf8mb4_bin;\n```\n\nMake sure you `GRANT` appropriate `PRIVILEGES` on the database.\n\nAdd the following to `tiddlywebconfig.py`:\n\n```\n'server_store': ['tiddlywebplugins.mysql', {\n 'db_config': 'mysql:///tiddlyweb?charset=utf8mb4'}],\n'indexer': 'tiddlywebplugins.mysql', # optional\n```\n\nIf you want to use the fulltext indexing capability you will need to\ncreate the fulltext index:\n\n```\nCREATE FULLTEXT INDEX tiddlytext ON text(text);\n```\n\nAlso set `mysql.fulltext` to `True` in `tiddlywebconfig.py`. This makes\nsure the text table will be `MyISAM`.\n\nNote that even if fulltext is not turned on, text searches will still\nwork, but not as flexibly.\n\nSee for additional documentation and\nassistance.\n\nThanks\n------\n\nThanks to [Adrian Hosey](http://adrianhosey.blogspot.com/) for help over\nsome SQL humps.", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://pypi.python.org/pypi/tiddlywebplugins.mysql3", "keywords": null, "license": "BSD", "maintainer": null, "maintainer_email": null, "name": "tiddlywebplugins.mysql3", "package_url": "https://pypi.org/project/tiddlywebplugins.mysql3/", "platform": "Posix; MacOS X; Windows", "project_url": "https://pypi.org/project/tiddlywebplugins.mysql3/", "project_urls": { "Download": "UNKNOWN", "Homepage": "http://pypi.python.org/pypi/tiddlywebplugins.mysql3" }, "release_url": "https://pypi.org/project/tiddlywebplugins.mysql3/3.1.2/", "requires_dist": null, "requires_python": null, "summary": "MySQL-based store for tiddlyweb", "version": "3.1.2" }, "last_serial": 1009233, "releases": { "3.0.0": [ { "comment_text": "", "digests": { "md5": "fb2ab314f8bfdd1cd4723165028d6a68", "sha256": "cc5730192b351c4424bdca801407e185f3d64c3e7679d23882ba08d1c95a4bcb" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.0.0.tar.gz", "has_sig": false, "md5_digest": "fb2ab314f8bfdd1cd4723165028d6a68", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 19618, "upload_time": "2012-03-06T14:31:20", "url": "https://files.pythonhosted.org/packages/a5/bb/fa8ca1f0d5f5b65b99b468d69005f768513bd3bbe08f692e83456639a32b/tiddlywebplugins.mysql3-3.0.0.tar.gz" } ], "3.0.1": [ { "comment_text": "", "digests": { "md5": "87a579dd8a8c4220130c1d8bea8286f3", "sha256": "77fb33acf6c038269aad77eb12def3e2d4901f8ba8ab48c007fb6d191e6a0232" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.0.1.tar.gz", "has_sig": false, "md5_digest": "87a579dd8a8c4220130c1d8bea8286f3", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 20419, "upload_time": "2012-03-27T16:04:29", "url": "https://files.pythonhosted.org/packages/91/0b/ffd2d245bc68512f2a42b7de2640eda6be9ce73813c23e431268633c17ca/tiddlywebplugins.mysql3-3.0.1.tar.gz" } ], "3.0.10": [ { "comment_text": "", "digests": { "md5": "38a33241971821dd9d3c95c5f7a04bf4", "sha256": "39c526599f9eb6e82e45a98d545c71009dc4cc1a8450fe3cd1e2eaea659147fe" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.0.10.tar.gz", "has_sig": false, "md5_digest": "38a33241971821dd9d3c95c5f7a04bf4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 31262, "upload_time": "2013-03-05T16:15:03", "url": "https://files.pythonhosted.org/packages/f3/d5/1c6e20bb84899b1d0619eacdbb6070ec9ea57adf1e7bbbf576662a5836dd/tiddlywebplugins.mysql3-3.0.10.tar.gz" } ], "3.0.11": [ { "comment_text": "", "digests": { "md5": "78c1ca931487d5e3fd3bc36bf2778e04", "sha256": "f8712687ed0e2063a025e6dfdf0ab45a06ad2b9c22f1f45110892accb6e945ba" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.0.11.tar.gz", "has_sig": false, "md5_digest": "78c1ca931487d5e3fd3bc36bf2778e04", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 32779, "upload_time": "2013-04-19T08:15:58", "url": "https://files.pythonhosted.org/packages/c1/88/92f81a4d9d3aeecd9d67695ab506946292c9486086b1df9f32cc744f162b/tiddlywebplugins.mysql3-3.0.11.tar.gz" } ], "3.0.12": [ { "comment_text": "", "digests": { "md5": "83a4eef32887610b5d986c9effc27a68", "sha256": "d0fe827a07ffddbc09387abfe1f2beeec873dd269d0461c0d2f5f97a52fd5188" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.0.12.tar.gz", "has_sig": false, "md5_digest": "83a4eef32887610b5d986c9effc27a68", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 32936, "upload_time": "2013-06-25T11:36:16", "url": "https://files.pythonhosted.org/packages/08/80/13a79391bd8966828ce5a1c7ab5242de0f79bc5d5ff506f4a3e52ab4349d/tiddlywebplugins.mysql3-3.0.12.tar.gz" } ], "3.0.13": [ { "comment_text": "", "digests": { "md5": "7f9406c3bb13e82527545417a187809a", "sha256": "bf6d739b3d1e591cd8dd654b052e22f481082d1b3d912872473d469f8df505af" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.0.13.tar.gz", "has_sig": false, "md5_digest": "7f9406c3bb13e82527545417a187809a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 33555, "upload_time": "2013-07-16T13:19:19", "url": "https://files.pythonhosted.org/packages/09/33/26d57bfa6d1f61b542d24742398fc5a69f6a21ba9e6a8edbadf058f6fdbc/tiddlywebplugins.mysql3-3.0.13.tar.gz" } ], "3.0.2": [ { "comment_text": "", "digests": { "md5": "8c5b87869c4631e914e571eb8708e875", "sha256": "7593cde8336740a818def2b0d5aae3717e8bffc62a0c592276beaffd48e9802f" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.0.2.tar.gz", "has_sig": false, "md5_digest": "8c5b87869c4631e914e571eb8708e875", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 20945, "upload_time": "2012-06-21T17:05:38", "url": "https://files.pythonhosted.org/packages/54/8c/8ff147002edddeda157fea63efd2f42ff58185685427b20d774f4349ea7b/tiddlywebplugins.mysql3-3.0.2.tar.gz" } ], "3.0.3": [ { "comment_text": "", "digests": { "md5": "0053ecd2affa2b7e289032ec1593aa2d", "sha256": "ea51bc2df8b35d69b05d331c145ebb00a5afb1e2edca9c010c8cbd5ef4321608" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.0.3.tar.gz", "has_sig": false, "md5_digest": "0053ecd2affa2b7e289032ec1593aa2d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 20913, "upload_time": "2012-06-21T17:17:14", "url": "https://files.pythonhosted.org/packages/ea/5f/989cf09f58051ac6355391c094d745c46f31e4a8c527206a167a2111abde/tiddlywebplugins.mysql3-3.0.3.tar.gz" } ], "3.0.4": [ { "comment_text": "", "digests": { "md5": "bddc8b0e7148752c231d11d10aedbca0", "sha256": "bcca24769552742c6572c80e3f3af02849a62c2ec08cb2a8815856149b58f299" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.0.4.tar.gz", "has_sig": false, "md5_digest": "bddc8b0e7148752c231d11d10aedbca0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 21058, "upload_time": "2012-07-03T17:52:37", "url": "https://files.pythonhosted.org/packages/57/ec/84b636ce931390d084585596f3a2fb7ed4c1c67518bfaa59c2c500aad7c9/tiddlywebplugins.mysql3-3.0.4.tar.gz" } ], "3.0.5": [ { "comment_text": "", "digests": { "md5": "46e696838e45c81763a35d1ea35f5305", "sha256": "0b84fbaf874e2abc9ad893011fe80c43696bb3bc3343b4109ef5555316a3bb34" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.0.5.tar.gz", "has_sig": false, "md5_digest": "46e696838e45c81763a35d1ea35f5305", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 21688, "upload_time": "2012-07-18T22:46:16", "url": "https://files.pythonhosted.org/packages/5f/e0/0edd8a02fc5362a6d04b0dd15e8e98c42143ec5f388a6d06e67f5ed22616/tiddlywebplugins.mysql3-3.0.5.tar.gz" } ], "3.0.6": [ { "comment_text": "", "digests": { "md5": "e098acbdcdf08edd8eec8674ba4d81d0", "sha256": "533dc4323bfd5d468101e194a12842160cfedefb1ecfd4a4f89fd5139e319375" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.0.6.tar.gz", "has_sig": false, "md5_digest": "e098acbdcdf08edd8eec8674ba4d81d0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 30076, "upload_time": "2012-12-13T17:26:39", "url": "https://files.pythonhosted.org/packages/63/c1/5edc58d7358dbd49844594ef1115f78e2fa6b9c0629a4847c92aff7270d6/tiddlywebplugins.mysql3-3.0.6.tar.gz" } ], "3.0.7": [ { "comment_text": "", "digests": { "md5": "8cbdfb503c94f93bac3a0bd3065e3887", "sha256": "cd4c02194aa491e01802dc9b2064a69a98d2e4c6553c192997e794ac16cd3bef" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.0.7.tar.gz", "has_sig": false, "md5_digest": "8cbdfb503c94f93bac3a0bd3065e3887", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 30176, "upload_time": "2012-12-15T02:03:39", "url": "https://files.pythonhosted.org/packages/93/31/b46df1cd1248bff48c734ac27ae3c9ba33b06764223107dbe3701efa4829/tiddlywebplugins.mysql3-3.0.7.tar.gz" } ], "3.0.8": [ { "comment_text": "", "digests": { "md5": "b1ed758ae032851d9e713b662a10b6df", "sha256": "780c0f06d10661052fe772ac7c8571db1cd509580bf4cdb754eb50ef9d379c57" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.0.8.tar.gz", "has_sig": false, "md5_digest": "b1ed758ae032851d9e713b662a10b6df", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 31188, "upload_time": "2012-12-16T18:13:21", "url": "https://files.pythonhosted.org/packages/4c/89/7a1bbb42b04f7770281836baacd5e43e61ce9cbf12107c68cabf178a2b2f/tiddlywebplugins.mysql3-3.0.8.tar.gz" } ], "3.0.9": [ { "comment_text": "", "digests": { "md5": "569f8edaaa863db87b1837acc81a3006", "sha256": "928bde0aaebc766f7e651b7adeb892aebbe7ba6489688f7453d3dd8043d7ba42" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.0.9.tar.gz", "has_sig": false, "md5_digest": "569f8edaaa863db87b1837acc81a3006", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 31230, "upload_time": "2013-01-29T15:06:17", "url": "https://files.pythonhosted.org/packages/f1/a5/00d7b44432b171ea6559eb2330504544c291416ec0137b633b2e8a5f045d/tiddlywebplugins.mysql3-3.0.9.tar.gz" } ], "3.1.0": [ { "comment_text": "", "digests": { "md5": "72b2f76f3484fae78863311e971aeb6d", "sha256": "33e8de9a1b1ce896e87d91d4dfdde130cb184330aa172c01152f94779e5418f5" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.1.0.tar.gz", "has_sig": false, "md5_digest": "72b2f76f3484fae78863311e971aeb6d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 29972, "upload_time": "2013-08-14T14:46:51", "url": "https://files.pythonhosted.org/packages/2f/c7/9f1bc512f3ec40dce8c21b59648de6bb1e6a396183bc13203bfccb72a995/tiddlywebplugins.mysql3-3.1.0.tar.gz" } ], "3.1.1": [ { "comment_text": "", "digests": { "md5": "9c3ae9c22960712b525419ec85005800", "sha256": "42db3a0a76df3d57982c442f919f57962f0777d698a4780dcfa3899a4ec93339" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.1.1.tar.gz", "has_sig": false, "md5_digest": "9c3ae9c22960712b525419ec85005800", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 29952, "upload_time": "2013-08-26T14:46:59", "url": "https://files.pythonhosted.org/packages/b5/cc/24984aa8fd54ad6fdc1b7dbb046a26ac0e2f9368ccd40f7ed4b2bdd9d054/tiddlywebplugins.mysql3-3.1.1.tar.gz" } ], "3.1.2": [ { "comment_text": "", "digests": { "md5": "cf4e3cd2e80c3b8203ca786ff05b436b", "sha256": "e38fb265a3557be33372b5c5b22330cb1f59bdf14105e44ec5531ec3310e3c34" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.1.2.tar.gz", "has_sig": false, "md5_digest": "cf4e3cd2e80c3b8203ca786ff05b436b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 29900, "upload_time": "2014-02-23T16:00:09", "url": "https://files.pythonhosted.org/packages/54/f5/4023b9be7fa23a04d5598046262f2bc5b3549d11d7023f23507e12319146/tiddlywebplugins.mysql3-3.1.2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "cf4e3cd2e80c3b8203ca786ff05b436b", "sha256": "e38fb265a3557be33372b5c5b22330cb1f59bdf14105e44ec5531ec3310e3c34" }, "downloads": -1, "filename": "tiddlywebplugins.mysql3-3.1.2.tar.gz", "has_sig": false, "md5_digest": "cf4e3cd2e80c3b8203ca786ff05b436b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 29900, "upload_time": "2014-02-23T16:00:09", "url": "https://files.pythonhosted.org/packages/54/f5/4023b9be7fa23a04d5598046262f2bc5b3549d11d7023f23507e12319146/tiddlywebplugins.mysql3-3.1.2.tar.gz" } ] }