The EDB Blog

IT Market Research Firm Reveals 168% ROI with EDB Postgres Platform

By Pierre Fricke
The three-year return on investment of the EDB Postgres™ Platform is 168%, according to a new white paper on the comprehensive business impact of EDB Postgres based on interviews with EDB customers. The white paper titled The Economic and Business Advantages of EDB Postgres Database Solutions*,...

5 Questions to Help You Avoid Oracle Compatibility Imitators

By Gary Carter
You may have heard the phrase: Imitation is the sincerest form of flattery. It implies that competitors doing what you already do validate your actions without explicitly saying so. It also implies that the imitator is actually delivering what you are. Over the last decade, EnterpriseDB ® (EDB™)...

Oracle License Plus Fees vs. EDB Postgres Subscription

By Pierre Fricke
Complex licenses, rising maintenance costs, and continuing audit risks have prompted many Oracle customers to seek alternative database management systems (DBMSs). The opex-based pricing model with comprehensive subscriptions offered by EnterpriseDB® (EDB™) has helped organizations lower costs...

Uber's Move Away from PostgreSQL

By Robert Haas
Last week, a blog post by an Uber engineer explained why Uber chose to move from PostgreSQL to MySQL . This article was widely reported and discussed within the PostgreSQL community, with many users and developers expressing the clear sentiment that Uber had indeed touched on some areas where...

EDB and IBM Powering the Open Source Database Movement

By Pierre Fricke
Postgres has been a major beneficiary of the open source movement with organizations turning to the world’s most advanced open source relational database as the primary database for new applications, modernization efforts, and as an alternative to expensive traditional vendors. Gartner has declared...

An Illustration of JSONB Capabilities in Postgres 9.5

By Marc Linster
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

By Sandra Wiecki
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?

By Keith Alsheimer
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

By Pierre Fricke
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

By Gary Carter
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

By Bruce Momjian
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

By Sandra Wiecki
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

By Kanchan Mohitey
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...