mongodb? MySQL? PostgreSQL?

If someone would add pluses and minus, let me know.

Why I ask:

I am a mobile startup. I need a database that supports spatial indexes. The spatial index must be able to do something more sophisticated than simply asking whether a point is in a rectangle. For that one, I do not think we need spatial indexes at all.

At the least I need to be able to find the 20 closest points to a certain location.

Yes, I can put a small rectangle, see if 20 points are there, then make a bigger rectangle. That's reasonable, but I want something simpler and faster.

Basically I just see what other successful startups use and follow. Many recommend mongodb.

closed as not constructive by Nick Chammas, Martin Smith, JNK Jul 2 '12 at 13:25

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 2
    Success isn't necessarily dictated by the underlying tech, it's based on the engineer's ability to use the tech as efficiently as possible (given the organizational understanding of "efficient.") With that said, you need a bit more information in here (what's your application domain? what are the requirements? etc.) in order to get some better information. As it stands, your question risks being closed as rather unanswerable. – swasheck Jun 21 '12 at 19:18

That question is much too vague to answer. The problem defines the solution, not the other way around.

For your specific use-case, I would recommend PostgreSQL + PostGIS. I have no personal experience with PostGIS, but it's a well-supported extension to PostgreSQL.

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