Thursday, December 26, 2013

Amazon RDS Supports PostgreSQL!

Amazon cloud based services have officially announced that they will be upgrading their support to include PostGreSQL in their list of supported database architecture. This will provide users with the flexibility of cloud services while working with systems that utilize PostgreSQL. Such increased flexibility enables users to easily create, manage, scale and optimize their PostGre setups.

Looking back at the traditional process involved, PostGreSQL database creation and management used to be a complex and cumbersome process that involved a lot of effort and technical know-how. Amazon aims to simplify this process by utilizing its SaaS, PaaS and IaaS capabilities. With a powerful and efficient management console provided by Amazon, users will now be able to easily create and manage PostGre instances. The console provides autoconfigured instances with prefilled parameters that help users to set up instances with just a few mouse clicks.

The main advantage of Amazon RDS is that the user will be able to use all the tools and services that are currently available with database engines. PostGre has become the leading trend in web and mobile application development and this drift will increase with support from Amazon.

The current integration from Amazon includes a few key functional and feature specifications which makes it truly user friendly and efficient. Specifications are explained below:

* Amazon RDS provides the option to select preconfigured parameters and settings. This allows quick creation, deployment and management of PostGreSQL instances.

* Analytics feature has been optimized to allow real time monitoring and tracking of usage statistics and information.

* Another amazing feature is the automated status/activity update. This feature updates the user by sending an SMS or email notification to the registered email address/mobile number.

* Version control and patch management are handled by the system. This process is automated and allows the system to patch the database and maintain proper versioning.

*  Amazon has optimized speed and performance figures. This has been done by modifying the IOPS range and provisioning it to more than 25,000 PostGreSQL.

*  Scaling of database is a piece of cake in Amazon RDS. As always, easy scalability is an advantage of PostGreSQL instances in Amazon.

*  Apart from this, Amazon also provides enhanced security and backup/restoration mechanisms.

Main Features:

Location-based services – Amazon supports location-based geolocation services with PostGre. This is termed as PostGIS service and extends the relational schema to a geospatial data architecture.

Multiple language support – The support for multiple code level languages has been included. There are three language extensions to support Perl, pgSQL and Tcl.

Enhanced search – Amazon ensures a perfected search mechanism that allows users to perform text-based searches.

JSON support – The system supports JSON communication for data manipulation and Hstore function.

Apart from these, the system includes all core features of PostGreSQL database.


No comments:

Post a Comment