Lessons about DB
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
Tech Insights· flexport.engineering
Index Selectivity: A Key to High Performance SQL
Shared by
Read on flexport.engineering- DB
- Performance
- PostgreSQL
- SQL
postgresql.org
Information Schema has tables that have a lot of metadata about your DB,
Chapter 35. The Information Schema Table of Contents 35.1. The Schema 35.2. Data Types 35.3. information_schema_catalog_name 35.4. administrable_role_authorizations 35.5. applicable_roles 35.6. attributes …
Dennys Azevedo
Tech Insights· postgresql.org
Information Schema has tables that have a lot of metadata about your DB,
From postgresql.org
Chapter 35. The Information Schema Table of Contents 35.1. The Schema 35.2. Data Types 35.3. information_schema_catalog_name 35.4. administrable_role_authorizations 35.5. applicable_roles 35.6. attributes …
Shared by
Read on postgresql.org- DB
- Postgresql
Tech Insights· hakibenita.com
Cheatsheet to grouping queries in Django
Shared by
Read on hakibenita.com- DB
- Django
- Haki
- SQL
Tech Insights· stackoverflow.com
How to migrate models across apps in Django?
Shared by
Read on stackoverflow.com- DB
- Django
stackoverflow.com
Django needs a
GinIndexwithOpClass+Upperto support fast queries with theicontainsoperator:Flavio Juvenal
Tech Insights· stackoverflow.com
Django needs a
GinIndexwithOpClass+Upperto support fast queries with theicontainsoperator:Shared by
Read on stackoverflow.com- DB
- Django
- Index
- PostgreSQL
engineering.grab.com
Grab: How we store and process millions of orders daily
The Grab Order Platform is a distributed system that processes millions of GrabFood or GrabMart orders every day. Learn about how the Grab order platform sto...
Flavio Juvenal
Tech Insights· engineering.grab.com
Grab: How we store and process millions of orders daily
From engineering.grab.com
The Grab Order Platform is a distributed system that processes millions of GrabFood or GrabMart orders every day. Learn about how the Grab order platform sto...
Shared by
Read on engineering.grab.com- DB
- Infrastructure
- Olap
- Oltp
- Queue
- Resiliency
- SRE
Tech Insights· cybertec-postgresql.com
In Postgres,
COUNT(*)vs.COUNT(id)is a non-issue:Shared by
Read on cybertec-postgresql.com- DB
- PostgreSQL
- SQL
martinfowler.com
How to extract a data-rich service from a monolith
A series of steps for separating part of a monolithic application, with its data store, to an independent service
Flavio Juvenal
Tech Insights· martinfowler.com
How to extract a data-rich service from a monolith
From martinfowler.com
A series of steps for separating part of a monolithic application, with its data store, to an independent service
Shared by
Read on martinfowler.com- DB
- Refactoring
Tech Insights· stackoverflow.com
How to estimate the size of one column in a Postgres table?
Shared by
Read on stackoverflow.com- DB
- PostgreSQL
docs.gitlab.com
GitLab on Migration Style Guide:
Learn more about Migration Style Guide in the GitLab documentation.
Rebeca Sarai
Tech Insights· docs.gitlab.com
GitLab on Migration Style Guide:
From docs.gitlab.com
Learn more about Migration Style Guide in the GitLab documentation.
Shared by
Read on docs.gitlab.com- DB
- Migrations
postgres.ai
Common DB schema change mistakes:
Common DB schema change mistakes and how to avoid them in PostgreSQL development.
Rebeca Sarai
Tech Insights· postgres.ai
Common DB schema change mistakes:
From postgres.ai
Common DB schema change mistakes and how to avoid them in PostgreSQL development.
Shared by
Read on postgres.ai- DB
- PostgreSQL
github.com
Thin clones of PostgreSQL to build powerful development, test, and QA envs. Cloning a 1 TiB PostgreSQL database takes ~10 seconds:
DBLab enables 🖖 database branching and ⚡️ thin cloning for any Postgres database and empowers DB testing in CI/CD. This optimizes database-related costs while improving time-to-market and software ...
Rebeca Sarai
Tech Insights· github.com
Thin clones of PostgreSQL to build powerful development, test, and QA envs. Cloning a 1 TiB PostgreSQL database takes ~10 seconds:
From github.com
DBLab enables 🖖 database branching and ⚡️ thin cloning for any Postgres database and empowers DB testing in CI/CD. This optimizes database-related costs while improving time-to-market and software ...
Shared by
Read on github.com- Cd
- DB
- PostgreSQL
timescale.com
How percentile approximation works (and why it's more useful than averages)
What percentile approximations are, how percentiles work in PostgreSQL, and calculating them efficiently on time-series data.
Flavio Juvenal
Tech Insights· timescale.com
How percentile approximation works (and why it's more useful than averages)
From timescale.com
What percentile approximations are, how percentiles work in PostgreSQL, and calculating them efficiently on time-series data.
Shared by
Read on timescale.com- DB
- Kpi
- Metric
- PostgreSQL
- Statistics
ebrary.net
Reading Your Own Writes:
Many applications let the user submit some data and then view what they have submitted. This might be a record in a customer database, or a comment on a discussion thread, or something else of that sort
Flavio Juvenal
Tech Insights· ebrary.net
Reading Your Own Writes:
From ebrary.net
Many applications let the user submit some data and then view what they have submitted. This might be a record in a customer database, or a comment on a discussion thread, or something else of that sort
Shared by
Read on ebrary.net- DB
Tech Insights· postgresql-anonymizer.readthedocs.io
PostgreSQL Anonymizer:
- DB
- 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
