Bookmarks with tag "db", page 5 of 8

This article will introduce you to Postgres, explain the alternatives, and walk you through an example use case of pub/sub and its solution.

GraphQL support is in development for PostgreSQL + Supabase.

SQL-first Golang ORM.

With Postgres, you don't need to immediately look farther than your own database management system for a full-text search solution. If you haven't yet given Postgres' built-in full-text search a try, read on for a simple intro.

Data within a database exists across multiple tables, JOINs allow you to combine datasets into new tables for analysis. Learn more.

This article gives a brief introduction to EXPLAIN ANALYZE, explains what to look for and shows some helpful tools to visualize the output.

At work I was tasked to migrate our time-series analytics data from CSV file dumps that we’ve been feeding into Power BI to a dedicated database. Our Rails app’s primary database is currently MariaDB, but we wanted to have our analytics data in a separate database either way, so this was a good opportunity to use Postgres which we’re most comfortable with anyway.

A lightweight, framework-agnostic database migration tool.

YouTube-like Short IDs as Postgres Primary Keys.