search

only-cliches / Nano-SQL

Universal database layer for the client, server & mobile devices. It's like Lego for databases.
https://nanosql.io
MIT License
783 stars 51 forks source link

Sqlite search index #114

Open bkniffler opened 5 years ago

bkniffler commented 5 years ago

Is your feature request related to a problem? Please describe. I know you're planing to add fuzzy search through custom indexes. Sqlite has build in search indexes (FTS5) that run pretty efficiently and have scoring, highlighting, .... I'm not sure if a custom index could really ver compete with the build in one, so maybe allowing to use the native one would be pretty handy?

Describe the solution you'd like A way to add to table schema a native fts5 index and a query method to query that index.

Additional context https://sqlite.org/fts5.html

only-cliches commented 5 years ago

Wow, really good read. Provided some solid ideas for when the new search plugin is setup.

I think this is a good use case for an external plugin, something that you can add on top of any SQLite adapter provided the underlying SQLite has been compiled with this extension.

I'll mark this as an enhancement and add it to the development list. Keep in mind there's lots of stuff ahead of it so likely won't be able to put these features in place for a while.

bkniffler commented 5 years ago

Maybe you are right and a plugin would be better for this. I'm currently evaluating nano-sql for my app, if I decide to use it I'd give the plugin a shot. Unfortunately the syncing is a hard requirement for me, but I know you're currently trying to tick this off the list. Is there any ETA?

I really like nano-sql and the fact that you can add features so fast really vouches to the code quality, so great job on that.

I'd just recommend getting compiled js files out of the repository, they are making commits hard to understand and super cluttered.

only-cliches commented 5 years ago

Hey thanks for all the feedback, very helpful!

At this rate I'd expect the offline syncing to be done around the end of February.