pgRouting, a Postgres extension typically used for geospatial routing, offers versatile graph functionality beyond GIS applications. The extension can handle task scheduling, resource allocation in distributed systems, and power recommendation engines, making it a lightweight alternative to specialized graph databases.
PostgreSQL's unique position as a truly open-source, advanced relational database with extensive modularity is driving its accelerating adoption across the industry. EdgeDB announces its rebranding as Gel, introducing full SQL support and deeper ecosystem integration while maintaining its role as a PostgreSQL frontend layer enhancement. The platform aims to provide seamless database integration similar to how TypeScript enhances JavaScript.
A detailed exploration of representing and querying graph data structures in PostgreSQL using nodes and edges tables, demonstrated through Lord of the Rings character relationships. The solution showcases how to implement complex relationship queries using recursive CTEs and parameterized statements for flexible graph traversal.
An open-source bookmarking server built with Common Lisp and PostgreSQL, offering multi-account support and minimal JavaScript requirements. The project prioritizes portability and simplicity, running efficiently on OpenBSD while maintaining core security features through bcrypt password storage and optional captcha protection.
PgAssistant is an open-source tool that helps developers analyze and optimize PostgreSQL database performance through features like schema optimization, query management, and AI-powered assistance. The tool integrates with OpenAI and local LLMs for query optimization while offering practical features like SQL linting, DDL generation, and PGTune integration.
A detailed account of Checkly's migration from Heroku to AWS in 2022, driven by PostgreSQL upgrade limitations and maintenance window constraints. The migration involved careful planning, data replication strategies, and resulted in a successful transition with minimal downtime, offering valuable insights for similar cloud platform migrations.
Microsoft released open source PostgreSQL extensions to handle document-style data, challenging MongoDB's dominance in the NoSQL space while blurring the lines between relational and non-relational databases. The extensions enable BSON support and MongoDB-compatible commands, partnering with FerretDB to create a viable MongoDB alternative on PostgreSQL.
A discussion on implementing trailing commas in SQL explores various approaches, from supporting only popular cases to comprehensive implementation across all comma-separated constructs, highlighting challenges in both PostgreSQL implementation and SQL standardization.
A detailed exploration of SQLite vs PostgreSQL performance for a Twilio blog analytics dashboard, featuring comprehensive benchmarking tests on both development and production environments, leading to unexpected findings about database performance under different query loads and concurrency levels.