0

My company has a huge (hundreds of millions of records) Oracle database of GIS/temporal information. We are trying to switch to an open source alternative.

If it helps, we imagined the following requirements:

  1. horizontal scaling (like elastic search, for example)

  2. fully SQL compliant. We don't think we can use NoSQL, etc, because we would have to rewrite all our queries.

  3. No license fee

Laurenz Albe
  • 30,193
  • 3
  • 26
  • 50
Craeft
  • 101
  • 2

1 Answers1

2

No database is fully SQL compliant. But out of the SQL databases that provide any form of scaling you have PostgreSQL w/ PostGIS and MySQL to choose from.

PostGIS is the superior choice. For why see my comparison here.

NO WAR WITH RUSSIA
  • 54,954
  • 34
  • 200
  • 411
  • Ok. You linked answer has convinced me not to use MySQL. One of the things we are hearing is switching to "cattle not pets" cloud paradigm. Can postgresql support that? – Craeft Jul 16 '19 at 00:46
  • @Craeft sure if you want to use Amazon RDS. I wouldn't off the shelf PostgreSQL likely works just fine for you – NO WAR WITH RUSSIA Jul 16 '19 at 00:48
  • @Craeft: for horizontal scaling you might want to look at https://www.citusdata.com/ not only Amazon. Here is an overview on cloud providers for Postgres: https://severalnines.com/blog/comparing-cloud-database-options-postgresql – a_horse_with_no_name Jul 16 '19 at 06:34