Lessons about PostgreSQL (page 6)

The links, tools and tips our engineers and designers share with each other, one “today I learned” at a time.

lessons shared: 83
people sharing: 13
database started in: 2017

dba.stackexchange.com
Show size of various PostgreSQL objects like indexes, materialized views, tables, etc:
Flávio JuvenalNovember 23, 2017
github.com
Use django-postgres-extra for native upserts, more powerful HStoreField, more signals and indexes with conditions:
Bringing all of PostgreSQL's awesomeness to Django. - SectorLabs/django-postgres-extra
Flávio JuvenalNovember 16, 2017
niwi.nz
Show database, table and indexes size in Postgres:
Flávio JuvenalNovember 3, 2017
github.com
Postgres SQL Views in Django:
Fork of django-postgres that focuses on maintaining and improving support for Postgres SQL Views. - mypebble/django-pgviews
Flávio JuvenalNovember 2, 2017
simonwillison.net
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 …
Flávio JuvenalOctober 23, 2017
hynek.me
Easily make Django connect to Postgres using SSL
I’d thought something like this is a FAQ but the database docs on postgres don’t write a bit about forcing Django to connect using SSL to the database server.
Carlos CoelhoMay 17, 2017
blog.lotech.org
Add Postgres full-text searching to your Django application
Django has added support for Postgres's built-in full-text searching as of version 1.10. This is a great alternative to a heavier search system such as elasticsearch or SOLR, when we want decent search capabilities without having to setup and maintain another service. Postgres's full-text search is Good Enough for …
Carlos CoelhoMay 11, 2017
rachbelaid.com
Postgres full-text search is Good Enough!
Flávio JuvenalApril 27, 2017