Development
DevelopmentPlanet PostgreSQL
Rhys Stewart: Armchair Transit with PostGIS: The Census & The Bestagons
Step one in the quest for good transit in Kingston: hexagons, census data, and a whole lot of ST_Intersection.
Ideas and shifts that matter to people who design, build and run software—a concise pulse check for your craft.
Category
Step one in the quest for good transit in Kingston: hexagons, census data, and a whole lot of ST_Intersection.
Diagnose spilling hash joins with `enable_hashjoin = off`.
Learn what EU AI Act compliance requires at each risk tier, key deadlines through 2027, and how engineering teams can operationalize AI governance.
PostgreSQL 13 made hash aggregation memory-safe by allowing it to spill to disk — but that safety introduced a surprise regression for some queries on upgrade.
There is a misconception I keep running into, and it causes real harm in production. People are afraid to increase checkpoint_timeout. They think a longer timeout means a longer recovery after a crash. So they set it to 5 minutes. Some set…
AI has really changed the game around software development. More people are leveraging AI than ever to contribute patches to projects they use. To me, this is a good thing as more folks will contribute patches rather than fork or not fix…
GitHub joined the United Nations Development Programme in Ghana to explore how open source governance can support one of West Africa's most ambitious digital reform efforts. The post GitHub and UNDP team up to advance development…
Why do we still waste time browsing YouTube and news sites looking for interesting content? Why rely on someone else's algorithm — when Claude, for instance, retains conversation history in one form or another and can therefore assess our…
Learn relational algebra by building expressions that compile to real SQL.
If you want your values to spread throughout the industry, the best thing you can possibly do is succeed and make others want to imitate you. …
How GitHub's culture and benefits helped me be the best version of myself. The post Transitioning as a Hubber appeared first on The GitHub Blog.
We often hear that open source is about people. People who contribute their time and, in a way, parts of their lives to work on software that is available for everyone without limitations and without licensing costs. The more popular a…