The EDB Blog

Be Prepared for Prepare

06/20/2016
Prepared statements are queries where the constants used in the query are separated from the query text. While this improves security by avoiding SQL injection attacks , it also allows repeatedly-executed queries to avoid parsing and planning overhead by executing saved generic plans that represent...

Coming to Your Private Cloud: Self-service

06/17/2016
Enterprises are under pressure to innovate by deploying new web, mobile, cloud, and Internet of Things (IoT) applications that better engage customers and harvest greater insight from operational data. Failing to innovate means falling behind the competition. Cloud platforms like AWS or Google...

PgAdmin Tests New QA Testing Framework

06/10/2016
An established-yet-still-growing trend in software development is the use of a testing framework that allows the automated execution of unit tests to determine whether various code paths are working as expected under various circumstances. Each test case describes a test that must be run on an...

Defend Against SQL Injection Attacks

05/27/2016
Read past the headlines about some of the worst data breaches and you’ll find a SQL injection attack. SQL injections has been used to hack U.S. government systems, major retailers, even the World Trade Organization. More recently, the so-called Panama Papers data leak has been attributed to a SQL...

How the EDB Postgres Platform is Fueling Digital Innovation

05/25/2016
Intelligent, customer-facing applications; analytics; ecosystem-level intelligence that leverages the Internet of Things – these strategic initiatives bring better visibility into operations and yield competitive advantages. Yet they remain out of reach for many businesses. That should come as no...

Corporate Giving: EDB’s Contributions to PostgreSQL

05/13/2016
There is an important difference between the open source PostgreSQL community and many other open source communities – it is not controlled by a single company that can dictate whether others can contribute. Instead, the PostgreSQL open source community is independent of any single company. It’s...

Powering up Postgres with Performance Advances

05/20/2016
The last five years have produced a significant increase in global organizations deploying Postgres across their organizations and calling for higher performance as they discovered the value and sought to expand its use. Meanwhile, in the same five years, the Postgres development community,...

Connecting Hadoop and EDB Postgres to Shrink Big Data Challenges

05/06/2016
EnterpriseDB ® (EDB™) has certified the EDB Postgres™ Advanced Server database for the Hortonworks Data Platform. The certification ultimately will provide organizations with a powerful solution for combining data stored in Hadoop clusters with their transactional information. This seamless view of...

5 Reasons to Review Your Disaster Recovery Plan Now

04/29/2016
Database reliability is an ongoing process, not a one-time activity. And your database disaster recovery (DR) plans are a key part of keeping your business systems reliable. However, in today’s culture that embraces the famous Ron Popeil mantra of “set it, and forget it,” maintaining highly...

Transforming the Way You Learn Postgres with Competence

04/20/2016
Noted psychologist Noel Burch developed a model called the “Four Stages for Learning Any New Skill” to better understand the often slow and uncomfortable process of learning something new. The model reveals that everyone encounters the same four learning stages whether learning to play an...

pgAdmin 4 - The Elephant Nears the Finish Line

04/18/2016
As you may know, many of us from the pgAdmin team have been hard at work on pgAdmin 4 for some time now. pgAdmin 4 is a complete rewrite of pgAdmin (the fourth, as you may guess), the previous version having reached the end of it's maintainable life after 14 years of development. Work on the...

Speeding Bulk Data Loads in Postgres

04/14/2016
EnterpriseDB ® (EDB™) developed a high-performance tool for loading data in bulk called EDB*Loader that is twice as fast as PostgreSQL COPY and outperforms standard SQL statement for bulk loading of JSONB data. The tool is part of EDB Postgres™ Advanced Server. The recent 9.5 release of EDB...

Monitoring in PostgreSQL 9.6

04/08/2016
This is part 2 in a 4 part blog series on improvements coming in PostgreSQL 9.6. Part 1 - Horizontal Scalability Join Pushdown Sort Pushdown "Walk and chew gum at the same time" Part 2 - Monitoring VACUUM progress monitoring Wait monitoring Part 3 - Parallelism Part 4 - Vertical Scalability Read...

A Little Respect for PGpool II

04/07/2016
Middleware doesn’t get the respect it deserves. Considered the glue that holds together the more complex and more business-critical components in the software stack, middleware is often installed and forgotten. But middleware can have significant impact on the operation and performance in the...