Bookmarks with tag "postgres", page 3 of 4
Rebased Team writing about tech we use. Languages, frameworks, libraries, tools. Certified for 0% fluff. PostGIS is a fantastic, battle-tested suite of GIS extensions for Postgres. It handles most aspects of it, and is widely used, for example in OpenStreetMap’s Mapnik. But for your project, it’s most likely overkill. In a Q and A fashion, let’s discuss reasons for (not) using it.
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.
How to check if two datetime ranges overlap in PostgreSQL.
Web site created using create-react-app
In-browser Postgres sandbox with AI assistance
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
A tool to generate migrations based on schema differences
UUID also known as GUID is an alternative primary key type for SQL databases. It offers some non-obvious advantages compared to standard integer-based keys. Rails 6 release fresh out of beta introduces a new feature in ActiveRecord that makes working with UUID primary keys more straightforward. In this tutorial, we will dive deep into UUIDs with all their cons and pros.
GraphQL support is in development for PostgreSQL + Supabase.