PostgreSQL
PostgreSQL, often called Postgres, is a powerful open-source relational database known for its reliability, extensibility, and SQL compliance. Designed to handle high-performance workloads, it excels in data integrity, scalability, and concurrent processing.
Postgres supports advanced features such as ACID transactions, JSONB storage for semi-structured data, full-text search, and powerful indexing techniques. Its extensibility allows for custom functions, procedural languages, and a growing ecosystem of plugins.
Where is it used in the stack?
PostgreSQL serves as the primary database for the RawStack API, ensuring secure and efficient data management.
Why are we using it?
PostgreSQL was chosen for its robustness, strong consistency, and ability to scale with increasing data demands. Its rich feature set and reliability make it the ideal choice for powering the RawStack API's data layer.
Find out more
- The official postgreSQL website is here