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

Improve this question
3
  • 2
    The obvious choice is PostgreSQL/postgis but this question is entirely too vague.
    – Evan Carroll
    Commented Jul 16, 2019 at 0:37
  • What additional details can I provide?
    – Craeft
    Commented Jul 16, 2019 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
    Commented Jul 16, 2019 at 0:43

1 Answer 1

Reset to default
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.

Improve this answer
3
  • 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
    Commented Jul 16, 2019 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
    Commented Jul 16, 2019 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/…
    – user1822
    Commented Jul 16, 2019 at 6:34

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