The links, tools and tips our engineers and designers share with each other, one “today I learned” at a time.
kysely.dev
Kysely is the most powerful type-safe SQL query builder for TypeScript. Get unparalleled autocompletion and compile-time type safety for complex queries, joins, and subqueries. Used in production by Mozilla, Bluesky, and Materialize. Modern TypeScript, zero runtime dependencies.
Vitor Rangel
Tech Insights· kysely.dev
From kysely.dev
Kysely is the most powerful type-safe SQL query builder for TypeScript. Get unparalleled autocompletion and compile-time type safety for complex queries, joins, and subqueries. Used in production by Mozilla, Bluesky, and Materialize. Modern TypeScript, zero runtime dependencies.
Shared by
Tech Insights· flexport.engineering
Shared by
brandur.org
An alternate to traditional deleted_at soft deletion that stays out of the way and minimizes bugs.
Vitor Rangel
Tech Insights· brandur.org
From brandur.org
An alternate to traditional deleted_at soft deletion that stays out of the way and minimizes bugs.
Shared by
Tech Insights· hakibenita.com
Shared by
Tech Insights· cybertec-postgresql.com
COUNT(*) vs. COUNT(id) is a non-issue:Shared by
Tech Insights· stackoverflow.com
Shared by
Tech Insights· github.com
Shared by
Tech Insights· betterprogramming.pub
Shared by
Tech Insights· github.com
Shared by
supabase.com
PostgreSQL has a robust set of features which we can leverage to create a generic auditing solution in 150 lines of SQL.
Rebeca Sarai
Tech Insights· supabase.com
From supabase.com
PostgreSQL has a robust set of features which we can leverage to create a generic auditing solution in 150 lines of SQL.
Shared by
Tech Insights· stackoverflow.com
Shared by
gist.github.com
Short explanation of the issues faced when trying to create a PostgreSQL index using the date() function and how to resolve it. - postgresql_date_function_index_howto.md
Gabriela Cavalcante
Tech Insights· gist.github.com
From gist.github.com
Short explanation of the issues faced when trying to create a PostgreSQL index using the date() function and how to resolve it. - postgresql_date_function_index_howto.md
Shared by
github.com
Explicit control over database query execution in Django applications - dabapps/django-zen-queries
Flavio Juvenal
Tech Insights· github.com
From github.com
Explicit control over database query execution in Django applications - dabapps/django-zen-queries
Shared by
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.
Flavio Juvenal
Tech Insights· prisma.io
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
Tech Insights· realpython.com
Shared by
Book a call
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
