<div dir="ltr">Hi Andrew,<div><br></div><div>Please see the answer at <a href="https://stackoverflow.com/questions/44288891/pony-orm-and-a-micro-service-architecture/44360737#44360737">https://stackoverflow.com/questions/44288891/pony-orm-and-a-micro-service-architecture/44360737#44360737</a></div><div><br></div><div>Best,</div><div>Alexey</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, May 31, 2017 at 1:45 PM, Andrew Graham-Yooll <span dir="ltr"><<a href="mailto:andrew@solarisoffgrid.com" target="_blank">andrew@solarisoffgrid.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div><p style="margin:0px 0px 1em;padding:0px;border:0px;font-variant-ligatures:normal;font-variant-numeric:inherit;font-stretch:inherit;line-height:inherit;font-family:Arial,'Helvetica Neue',Helvetica,sans-serif;vertical-align:baseline;clear:both;color:rgb(36,39,41);background-color:rgb(255,255,255)"><font size="2">Hello all,</font></p><p style="margin:0px 0px 1em;padding:0px;border:0px;font-variant-ligatures:normal;font-variant-numeric:inherit;font-stretch:inherit;line-height:inherit;font-family:Arial,'Helvetica Neue',Helvetica,sans-serif;vertical-align:baseline;clear:both;color:rgb(36,39,41);background-color:rgb(255,255,255)"><font size="2">We have a monolithic application built with a Flask/Pony framework. It works great right now.</font></p><p style="margin:0px 0px 1em;padding:0px;border:0px;font-variant-ligatures:normal;font-variant-numeric:inherit;font-stretch:inherit;line-height:inherit;font-family:Arial,'Helvetica Neue',Helvetica,sans-serif;vertical-align:baseline;clear:both;color:rgb(36,39,41);background-color:rgb(255,255,255)"><font size="2">However, in the near future we are going to start shifting to a micro-service architecture. In this process, we are going to most likely have a separate Db for each service. For a number of reasons that I wont go into, this is beneficial. But i get hung up, and I know many others do too, when thinking about the foreign key relationships developed between tables at the moment.</font></p><p style="margin:0px 0px 1em;padding:0px;border:0px;font-variant-ligatures:normal;font-variant-numeric:inherit;font-stretch:inherit;line-height:inherit;font-family:Arial,'Helvetica Neue',Helvetica,sans-serif;vertical-align:baseline;clear:both;color:rgb(36,39,41);background-color:rgb(255,255,255)"><font size="2">People have solved this by denormalizing their db's ending up with duplicated tables in another service's DB.</font></p><p style="margin:0px 0px 1em;padding:0px;border:0px;font-variant-ligatures:normal;font-variant-numeric:inherit;font-stretch:inherit;line-height:inherit;font-family:Arial,'Helvetica Neue',Helvetica,sans-serif;vertical-align:baseline;clear:both;color:rgb(36,39,41);background-color:rgb(255,255,255)"><font size="2">Im curious what the users of pony think of this solution and if its feasible.</font></p><p style="margin:0px 0px 1em;padding:0px;border:0px;font-variant-ligatures:normal;font-variant-numeric:inherit;font-stretch:inherit;line-height:inherit;font-family:Arial,'Helvetica Neue',Helvetica,sans-serif;vertical-align:baseline;clear:both;color:rgb(36,39,41);background-color:rgb(255,255,255)"><font size="2">And what have others using PonyORM, or any other ORM for that matter, come up with when using a micro service architecture?</font></p><div>Thanks</div></div><div>Andrew</div></div>
<br>
<div><a href="http://www.solarisoffgrid.com/#what-we-do" target="_blank"><br></a></div><a href="http://www.solarisoffgrid.com/#what-we-do" target="_blank"><img src="http://www.solaris.co.tz/footer_transition_bis.jpg"></a><br>______________________________<wbr>_________________<br>
ponyorm-list mailing list<br>
<a href="mailto:ponyorm-list@ponyorm.org">ponyorm-list@ponyorm.org</a><br>
<a href="/ponyorm-list" rel="noreferrer" target="_blank">https://mailman-mail5.<wbr>webfaction.com/listinfo/<wbr>ponyorm-list</a><br>
<br></blockquote></div><br></div>