Simon Willison’s Weblog

Subscribe

Entries tagged projects in 2017

Filters: Type: entry × Year: 2017 × projects × 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

Datasette: instantly create and publish an API for your SQLite databases

I just shipped the first public version of datasette, a new tool for creating and publishing JSON APIs for SQLite databases.

[... 968 words]

11:49 pm / 13th November 2017 / apis, json, projects, sqlite, webapis, sanic, docker, 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