The EDB Blog

An Illustration of JSONB Capabilities in Postgres 9.5

06/22/2016
Postgres introduced JSON and JSONB in versions 9.3 and 9.4, respectively, with JSONB (Binary Javascript Object Notation) being the canonical form of JSON, stored as binary objects with improved compression and more capabilities. Early releases of JSONB had a limited set of operators, but 9.5...

Agile development with NoSQL for Faster Time to Market

07/15/2016
With digital transformation, software has become the most important tool to attract, keep and grow customer accounts. For a company to stay competitive in a market, its digital offerings need to stay up-to-date with modern technology, cool competitive features and growing user expectations. Digital...

The Oracle SE2 Dilemma: Liberation or Consignation?

07/14/2016
Last November I wrote a blog, The Oracle SE2 Tea Party , about Oracle’s forced “upgrade” of its SE and SE1 customers to Oracle SE2 and the problems it causes for many Oracle users who have to either pay more for less performance or shift to new hardware infrastructure to be in compliance with the...

An Enterprise Data Platform for the Age of the Customer

07/07/2016
Data is ubiquitous due to the explosion of the Internet of Things (IoT) and mobile devices. According to Forrester, 90% of the world’s data was created in the last two years, much of which is unstructured and unwieldy. Sensors, location beacons, GPS, mobile device interaction patterns and real-time...

Comparing EDB Postgres and Oracle

06/21/2016
One of the most frequent questions we get here at EnterpriseDB ® (EDB ™ ) from database administrators (DBAs) and developers is, “How does EDB Postgres ™ compare, side-by-side, to Oracle?” To provide answers, EDB has prepared a new eBook, “ A Technical Comparison of EDB Postgres ™ Enterprise and...

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...