Postgres introduced JSON and JSONB in versions 9.3 and 9.4, respectively,
JSON, stored as binary objects with improved compression and more
capabilities. Early releases of JSONB had a limited set of operators, but 9.5 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
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,
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
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 ...
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 ...