{ "info": { "author": "Simon Willison", "author_email": "", "bugtrack_url": null, "classifiers": [], "description": "# datasette-sqlite-fts4\n\n[![PyPI](https://img.shields.io/pypi/v/datasette-sqlite-fts4.svg)](https://pypi.org/project/datasette-sqlite-fts4/)\n[![License](https://img.shields.io/badge/license-Apache%202.0-blue.svg)](https://github.com/simonw/datasette-sqlite-fts4/blob/master/LICENSE)\n\n\nDatasette plugin that exposes the custom SQL functions from [sqlite-fts4](https://github.com/simonw/sqlite-fts4).\n\n[Interactive demo](https://datasette-sqlite-fts4.datasette.io/24ways-fts4?sql=select%0D%0A++++json_object%28%0D%0A++++++++\"label\"%2C+articles.title%2C+\"href\"%2C+articles.url%0D%0A++++%29+as+article%2C%0D%0A++++articles.author%2C%0D%0A++++rank_score%28matchinfo%28articles_fts%2C+\"pcx\"%29%29+as+score%2C%0D%0A++++rank_bm25%28matchinfo%28articles_fts%2C+\"pcnalx\"%29%29+as+bm25%2C%0D%0A++++json_object%28%0D%0A++++++++\"pre\"%2C+annotate_matchinfo%28matchinfo%28articles_fts%2C+\"pcxnalyb\"%29%2C+\"pcxnalyb\"%29%0D%0A++++%29+as+annotated_matchinfo%2C%0D%0A++++matchinfo%28articles_fts%2C+\"pcxnalyb\"%29+as+matchinfo%2C%0D%0A++++decode_matchinfo%28matchinfo%28articles_fts%2C+\"pcxnalyb\"%29%29+as+decoded_matchinfo%0D%0Afrom%0D%0A++++articles_fts+join+articles+on+articles.rowid+%3D+articles_fts.rowid%0D%0Awhere%0D%0A++++articles_fts+match+%3Asearch%0D%0Aorder+by+bm25&search=jquery+maps). Read [Exploring search relevance algorithms with SQLite](https://simonwillison.net/2019/Jan/7/exploring-search-relevance-algorithms-sqlite/) for further details on this project.\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/simonw/datasette-sqlite-fts4", "keywords": "", "license": "Apache License, Version 2.0", "maintainer": "", "maintainer_email": "", "name": "datasette-sqlite-fts4", "package_url": "https://pypi.org/project/datasette-sqlite-fts4/", "platform": "", "project_url": "https://pypi.org/project/datasette-sqlite-fts4/", "project_urls": { "Homepage": "https://github.com/simonw/datasette-sqlite-fts4" }, "release_url": "https://pypi.org/project/datasette-sqlite-fts4/0.3/", "requires_dist": [ "datasette", "sqlite-fts4" ], "requires_python": "", "summary": "Datasette plugin exposing SQL functions from sqlite-fts4", "version": "0.3" }, "last_serial": 4667270, "releases": { "0.1": [ { "comment_text": "", "digests": { "md5": "0f717cee670405706c8c25fb6a3cfceb", "sha256": "f456ba906c31457e7ca184e5a2229cec666e45dfb732f235e6701fb561f25d39" }, "downloads": -1, "filename": "datasette_sqlite_fts4-0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "0f717cee670405706c8c25fb6a3cfceb", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 1785, "upload_time": "2019-01-02T05:30:58", "url": "https://files.pythonhosted.org/packages/66/91/dee50bbbab02a0ab5d7ad3d17128f9d885de3377bf8d0ef26291bef857f7/datasette_sqlite_fts4-0.1-py3-none-any.whl" } ], "0.2": [ { "comment_text": "", "digests": { "md5": "ebc2b6b41896fa462f4bea996ab57b2b", "sha256": "19517afd3928f58b9e757df6f9d89f99e9e5a29e2470a8441abba58dc581f4e2" }, "downloads": -1, "filename": "datasette_sqlite_fts4-0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "ebc2b6b41896fa462f4bea996ab57b2b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 1779, "upload_time": "2019-01-02T16:28:13", "url": "https://files.pythonhosted.org/packages/d3/8a/e952641ac7048406e13c16c6662102bb22e72c5b3753b77a5c9f85346d7e/datasette_sqlite_fts4-0.2-py3-none-any.whl" } ], "0.3": [ { "comment_text": "", "digests": { "md5": "d52caea91ed19261f16175c5a1e380fe", "sha256": "4c4a4af1f411543762224761c35ec6c5cae60d96d3d40069e8b5e3dd60aabdfd" }, "downloads": -1, "filename": "datasette_sqlite_fts4-0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "d52caea91ed19261f16175c5a1e380fe", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6455, "upload_time": "2019-01-07T03:57:50", "url": "https://files.pythonhosted.org/packages/62/6e/cac2769f1acd74006d6450598f0bc5bbd1e90b585684cdcf801ddb9f4a77/datasette_sqlite_fts4-0.3-py3-none-any.whl" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "d52caea91ed19261f16175c5a1e380fe", "sha256": "4c4a4af1f411543762224761c35ec6c5cae60d96d3d40069e8b5e3dd60aabdfd" }, "downloads": -1, "filename": "datasette_sqlite_fts4-0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "d52caea91ed19261f16175c5a1e380fe", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6455, "upload_time": "2019-01-07T03:57:50", "url": "https://files.pythonhosted.org/packages/62/6e/cac2769f1acd74006d6450598f0bc5bbd1e90b585684cdcf801ddb9f4a77/datasette_sqlite_fts4-0.3-py3-none-any.whl" } ] }