• Top Ten Reasons to Migrate from Oracle to PostgreSQL

  

  severalnines.com

  Top Ten Reasons to Migrate from Oracle to Postgres — We’re no doubt preaching to the converted here (!) but if you know someone considering the move, here’s some of the advantages of migrating from Oracle to Postgres.

  database migration migration oracle postgres postgresql timescaledb

  • Add  

  2

Appears in lists (1)

• Issue 334 - Some lesser known features in Postgres 12

More like this (3)

• 

  Full-text search since PostgreSQL 8.3 - 2ndQuadrant | PostgreSQL

  

  2ndquadrant.com

  Full-Text Search Since PostgreSQL 8.3 — Postgres has had full text search functionality for some time...

  Full-Text Search Since PostgreSQL 8.3 — Postgres has had full text search functionality for some time and it continues to get better. This post looks at its history and runs benchmarks over each key version from 8.3 to 13.

  • Read
  • Add  

  
• 

  Migrating interactive analytics apps from Redshift to Postgres, ft. Hyperscale (Citus)

  

  citusdata.com

  Migrating Interactive Analytics Apps From Redshift to Citus-Flavored Postgres — Some lessons learnt migrating an analytics...

  Migrating Interactive Analytics Apps From Redshift to Citus-Flavored Postgres — Some lessons learnt migrating an analytics dashboard from Redshift to Hyperscale (Citus) on Azure Database for PostgreSQL looking at how indexes enabled some performance gains and the compression benefits of JSONB.

  • Read
  • Add  

  
• An Overview of JSON Capabilities Within PostgreSQL

  

  severalnines.com

  5. An Overview of Postgres's JSON Capabilities — Postgres's JSON capabilities have continued to improve over the...

  5. An Overview of Postgres's JSON Capabilities — Postgres's JSON capabilities have continued to improve over the years, and while this article was very popular back in January, things have continued to improve over the course of 2019 with the introduction of JSONPath support (PDF) in Postgres 12 which was released in October.

  • Read
  • Add