3 ms·
> "We use MySQL, MongoDB, PostgreSQL, and Impala." Thanks for the clarification, but this makes it even more obvious your engineering team is introducing needl
by dennis82 14y ago
> "We use MySQL, MongoDB, PostgreSQL, and Impala."
Thanks for the clarification, but this makes it even more obvious your engineering team is introducing needless complexity into your organization.
Postgres can store unstructured data just fine, so you have a 'solution' that uses 3 OLTP stores instead of one.
- taligent 14y agoPostgreSQL is awful for storing unstructured data. It is the most cumbersome, clunky syntax I've seen for a while and it lacks ORM support meaning you are forced to manually write it. Making developers productive is an important aspect for choosing a database.
- gfodor 14y agoChoosing a data store based upon syntax and slightly limited ORM support isn't exactly a great idea. Both of these things can be improved rapidly with a little code. More important questions are how is the data stored, how is it accessible, how can you scale the system, what operational constraints are there, how fast is it, what types of data modeling can be done, what consistency/transaction guarantees does it provide, etc. These are the things that will make developers productive because they will not be putting out fires all the time.
- dennis82 14y agowell said!