SQlite3 full-text-search and some python on OSX
I did not know but it seems that the cool little sqlite3 mini-database engine had a full-text search application built into it. Unfortunately Apple (as usual) seems not too inclined on having it enabled (at least not in OSX Leopard 10.5.x).
What I read about it - it seems that it’s quite fast and usable for some purposes.
Some links first:
FTS usage in Sqlite3 in sqlite trac
Some performance and usage info on sqlite FTS3 from dotnetpearls
Enabling full text search on sqlite / Python 2.5 bundled with OSX (Leopard)
This last link gave me some ideas. I was wondering how I could make use of this small fulltext-search engine in django. I like django, and currently learning it, so that’s the reason behind.
Some links on enabling django to use sqlite full-text search:
fulltext search in sqlite and django using django’s signals
I highly recommend the above links regarding django / python to anyone interested in those subjects as well. Very useful ideas can be found there thanks to Piotr. Appreciated.
Recent Comments