Efficient Percentile Ranking in PostgreSQL
When analyzing data, percentiles help us understand the relative ranking of records within a dataset.
Blog
Postgres
5 posts tagged postgres — the same founder-tested patterns, filtered.
Linking Data in PostgreSQL Without Explicit Keys: A Practical Guide
Databases often evolve in unpredictable ways. Tables that were initially designed to operate independently might later need to be connected.
DelayedJob and PG Error No Connection to Server
Recently I’ve got strange errors on the staging server. Delayed::Job workers started successfully.
SQL: Get records having min/max value per group
The solution doesn't require any changes to the DB scheme (denormalization or creation of views) and can be performed in the scope of a single SQL query.
Setting Up Docker for Ruby on Rails 7
Setting up Docker for a Ruby on Rails 7 application from scratch, from installing Docker to a working container the whole team can share.
Reading this because something is going wrong?
A free code audit gives you a written assessment of your codebase in plain English.
Get a Free Code AuditRated 4.8/5 on Clutch · you keep the write-up either way