Postgres Migration - DB Migration
About Postgres
PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley.
- Open Source DBMS
- Diverse Community
- ACID and Transaction
Why Postgres
The World's Most Advanced Open Source Relational Database
- Datatypes, including JSONB and range types - Postgres has long had an open and friendly attitude for adding datatypes. It’s had arrays, geospatical and more for some time.
- Logical replication - Logical replication allows the sending of more or less actual commands, this means you could replicate only certain commands or certain tables.
- Richer indexing - Postgres already had some pretty powerful indexing before with GIN and GiST, those are now useful for JSONB.
- Upsert - Upsert was a work in progress for several years. It was one of those features that most people hacked around with CTEs, but that could create race conditions.
Book an Appointment!
Book a 30 min consulting on Postgres with WeCanDoNow team
Where is Postgres Useful?
- In 2010, Apple replaced MySQL with Postgres as an embedded database in the OS X Lion release.
- Instagram uses many RDBMSs, but PostgreSQL and Cassandra were chosen for the main tasks. The goal was to reduce delay and ensure users can easily and comfortably use the application.
- Reddit uses PostgreSQL in two different ways. First of all, there’s the ThingDB model. This is the basic Postgres mechanism for storing data for most objects
- The Twitch platform is based on around 125 databases. The vast majority of them are managed using PostgreSQL, including user, broadcast data, and backup databases.
Key Features
- Compatible on several operation systems
- Compatible with various programming languages
- Highly extensible
- Highly Reliable
- Secure
- Supports Internationalization