Postgres Plus: the EDB blog

By Marc Linster, Jul 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 ...
By Sandra Wiecki, Jul 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. Di ...
By Keith Alsheimer, Jul 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 ...
By Pierre Fricke, Jul 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 r ...
By Pierre Fricke, Jun 27, 2016
The world is experiencing the greatest information explosion in history:  -- 90% of the world’s data was created in the last five years, and most of it is unstructured. The volume, velocity, and variety of data are unprecedented.  -- Gartner says by 2020, 25 billion connected things will b ...
By Gary Carter, Jun 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™ Enter ...
By Bruce Momjian, Jun 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 repre ...
By Sandra Wiecki, Jun 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 ...
By Kanchan Mohitey, Jun 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 ...
By Abbas Butt, May 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 ...
By Pierre Fricke, May 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 co ...
By Amit Kapila, May 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, ...
By Robert Haas, May 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 ...
By Ahsan Hadi, May 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 ...
By Zahid Iqbal, May 02, 2016
Data replication has become a more strategic operation as datacenters expand in complexity and geographically. Data is increasingly off-loaded from transactional systems into specialized applications and databases for greater analysis or digital innovation. But by its very design, replication ...

Choose a Leader!

Learn why Gartner chose EnterpriseDB - an open source relational database company - to be a Leader alongside the market’s largest commercial giants.

Request report >>

Follow EnterpriseDB

Stay informed on product announcements, event information, industry news, and more!

Subscribe to the EDB blog 

Follow us on Twitter