I’ve added a faceted search engine to this blog, powered by PostgreSQL. It supports regular text search (proper search, not just SQL”like” queries), filter by tag, filter by date, filter by content type (entries vs blogmarks vs quotation) and any combination of the above. Some example searches:
- All content matching “postgresql”
- Just quotations matching “django”
- All content matching “python” and “javascript” with the tag “mozilla” posted in 2007
It also provides facet counts, so you can tell how many results you will get back before you apply one of these filters – and get a general feeling for the shape of the corpus as you navigate it.