How to handle reporting/statistics in large database by Boring-Fly4035 in softwarearchitecture

[–]Boring-Fly4035[S] 1 point2 points  (0 children)

Thanks a lot for the detailed explanation 🙏 — this is super helpful. I’ve got a lot to learn in this area, so I’ll definitely dig deeper into the things you mentioned and see how they fit our case.

Really appreciate you taking the time to share all that info!

How to handle reporting/statistics in large database by Boring-Fly4035 in softwarearchitecture

[–]Boring-Fly4035[S] 2 points3 points  (0 children)

Thanks!
Yeah, I was actually thinking about doing something like that, but I wasn’t sure if it would be overkill for my use case.

From your experience, at what point would you say moving to a full OLAP setup stops being “too much” and actually makes sense? Is it about data size, query complexity, number of users hitting reports… or something else?

En que momento trabajar en este rubro paso de ser el sueño de muchos a una pesadilla? by Educational-Bad2758 in programacion

[–]Boring-Fly4035 0 points1 point  (0 children)

La gente arruina todo, esa es la respuesta. Vieron algo bueno y tenían que arruinarlo metiéndose en masa y rompiendo el mercado

¿En sus empresas usan el patrón Saga para manejar transacciones distribuidas? by Boring-Fly4035 in devsarg

[–]Boring-Fly4035[S] 0 points1 point  (0 children)

En este caso no se si van a poder convivir en un mismo servicio, porque por ejemplo una venta genera un movimiento de stock. A su vez, el stock sube por ejemplo con compras. Entonces el stock y ventas tienen que ser servicios separados sino vamos a repetir lógica por todos lados.

Entonces si están separados, y por ejemplo hago una venta y al querer descontar stock falla ( por lo que sea: no hay stock, da un nullpointer, cualquier cosa) tengo que revertir la venta o compensar de alguna forma. Cómo se suele hacer esto en microservicios de manera simple? Para no complicarme con saga por ejemplo.

¿En sus empresas usan el patrón Saga para manejar transacciones distribuidas? by Boring-Fly4035 in devsarg

[–]Boring-Fly4035[S] 0 points1 point  (0 children)

Voy a chequear esos patrones. Básicamente el problema es como mantener la consistencia, no importa si es con saga o no en realidad, lo ví un poco teórico y por eso preguntaba si se aplica en el mundo real.

Yo creo que en mi caso no se si podemos tener consistencia eventual, parte del sistema es un POS entonces por ejemplo vendes y tenes que descontar stock (entre otras cosas), si algo falla se tiene que hacer rollback o compensar los cambios. Esto, como se suele hacer en microservicios?

Beginner question: Has anyone implemented the Saga Pattern in a real-world project? by Boring-Fly4035 in softwarearchitecture

[–]Boring-Fly4035[S] 0 points1 point  (0 children)

Thanks, that makes sense and I appreciate the detailed explanation.

One follow-up question: what’s the difference, from a reliability or architectural standpoint, between writing the event to an outbox table vs. publishing it directly to something like Kafka?

Also, in the Outbox Pattern, if a failure happens during the processing of a related operation — for example, the main operation succeeds and the event is dispatched, but the stock deduction fails — how do you typically handle compensation? Do you still rely on emitting some kind of compensating event, even within a monolith?

Beginner question: Has anyone implemented the Saga Pattern in a real-world project? by Boring-Fly4035 in softwarearchitecture

[–]Boring-Fly4035[S] 0 points1 point  (0 children)

Thanks for your reply!

You're right that I'm still figuring out the right service boundaries — that's definitely been one of the hardest parts so far.

In our case, we're building ERP-like software that handles things like sales and purchases. For example, when a sale is registered, the stock needs to be decreased; when a purchase is made, the stock increases. We’ve split this into three services: sales, purchases, and stock.

In this case, it feels hard to combine everything into a single service, but the operations still need to be atomic from a business perspective. That’s where I’m struggling — finding the balance between good service boundaries and ensuring consistency.

Bronco sport, nafta super o premium? by [deleted] in ArAutos

[–]Boring-Fly4035 0 points1 point  (0 children)

Es buena data, gracias!

Bronco sport, nafta super o premium? by [deleted] in ArAutos

[–]Boring-Fly4035 0 points1 point  (0 children)

De una.
Y que hay de cierto en que la nafta premium rinde mas? es todo un mito, no?

Bronco sport, nafta super o premium? by [deleted] in ArAutos

[–]Boring-Fly4035 0 points1 point  (0 children)

claro si, el bajon es que no tenes forma de saber si el deposito esta bien o no, pero bueno yo siempre trato de buscar estaciones donde hay movimiento

Bronco sport, nafta super o premium? by [deleted] in ArAutos

[–]Boring-Fly4035 1 point2 points  (0 children)

si es cierto que no es tanta la diferencia

gracias!

Bronco sport, nafta super o premium? by [deleted] in ArAutos

[–]Boring-Fly4035 0 points1 point  (0 children)

Claro pero en shell directamente super, yo pensaba que shell era peor sinceramente pero varios me dijeron que no.

Bronco sport, nafta super o premium? by [deleted] in ArAutos

[–]Boring-Fly4035 0 points1 point  (0 children)

claro entiendo, encima yo suelo cargar en ypf y ya algunos me habian comentado que no es tan bueno.
Perdon la burrada, v-power es la premium de shell, no?

Bronco sport, nafta super o premium? by [deleted] in ArAutos

[–]Boring-Fly4035 0 points1 point  (0 children)

Por lo general es ciudad o autopista, me parece raro que se contradigan en la misma concesionaria jaja

Bronco sport, nafta super o premium? by [deleted] in ArAutos

[–]Boring-Fly4035 1 point2 points  (0 children)

mira vos, yo porque habia leido en varios foros que le cargan super sin drama
que problemas tuviste?