#postgresql6 min
Prevent Double Booking in PostgreSQL with Constraints
How to prevent double booking in PostgreSQL: a booking schema with tstzrange, a btree_gist exclusion constraint, and clean 23P01 handling in NestJS.
read →
#postgresql
2 articles tagged postgresql, newest first. Each one answers a specific question with working code and links to the official documentation. See also my PostgreSQL page.
#postgresql6 min
PostGIS for Web Developers: A Practical Intro
A PostGIS introduction for web developers: geography vs geometry, nearby search with ST_DWithin, GiST spatial indexes, and GeoJSON output for Leaflet maps.
read →