search

HR-SDC-PLEIADES / qa-service

Server for Question and Answer Service
0 stars 0 forks source link

Database research #1

Open ptrollins opened 4 years ago

ptrollins commented 4 years ago

Research different database options and decide on two options to compare more thoroughly.

ptrollins commented 4 years ago

Researched relational and non-relational db's. I decided on PostgreSQL as the best option for relational and Cassandra as a possible option for non-relational. Cassandra has the possibility of being very fast with great scalability but the learning curve is high and the data may not be optimal for this type of DB. The data is very easy to break out in a relational schema and is already broken up into files for each table. So I have decided Postgres is the best option at the moment.