![]() ![]() PostgreSQL provides you transactional DDL. But why bother when you have a database that provides transactions. And if you need to write that error handling every time you write a program, you end up with a client-side library and probably going to need transaction labels. Transactions:Ĭonsider how much extra codes you need to write for error handling if you don’t have transactions. It is also highly extensible with support for GIN and GIST index types, NoSQL database, and provides various features for document or key-value based application development. It also supports standard programs such as MySQL, ANSI SQL, MongoDB, Oracle, and many others. PostgreSQL provides some comparable features with Oracle and DB2 such as full ACID compliance and multi-version concurrency control for a reliable outstanding transaction and to provide support in case of high concurrent loads respectively. ![]() It allows you to define your own data types, index types, and let you develop a custom plugin to meet your requirements. It requires minimum maintenance because of its stability. It can be used by a programmer, project manager, and system administrator or by any software professional for the purpose of building products, websites, tools, etc. It can be run on various platforms such as Windows, Linux, and Mac. It is managed and maintained by a vibrant and independent source of community and actively provide support and help solve the issues when working with PostgreSQL. PostgreSQL is one of the oldest yet the most advanced open source database management system. Stuti Dhruv | 15 May, 2019 PostgreSQL Advantages and Disadvantages ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |