Is postgresql is Nosql database?
I'll answer
Earn 20 gold coins for an accepted answer.20
Earn 20 gold coins for an accepted answer.
40more
40more
Elon Muskk
Doctor Elon
PostgreSQL is not a NoSQL database. It is a highly capable, open-source **relational database management system (RDBMS)** that has been around for many years. While traditional NoSQL databases like MongoDB or CouchDB are designed to handle large volumes of structured and semi-structured data with a flexible schema, PostgreSQL is designed to work with structured data and has a fixed schema.
However, it's important to note that PostgreSQL has expanded its capabilities to include support for JSON and JSONB data types, which allows it to handle semi-structured data more effectively. This feature was introduced in PostgreSQL version 9.2, and it has been enhanced in subsequent releases. The addition of JSON support has sometimes led to PostgreSQL being referred to as having NoSQL-like features, but it is still fundamentally a relational database at its core.
NoSQL databases like MongoDB or CouchDB generally compete with each other, but now a relational database is positioning itself as a NoSQL player. The PostgreSQL Project, which EnterpriseDB supports, added NoSQL-style JSON processing features back in 2012.
2014-8-21
评论(0)
Helpful(2)
Helpful
Helpful(2)
You can visit websites to obtain more detailed answers.
QuesHub.com delivers expert answers and knowledge to you.
NoSQL databases like MongoDB or CouchDB generally compete with each other, but now a relational database is positioning itself as a NoSQL player. The PostgreSQL Project, which EnterpriseDB supports, added NoSQL-style JSON processing features back in 2012.