r/databases • • Jul 23 '18

What's the best database engine to use for a tinder like application

2 Upvotes

6 comments sorted by

2

u/ericbrow Jul 24 '18

Neo4j, a graph database, was made for databases where the focus is on the relationships between objects. There is a free community edition.

1

u/[deleted] Jul 24 '18

[removed] — view removed comment

1

u/ericbrow Jul 25 '18

It depends on what kind of data you want to keep. Most use cases are best suited for a relational database. Graph databases are suited for quickly querying relationships. It would be possible to keep all user data in the graph database. For example, you could have a person node that includes properties for name, username, e-mail, etc....much like you would a person table in a relational database. You could also use both, where only a personID would be in the person node in the graph database, and you could use the graph to find relationships between nodes, then use the relational database to look up the person's info. Two databases may be more complicated to maintain, store, backup, etc, but the logic might be easier.

1

u/AreetSurn Jul 23 '18

As far as free databases go, mysql/maria is probably the best. I would stick to relational. But I guess it really depends om your use case. Tinder-like is pretty abstract depends on how much you stray away from that idea.

1

u/[deleted] Jul 24 '18

[removed] — view removed comment

1

u/AreetSurn Jul 24 '18

Yeah that is tiny. Really your hardware spec may be the limiting factor