stackoverflow.com
How can I cast a DateField() + TimeField() to local time in a Django QuerySet?
Flavio Juvenal
Lessons about PostgreSQL (page 2)
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
Tech Insights· stackoverflow.com
How can I cast a DateField() + TimeField() to local time in a Django QuerySet?
Shared by
Read on stackoverflow.com- Datetime
- Django
- ORM
- PostgreSQL
- Timezone
Tech Insights· github.com
PostgreSQL-based Task Queue for Python:
Shared by
Read on github.com- PostgreSQL
- Queue
Tech Insights· postgresql-anonymizer.readthedocs.io
PostgreSQL Anonymizer:
- DB
- PostgreSQL
prisma.io
5 ways to host PostgreSQL databases:
Compare PostgreSQL hosting options — self-managed, Docker, cloud-provider managed like AWS RDS, and fully managed Prisma Postgres — with a decision table, a "when to choose" guide, and an FAQ to help you pick the right one.
Flavio Juvenal
Tech Insights· prisma.io
5 ways to host PostgreSQL databases:
From prisma.io
Compare PostgreSQL hosting options — self-managed, Docker, cloud-provider managed like AWS RDS, and fully managed Prisma Postgres — with a decision table, a "when to choose" guide, and an FAQ to help you pick the right one.
Shared by
Read on prisma.io- Cloud
- DB
- PostgreSQL
- SQL
Tech Insights· cybertec-postgresql.com
Join strategies and performance in PostgreSQL:
Shared by
Read on cybertec-postgresql.com- PostgreSQL
- SQL
Tech Insights· medium.com
Optimizing Pattern Searching Queries in PostgreSQL:
Shared by
Read on medium.com- PostgreSQL
- SQL
Tech Insights· wiki.postgresql.org
Don't Do This in Postgres:
Shared by
Read on wiki.postgresql.org- DB
- PostgreSQL
Tech Insights· medium.com
Finding and killing long running queries on PostgreSQL
Shared by
Read on medium.com- PostgreSQL
2ndquadrant.com
Use "identity columns" instead of serial type in Postgres > 10:
Experience zero data sprawl with EDB Postgres AI. Capable of handling 30B+ trades a day and managing 50 TB.
Flavio Juvenal
Tech Insights· 2ndquadrant.com
Use "identity columns" instead of serial type in Postgres > 10:
From 2ndquadrant.com
Experience zero data sprawl with EDB Postgres AI. Capable of handling 30B+ trades a day and managing 50 TB.
Shared by
Read on 2ndquadrant.com- DB
- PostgreSQL
- SQL
notion.so
Herding elephants: Lessons learned from sharding Postgres at Notion:
With an effort to make Notion faster and more reliable for years to come — we migrated Notion’s PostgreSQL monolith into a horizontally-partitioned database fleet.
Rebeca Sarai
Tech Insights· notion.so
Herding elephants: Lessons learned from sharding Postgres at Notion:
From notion.so
With an effort to make Notion faster and more reliable for years to come — we migrated Notion’s PostgreSQL monolith into a horizontally-partitioned database fleet.
Shared by
Read on notion.so- PostgreSQL
blog.crunchydata.com
Cut Out the Middle Tier: Generating JSON Directly from Postgres -
PostgreSQL has built-in JSON generators that can be used to create structured JSON output right in the database, upping performance and radically simplifying web tiers.
Flavio Juvenal
Tech Insights· blog.crunchydata.com
Cut Out the Middle Tier: Generating JSON Directly from Postgres -
From blog.crunchydata.com
PostgreSQL has built-in JSON generators that can be used to create structured JSON output right in the database, upping performance and radically simplifying web tiers.
Shared by
Read on blog.crunchydata.com- Json
- PostgreSQL
Tech Insights· hakibenita.com
Re-Introducing Hash Indexes in PostgreSQL
Shared by
Read on hakibenita.com- PostgreSQL
- Link offlineLink offline
Tech Insights· engineering.theblueground.com
Zero downtime Postgres migration, done right
Shared by
The original link on engineering.theblueground.com is no longer available.
Look for it on the Wayback Machine- PostgreSQL
Tech Insights· news.ycombinator.com
Scaling Relational SQL Databases:
Shared by
Read on news.ycombinator.com- PostgreSQL
- SQL
gitlab.com
postgres-checkup – automated PostgreSQL health checks:
⚠️ ARCHIVED: This project is no longer maintained. See successor: npx postgresai checkup
Flavio Juvenal
Tech Insights· gitlab.com
postgres-checkup – automated PostgreSQL health checks:
From gitlab.com
⚠️ ARCHIVED: This project is no longer maintained. See successor: npx postgresai checkup
Shared by
Read on gitlab.com- DB
- Performance
- PostgreSQL
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
