panodata / sphinx-sql-backend

SQL backend for the Sphinx documentation generator. The focus is fulltext search (FTS), but there may be more. [WIP]
Apache License 2.0
1 stars 0 forks source link

Add backend support for PostgreSQL [WIP] #2

Open amotl opened 9 months ago

amotl commented 9 months ago

About

Instead of using SQLite like the original package atsphinx-sqlite3fts, this patch explores how it can be made work to use other SQL databases which provide FTS features, like PostgreSQL with corresponding extensions, or CrateDB without further ado.

Details

Because this will not be able to pull off the same trick of embedding the SQLite database into the browser, accessing it through WASM, it will be far behind from a convenience standpoint, because it will also need to accompany a little backend service wrapping the search request.

Because our intention is to use the search-as-you-type UI widget readthedocs-sphinx-search, we will probably make it so that this little middleware service will be compatible, to make it easy to swap this in.