Let's talk!
Clients
Services
Blog
About us
Careers
Let's talk!
SOFTWARE
HOUSE
Clients
Insights
Blog
Learnings
Careers
About us
Contact us
Learnings
Boost your knowledge with the insights from our expert team.
accessibility
accessibility
agile
agile
ai
ai
api
api
architecture
architecture
aws
aws
career
career
celery
celery
communication
communication
concurrency
concurrency
css
css
data
data
database
database
db
db
debug
debug
design
design
design system
design system
development
development
devops
devops
django
django
docker
docker
documentation
documentation
figma
figma
frontend
frontend
git
git
html
html
javascript
javascript
js
js
leadership
leadership
management
management
metrics
metrics
ml
ml
orm
orm
performance
performance
postgres
postgres
process
process
product
product
product design
product design
python
python
react
react
redux
redux
research
research
security
security
software
software
sql
sql
sre
sre
test
test
testing
testing
tests
tests
typescript
typescript
ui
ui
ux
ux
web
web
workflow
workflow
<p>PostgreSQL has a built-in module for removing accents from text </p>
↗
https://www.postgresql.org/docs/current/unaccent.html
Vitor Rangel
Jun 22, 2023
Topics:
postgres
<p>PostgreSQL has a built-in case insensitive text type </p>
↗
https://www.postgresql.org/docs/current/citext.html
Vitor Rangel
Jun 22, 2023
Topics:
postgres
<p>PostgreSQL Partitioning in Django: </p>
↗
https://pganalyze.com/blog/postgresql-partitioning-django
Rebeca Sarai
May 12, 2023
Topics:
django, postgres
<p>Index Selectivity: A Key to High Performance SQL </p>
↗
https://flexport.engineering/index-selectivity-a-key-to-high-performance-sql-b20eed3febd
Flavio Juvenal
May 8, 2023
Topics:
db, performance, postgres, sql
<p>Your Guide to Connection Management in Postgres </p>
↗
https://www.crunchydata.com/blog/your-guide-to-connection-management-in-postgres
Filipe Ximenes
Jan 10, 2023
Topics:
postgres
<p>In Postgres, "empty updates" have the same cost per row as any other update. Even if the values won't change after the <code>UPDATE</code>, the operation will still have the same performance: </p>
↗
https://dba.stackexchange.com/q/118178/139133
Flavio Juvenal
Dec 5, 2022
Topics:
orm, performance, postgres
<p>Django needs a <code>GinIndex</code> with <code>OpClass</code> + <code>Upper</code> to support fast queries with the <code>icontains</code> operator: </p>
↗
https://stackoverflow.com/a/51880653/145349
Flavio Juvenal
Oct 28, 2022
Topics:
db, django, index, postgres
<p>In Postgres, <code>COUNT(*)</code> vs. <code>COUNT(id)</code> is a non-issue: </p>
↗
https://www.cybertec-postgresql.com/en/postgresql-count-made-fast/
Flavio Juvenal
Aug 24, 2022
Topics:
db, postgres, sql
<p>How to estimate the size of one column in a Postgres table? </p>
↗
https://stackoverflow.com/questions/18316893/how-to-estimate-the-size-of-one-column-in-a-postgres-table/
Flavio Juvenal
Jun 23, 2022
Topics:
db, postgres
<p>Common DB schema change mistakes: </p>
↗
https://postgres.ai/blog/20220525-common-db-schema-change-mistakes
Rebeca Sarai
Jun 7, 2022
Topics:
db, postgres
<p>Thin clones of PostgreSQL to build powerful development, test, and QA envs. Cloning a 1 TiB PostgreSQL database takes ~10 seconds: </p>
↗
https://github.com/postgres-ai/database-lab-engine
Rebeca Sarai
Jun 7, 2022
Topics:
cd, db, postgres
<p>How percentile approximation works (and why it's more useful than averages) </p>
↗
https://www.timescale.com/blog/how-percentile-approximation-works-and-why-its-more-useful-than-averages/
Flavio Juvenal
May 25, 2022
Topics:
db, kpi, metric, postgres, statistics
<p>Beekeeper Studio - Open Source SQL Editor and Database Manager </p>
↗
https://www.beekeeperstudio.io/
Fellipe Souto
Apr 5, 2022
Topics:
database, postgres, sgbd
<p>Postgres Auditing in 150 lines of SQL: </p>
↗
https://supabase.com/blog/2022/03/08/audit
Rebeca Sarai
Mar 14, 2022
Topics:
postgres, sql
<p>Using a Replica Router in Django to read your own writes - Scaling Django with Postgres Read Replicas: </p>
↗
https://andrewbrookins.com/python/scaling-django-with-postgres-read-replicas/
Flavio Juvenal
Mar 11, 2022
Topics:
django, postgres, replica, scaling
<p>How can I cast a DateField() + TimeField() to local time in a Django QuerySet? </p>
↗
https://stackoverflow.com/questions/69260536/how-can-i-cast-a-datefield-timefield-to-local-time-in-a-django-queryset
Flavio Juvenal
Mar 7, 2022
Topics:
datetime, django, orm, postgres, timezone
<p>PostgreSQL-based Task Queue for Python: </p>
↗
https://github.com/procrastinate-org/procrastinate
Flavio Juvenal
Feb 4, 2022
Topics:
postgres, queue
<p>PostgreSQL Anonymizer: </p>
↗
https://postgresql-anonymizer.readthedocs.io/en/latest/
Flavio Juvenal
Dec 28, 2021
Topics:
db, postgres
<p>Join strategies and performance in PostgreSQL: </p>
↗
https://www.cybertec-postgresql.com/en/join-strategies-and-performance-in-postgresql/
Flavio Juvenal
Nov 24, 2021
Topics:
postgres, sql
<p>5 ways to host PostgreSQL databases: </p>
↗
https://www.prisma.io/dataguide/postgresql/5-ways-to-host-postgresql
Flavio Juvenal
Nov 24, 2021
Topics:
cloud, db, postgres, sql
<p>Optimizing Pattern Searching Queries in PostgreSQL: </p>
↗
https://medium.com/@paramsingh96/optimizing-pattern-searching-queries-in-postgresql-84087d9bac8c
Flavio Juvenal
Oct 27, 2021
Topics:
postgres, sql
<p>Don't Do This in Postgres: </p>
↗
https://wiki.postgresql.org/wiki/Don%27t_Do_This
Flavio Juvenal
Oct 13, 2021
Topics:
db, postgres
<p>Finding and killing long running queries on PostgreSQL </p>
↗
https://medium.com/little-programming-joys/finding-and-killing-long-running-queries-on-postgres-7c4f0449e86d
Andre Carneiro
Oct 13, 2021
Topics:
postgres
<p>Use "identity columns" instead of serial type in Postgres > 10: </p>
↗
https://www.2ndquadrant.com/en/blog/postgresql-10-identity-columns/
Flavio Juvenal
Oct 13, 2021
Topics:
db, postgres, sql
Next
Close Cookie Preference Manager
Cookie Settings
By clicking “Accept all”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage and assist in our marketing efforts.
Check our privacy policies.
Strictly Necessary (Always Active)
Cookies required to enable basic website functionality.
Analytics
Cookies helping understand how this website performs, how visitors interact with the site, and whether there may be technical issues.
Marketing
Cookies used to deliver advertising that is more relevant to you and your interests.
Personalization
Cookies allowing the website to remember choices you make (such as your user name, language, or the region you are in).
Save settings
Accept all
We use Cookies to promote our services.
Settings and Privacy.
Accept