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

  • 2
    The obvious choice is PostgreSQL/postgis but this question is entirely too vague. – Evan Carroll Jul 16 '19 at 0:37
  • What additional details can I provide? – Craeft Jul 16 '19 at 0:41
  • 1
    From my perspective you have only two options MySQL and PostgreSQL. And MySQL is not really an option, because MySQL. – Evan Carroll Jul 16 '19 at 0:43

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.

  • 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 0:46
  • @Craeft sure if you want to use Amazon RDS. I wouldn't off the shelf PostgreSQL likely works just fine for you – Evan Carroll Jul 16 '19 at 0:48
  • @Craeft: for horizontal scaling you might want to look at citusdata.com not only Amazon. Here is an overview on cloud providers for Postgres: severalnines.com/blog/… – a_horse_with_no_name Jul 16 '19 at 6:34

Not the answer you're looking for? Browse other questions tagged or ask your own question.