Reputation
2,074
Next privilege 2,500 Rep.
Create tag synonyms
Badges
4 20 44
Impact
~133k people reached

Jan
7
awarded  Good Question
Oct
12
awarded  Yearling
Sep
5
awarded  Famous Question
Sep
2
awarded  Popular Question
Jul
10
awarded  Notable Question
Jul
6
awarded  Notable Question
Jun
2
awarded  Popular Question
Mar
20
awarded  Curious
Feb
6
awarded  Notable Question
Dec
15
accepted Using audit trail as time machine?
Dec
4
asked Using audit trail as time machine?
Nov
28
awarded  Notable Question
Nov
27
comment Why is it so bad to read data from a database “owned” by a different microservice
@back2dos I agree that it is not optimal, but what it allows me to do is to write an SQL select query for data mining or rapid prototyping purposes, which selects across microservices. This means that a person, with just some SQL knowledge can gain insights into our data without having to know how to program. It is also much faster than having to do the selecting across microservices in a programming language.
Nov
27
comment Why is it so bad to read data from a database “owned” by a different microservice
@back2dos Please note this part of my question: "One could for example say that only a few database views are accessible outside the micro service so that the team maintaining the micro service know that as long as they keep these views intact then they can change the database structure of their micro service as much as they want." Shouldn't it be possible to keep a view intact while changing the tables the view selects from from RDBMS to document based?
Nov
26
comment Why is it so bad to read data from a database “owned” by a different microservice
I agree that the view would simply be a form of an API. I think most people answering this question do not read my idea about using views as a level of abstraction. I understand, though that keeping the view intact if one changed the database technology would be a major challenge, but I am willing to bet on that we will not need to change our database technology for the next 5 years. Also, performance will not be a problem with just 5 mill users. So, given our size, I thank I will go for this solution, even though the answers here seem to indicate that I am heading straight to a world of pain.
Nov
26
awarded  Nice Question
Nov
25
revised Why is it so bad to read data from a database “owned” by a different microservice
edited title
Nov
25
awarded  Popular Question
Nov
25
accepted Why is it so bad to read data from a database “owned” by a different microservice
Nov
25
comment Why is it so bad to read data from a database “owned” by a different microservice
This is a great point! One thing that makes me less concerned is that Postgres now has support for both document store and RDBMS (withouttheloop.com/articles/2014-09-30-postgresql-nosql). Your point is still valid, though, and I will consider it carefully.