PostgreSQL

PostgreSQL is an open source relational database with strong support for dates, indexes, triggers and XML. This tag collects guides about building RSS and Atom feeds from PostgreSQL data. Articles explain how to design a table for a feed, use a partial index, build escaped XML with the built-in functions and schedule articles with a publication date and time zone. They also cover why updated-at columns should not decide item dates, how to cache a feed with a last good copy, how a notification can refresh it when an article goes live and how to test the public address. The advice helps teams share every new article on social networks automatically.