Throughout the public sector, one of today’s most important trends is the adoption of open source software. Thanks to the transparency, security and cost savings that open source software offers, government is embracing modern solutions that make it possible to build better tools for citizens and organizations to access information.

Most organizations with database needs have explored migrating their database operations to the cloud. Cloud-based database environments offer increased levels of convenience and reliability, making it easy to manage and control database access anytime, anywhere. But not every organization is ready to shift its entire database operations into the cloud. The process may start with a few...

Recently I spotted a study by Digital Ocean on the adoption of open source that found more than half of developers are contributing to open source projects.

Highway monitoring solutions provider Costain (formerly Simulation Systems Limited) was building a new system to support vehicular traffic surveillance cameras that monitor tunnels throughout London. Transport for London required constant monitoring capabilities in the tunnels to ensure safety. The number one goal for Costain was to build a new system with greater resiliency, reducing the transition time from the primary surveillance system to a standby to ensure Transport for London maintained this consistent view into the tunnels. At the time, the transition time was two minutes, which was far too long.

In this article we are going to see how database servers work together to allow the second server to take over quickly if the primary server fails(high availability), and to allow multiple servers to serve the same data for SELECTs(horizontal read scalability).

Agencies across the U.S. government have adopted EDB Postgres Advanced Server (EPAS) from EDB®. One of those agencies is critical to securing information for the nation’s defense initiatives and handles a wide range of data, and, in particular, considerable stores of geospatial information.

There has been a lot of talk about database automation in the last six months and how, as if by magic, it will mean companies no longer have to worry about cyber-security. Sadly, the reality is somewhat different. Automating database functionality does not absolve you of your security related responsibilities.

Anyone running a database in a production environment with over a hundred users should seriously consider employing a connection pooler to keep resource usage under control.

Industry analyst firm, 451 Research, just recently issued a report providing an overview of EnterpriseDB, its history and recent product news including the EDB Postgres Migration Portal, EDB Postgres Ark DBaaS and Postgres Enterprise Manager. Here are some excerpts: - “EnterpriseDB, considered one of the leading forces behind PostgreSQL adoption, is on a mission to give customers the choice of...

TOAST stands for The Oversized-Attribute Storage Technique. EDB Postgres and PostgreSQL use a fixed page size (commonly 8 KB), and does not allow tuples to span multiple pages. Therefore, it is not possible to store very large field values directly.