PostgreSQL 9.5 eyes MySQL users with new Web, mobile-friendly features
PostgreSQL released a new version of its software that is equipped with a number of features billed as making it the database management system of choice from startups to large enterprises. PostgreSQL 9.5 comes with row-level security and a number of capabilities that will allow it to better handle bigger databases or integrate with systems designed for big data.
One interesting new feature is called Upsert and allows new and updated rows to be treated the same. This simplifies development for users grappling with potentially conflicting updates being attempted on the database from both a Web and mobile app front end.
Upsert allows users to ignore the new data or update columns or relations in ways that support extract, transform and load toolchains for bulk data loading.
Developed over two years, the new feature also "removes the last significant barrier to migrating legacy MySQL applications to PostgreSQL," according to the company. Despite heady initial growth, the development of MySQL has faced criticism since its acquisition by Oracle in 2008, resulting in a waning of popularity that PostgreSQL is no doubt trying to capitalize on.
PostgreSQL 9.5 also offers row-level security that the company said offers true per-row and per-column data access control that can be integrated with label-based security stacks such as SE Linux. Implemented properly, it makes the DBMS more resistant against SQL injection – the bane of DBMS around the world – as well as other application-level security holes.
Among the big data-centric features, foreign data wrappers allows PostgreSQL to serve as a query engine for Hadoop systems such as Cassandra. However, it's not clear yet whether it can perform at the same level as a native Hadoop engine.