As of December 1, 2015, Oracle® is no longer offering two of its most
popular database license options, SE and SE1; replacing them instead with a
new SE2 version which effectively increases license limitations to force more
customers onto their Enterprise Edition—at an enormous cost increa ...
Open source software has been saving organizations money for years in
operating systems with Linux, in the middleware layer with tools like JBoss,
and virtualization with Xen and other options. These IT organizations
embarked on these journeys to open source alternatives to reconfigure IT
This blog was co-written by Jason Davis. EnterpriseDB is about to release an
update to the Connectors for Postgres and EDB Postgres. The update will
include some new capabilities in the JDBC driver to support connection
failover. Connection failover provides automatic and robust failover for J ...
There remains significant uncertainty about the future of the Government
Digital Service (GDS) in following the departure of its primary champion,
Mike Bracken, this past summer. There have been some that suggested the GDS
is entirely unnecessary and others who say that it should exist in a s ...
This post originally appeared on Robert Haas' personal blog. I previously
suggested that we might be able to get parallel sequential scan committed to
PostgreSQL 9.5. That did not happen. However, I'm pleased to report that
I've just committed the first version of parallel sequential sc ...
Headaches will come with just about any new project but taking a pause and
considering the following steps before getting started with a new Postgres
deployment should save you quite a few. Even seasoned DBAs can benefit from a
refresh on some of these topics. So, in order to reduce risk, mini ...
The only data structure recognized in traditional SQL databases was the row,
and repeating groups were extracted into child rows linked through foreign
keys. It worked well but could be somewhat artificial and cumbersome for
programmers. With more powerful processors and plentiful memory, ...
Common practice in relational database design is to utilize a non-repeating,
ordered series of integers for primary keys (PK) and by extension, foreign
keys (FK). This practice has worked so well and efficiently for database
designers that all commercially viable RDBMSs provide some means of ...
Red Hat recently hosted its annual Red Hat Forum Benelux in the Netherlands
and EnterpriseDB (EDB) was one of the participating local partners. Mike
Huseman, Senior Vice President of Global Sales & Business Development at EDB,
delivered one of the keynote addresses. Huseman was able to highlig ...
Database migrations from closed source to open source have become a
particularly hot topic recently as I have been asked by customers, analysts,
investors (and a few competitors!) what’s driving the accelerated changes
in enterprise and government IT departments. We have been both pursuing ...
Released nearly 15 years ago, PostGIS is an open source extension to Postgres
that spatially enables your database server, and follows the OGC Simple
Features for SQL specification. If you are coming from another standards
based spatial database you may notice similarities in the spatial data ...
EnterpriseDB (EDB) customers who moved/migrated their database from Oracle to
EDB’s Postgres Plus Advanced Server (PPAS) frequently ask for Global
Temporary Table in PPAS. Currently, PPAS doesn’t support Global Temporary
tables. However, there is a way users can achieve this functionality ...
I’ve been working in the IT industry long enough now to see how techies
appropriate – and quite often misappropriate – words in the English
language. One such word is “legacy.” For anyone outside the IT
industry this could mean a couple of different things, but it probably has a ...
James Cash Penney, the founder of JCPenney, once said, “Growth is never by
mere chance; it is the result of forces working together.” The retail
pioneer could be speaking of the forces underway in the database industry
that have enabled EnterpriseDB to emerge as a formidable force in the m ...
Most IT organizations have made large investments in infrastructure and
applications that have been running the business for years. Keeping this
infrastructure costs a lot of money, perhaps up to 80% of an IT budget. To
make things worse, some vendors, notably leading database vendors, employ ...