News for hackers. Stuff that matters.

A comment on Monoliths Are the Future. Parent comment

Re:Monoliths Are the Future by jsjohnst on Thursday January 30, 2020 @01:56PM (#22194182)
But I’d argue Monoliths don’t have anything inherent to them which makes reporting easier. A proper BI setup requires a lot of hard work no matter how the backend services are built.
[ Parent | on HN ]
Re:Monoliths Are the Future by BrentOzar on Thursday January 30, 2020 @01:59PM (#22194217)
> But I’d argue Monoliths don’t have anything inherent to them which makes reporting easier.

It's easier to join tables in databases that live on a single server, in a single database platform, than it is to connect to lots of different data sources that live in different servers, possibly even in different locations (like cloud vs on-premises, and hybrids.)

[ Parent | on HN ]
Re:Monoliths Are the Future by jsjohnst on Thursday January 30, 2020 @02:13PM (#22194369)
> It's easier to join tables in databases that live on a single server, in a single database platform

1) what if your data set is larger than you can practically handle in a single DB instance?

2) nothing about a monolith implies you have a single data platform, let alone a single DB instance

[ Parent | on HN ]
Re:Monoliths Are the Future by BrentOzar on Thursday January 30, 2020 @03:02PM (#22194899)
> 1) what if your data set is larger than you can practically handle in a single DB instance?

I have clients at 10TB-100TB in a single SQL Server. It ain't a fun place to be, but it's doable.

[ Parent | on HN ]
Re:Monoliths Are the Future by jaxn on Thursday January 30, 2020 @02:35PM (#22194612)
Monoliths have an advantage up until the point where you have to shard the database in some way.
[ Parent | on HN ]