Lessons about SQL (page 2)
The links, tools and tips our engineers and designers share with each other, one “today I learned” at a time.
- lessons shared
- 46
- people sharing
- 11
- database started in
- 2017
Tech Insights· cybertec-postgresql.com
Join strategies and performance in PostgreSQL:
Shared by
Read on cybertec-postgresql.com- PostgreSQL
- SQL
Tech Insights· hakibenita.com
Optimizing the Django Admin Paginator:
Shared by
Read on hakibenita.com- Admin
- DB
- Django
- SQL
Tech Insights· medium.com
Optimizing Pattern Searching Queries in PostgreSQL:
Shared by
Read on medium.com- PostgreSQL
- SQL
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
sqlbolt.com
SQLBolt – Interactive lessons and exercises to learn SQL:
SQLBolt provides a set of interactive lessons and exercises to help you learn SQL
Rebeca Sarai
Tech Insights· sqlbolt.com
SQLBolt – Interactive lessons and exercises to learn SQL:
From sqlbolt.com
SQLBolt provides a set of interactive lessons and exercises to help you learn SQL
Shared by
Read on sqlbolt.com- SQL
Tech Insights· news.ycombinator.com
Scaling Relational SQL Databases:
Shared by
Read on news.ycombinator.com- PostgreSQL
- SQL
pgbarman.org
pgbarman - taking an online hot backup of PostgreSQL is now as easy as ordering a good espresso coffee:
Allows your company to implement disaster recovery solutions for PostgreSQL databases with high requirements of business continuity.Taking an online hot backup of PostgreSQL is now as easy as ordering a good espresso coffee.Version 3.20.1 (29 Sep 2026)| Release Notes
Flavio Juvenal
Tech Insights· pgbarman.org
pgbarman - taking an online hot backup of PostgreSQL is now as easy as ordering a good espresso coffee:
From pgbarman.org
Allows your company to implement disaster recovery solutions for PostgreSQL databases with high requirements of business continuity.Taking an online hot backup of PostgreSQL is now as easy as ordering a good espresso coffee.Version 3.20.1 (29 Sep 2026)| Release Notes
Shared by
Read on pgbarman.org- Backup
- DB
- PostgreSQL
- SQL
Tech Insights· hacksoft.io
Django filter - filter(A).filter(B) vs filter(A, B)
Shared by
Read on hacksoft.io- Django
- Python
- SQL
Tech Insights· stackoverflow.com
Postgres - Transpose Rows to Columns:
Shared by
Read on stackoverflow.com- PostgreSQL
- SQL
Tech Insights· simonwillison.net
Django SQL Dashboard, an interface for running arbitrary read-only SQL queries directly against a PostgreSQL database, protected by the Django authentication scheme:
Shared by
Read on simonwillison.net- Admin
- Dashboard
- Django
- SQL
Tech Insights· hakibenita.com
Practical SQL for Data Analysis:
Shared by
Read on hakibenita.com- Data
- SQL
foxhound.systems
Speeding up SQL queries by orders of magnitude using UNION:
SQL's UNION operation isn't usually regarded as a way to optimize query performance, but in many cases it can be used to achieve massive improvements in speed.
Flavio Juvenal
Tech Insights· foxhound.systems
Speeding up SQL queries by orders of magnitude using UNION:
From foxhound.systems
SQL's UNION operation isn't usually regarded as a way to optimize query performance, but in many cases it can be used to achieve massive improvements in speed.
Shared by
Read on foxhound.systems- DB
- Performance
- PostgreSQL
- SQL
github.com
Vinum is a SQL processor for Python, designed for data analysis workflows and in-memory analytics.
Vinum is a SQL processor for Python, designed for data analysis workflows and in-memory analytics. - dmitrykoval/vinum
Flavio Juvenal
Tech Insights· github.com
Vinum is a SQL processor for Python, designed for data analysis workflows and in-memory analytics.
From github.com
Vinum is a SQL processor for Python, designed for data analysis workflows and in-memory analytics. - dmitrykoval/vinum
Shared by
Read on github.com- Analytics
- Data
- SQL
blog.crunchydata.com
Fuzzy Name Matching in Postgres:
The page "Falsehoods Programmers Believe About Names" covers some of the ways names are hard to deal with in programming. This post will ignore most of those complexities, and deal with the problem of matching up loose user input to a database of names.
Rebeca Sarai
Tech Insights· blog.crunchydata.com
Fuzzy Name Matching in Postgres:
From blog.crunchydata.com
The page "Falsehoods Programmers Believe About Names" covers some of the ways names are hard to deal with in programming. This post will ignore most of those complexities, and deal with the problem of matching up loose user input to a database of names.
Shared by
Read on blog.crunchydata.com- Postgresql
- SQL
datadoghq.com
Key metrics for PostgreSQL monitoring
Learn how to identify and track key PostgreSQL performance metrics in this monitoring guide.
João Lins
Tech Insights· datadoghq.com
Key metrics for PostgreSQL monitoring
From datadoghq.com
Learn how to identify and track key PostgreSQL performance metrics in this monitoring guide.
Shared by
Read on datadoghq.com- Postgresql
- SQL
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
