Simon Willison’s Weblog

Subscribe

Items tagged projects, search in 2017

Filters: Year: 2017 × projects × search × Sorted by date


New in Datasette: filters, foreign keys and search

I’ve released Datasette 0.13 with a number of exciting new features (Datasette previously).

[... 1143 words]

9:17 pm / 25th November 2017 / csv, projects, search, sqlite, datasette

Implementing faceted search with Django and PostgreSQL

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:

[... 3103 words]

2:12 pm / 5th October 2017 / django, fulltextsearch, orm, postgresql, projects, search, facetedsearch

Types

Years

Months

Tags