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

closed as off-topic by Evan Carroll, Joe Obbish, Marcello Miorelli, kevinsky, mustaccio Jul 16 at 13:06

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Joe Obbish, kevinsky, mustaccio
If this question can be reworded to fit the rules in the help center, please edit the question.

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

  • 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 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 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 at 6:34

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