Let's talk!
Clients
Services
Blog
About us
Careers
Let's talk!
SOFTWARE
HOUSE
Clients
Services
MVP Development
Web Development
Staff Augmentation
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>Kysely is a type safe query builder for Typescript, a great companion for Prisma (With <em>prisma-kysely</em> integration) </p>
↗
https://kysely.dev/
Vitor Rangel
Jun 27, 2023
Topics:
sql, typescript
<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>Django - filter(A).filter(B) vs filter(A, B) </p>
↗
https://www.hacksoft.io/blog/django-filter-chaining
Renato Vieira
Jan 18, 2023
Topics:
django, sql
<p>An alternative to soft_deleted_at is to create a table that will be auto populated with deleted records </p>
↗
https://brandur.org/fragments/deleted-record-insert
Vitor Rangel
Jan 11, 2023
Topics:
database, sql
<p>Cheatsheet to grouping queries in Django </p>
↗
https://hakibenita.com/django-group-by-sql
Tulio Lages
Jan 5, 2023
Topics:
db, django, haki, sql
<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>Using window functions on Django ORM </p>
↗
https://stackoverflow.com/a/49237664/7391355
Renato Vieira
Jul 7, 2022
Topics:
django, orm, sql
<p>django-pgtrigger provides primitives for configuring Postgres triggers on Django models without raw SQL in many cases: </p>
↗
https://github.com/Opus10/django-pgtrigger
Flavio Juvenal
Jun 13, 2022
Topics:
django, orm, sql, trigger
<p>You Are Doing SQL Pagination Wrong </p>
↗
https://betterprogramming.pub/you-are-doing-sql-pagination-wrong-739a700acbd0
Marcilio Leite
May 23, 2022
Topics:
optimization, performance, sql
<p>django-raw-sugar: Turns your raw SQL into a QuerySet. </p>
↗
https://github.com/zxibizz/django-raw-sugar
Flavio Juvenal
Mar 25, 2022
Topics:
django, orm, performance, queryset, sql
<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>Does the join order matter in SQL? </p>
↗
https://stackoverflow.com/questions/9614922/does-the-join-order-matter-in-sql
Flavio Juvenal
Feb 22, 2022
Topics:
sql
<p>Short explanation of the issues faced when trying to create a PostgreSQL index using the date() function and how to resolve it. </p>
↗
https://gist.github.com/cobusc/5875282
Gabriela Cavalcante
Feb 8, 2022
Topics:
postgresql, sql
<p>Context Manager to launch exceptions when Django makes unexpected queries to ensure explicit control over DB overhead: </p>
↗
https://github.com/dabapps/django-zen-queries
Flavio Juvenal
Nov 25, 2021
Topics:
database, db, django, performance, sql
<p>How not to structure your database-backed web applications: a study of performance bugs in the wild - </p>
↗
https://blog.acolyer.org/2018/06/28/how-_not_-to-structure-your-database-backed-web-applications-a-study-of-performance-bugs-in-the-wild/
Flavio Juvenal
Nov 25, 2021
Topics:
db, orm, performance, sql
<p>How to Create an Index in Django Without Downtime: </p>
↗
https://realpython.com/create-django-index-without-downtime/
Flavio Juvenal
Nov 24, 2021
Topics:
django, downtime, index, postgresql, sql
<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>Optimizing the Django Admin Paginator: </p>
↗
https://hakibenita.com/optimizing-the-django-admin-paginator
Flavio Juvenal
Nov 24, 2021
Topics:
admin, db, django, 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>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
<p>SQLBolt – Interactive lessons and exercises to learn SQL: </p>
↗
https://sqlbolt.com/
Rebeca Sarai
Jul 15, 2021
Topics:
sql
<p>Scaling Relational SQL Databases: </p>
↗
https://news.ycombinator.com/item?id=27505267
Rebeca Sarai
Jun 16, 2021
Topics:
postgres, sql
<p>pgbarman - taking an online hot backup of PostgreSQL is now as easy as ordering a good espresso coffee: </p>
↗
https://www.pgbarman.org/
Flavio Juvenal
Jun 3, 2021
Topics:
backup, 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