Lessons about DB (page 5)

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

lessons shared: 68
people sharing: 8
database started in: 2017

blog.heapanalytics.com
Postgres DB-level for-each with LATERAL:
This post walks through a conversion funnel analysis that wouldn’t be possible in PostgreSQL 9.2
Flávio JuvenalJanuary 12, 2018
dba.stackexchange.com
Order of columns in a compound index in PostgreSQL (and query order):
Flávio JuvenalDecember 14, 2017
blog.codinghorror.com
Primary Keys: IDs versus GUIDs
Long-time readers of this blog know that I have an inordinate fondness for GUIDs. Each globally unique ID is like a beautiful snowflake: every one a unique item waiting to be born. Perhaps that’s why I read with great interest recent accounts of people switching their database tables
Flávio JuvenalDecember 14, 2017
Today I learned
Django will store your dates in UTC if you set USE_TZ=True
Anderson ResendeNovember 11, 2017
github.com
django-eraserhead: Django package that provides hints to optimize database usage by deferring unused fields (and more)
💂🏻 Django package that provides hints to optimize database usage by deferring unused fields (and more) - dizballanze/django-eraserhead
Flávio JuvenalAugust 20, 2017
docs.djangoproject.com
Django 1.11 Subquery expressions: #subquery-expressions
Flávio JuvenalJune 20, 2017
rachbelaid.com
Postgres full-text search is Good Enough!
Flávio JuvenalApril 27, 2017
lukeplant.me.uk
Avoid Django's GenericForeignKey:
Flávio JuvenalMarch 27, 2017

Book a call

Found it useful?
Let’s put it to work.

Tell us about your product and the problem in front of you. We’ll bring what we’ve learned on real projects.

Tell us about your product, and we’ll bring what we’ve learned.

Still prefer the good old email? Contact us

Book a call