budleigh_s

30 ms·

1. 1.▲
   by budleigh_s 2y ago

   > Running arbitrary queries on your customer's database primary is simply never safe, nor can it be made safe Look, the only thing that's never safe is speaking in absolutes. > It's not a question of the DB running a li
2. 2.▲
   by budleigh_s 2y ago

   > The only reasonable way to do this safely is by querying a read replica. I agree - this is a very good approach with the most amount of control around how often you need fresh data, how to trigger that etc. Although, not every integrat
3. 3.▲
   by budleigh_s 2y ago

   I'm thinking that much of the architecture around building APIs in front of databases stems from the religious approach to SOA over HTTP/REST. I don't see much wrong with this as to me the database is still a sort of an API w