‫Horizontal partitioning or just partitioning versus SHARDEY?
‫So, guys, we made a video about sharding partitioning, but the story is very interesting and let's
‫discuss the difference between the two horizontal partition.
‫We just partition splits the big table into multiple tables in the same database.
‫And the database takes care of the management of these partition you as a client, as a query builder.
‫You have no idea what partition you're hitting.
‫The database is designing.
‫So that's why I said the client is agnostic.
‫It doesn't care which partition is going to hit the database.
‫I'm sending my own beautiful query and the database decides which partition to head based on the logic
‫on the where clause.
‫So that's the trickier.
‫Sharding, on the other hand, splits the big table into all the multiple tables.
‫However, they are completely different servers.
‫They are on a completely different database server.
‫And you do this for for distributed essentially processing.
‫Right.
‫So like, let's throw this into different tables.
‫Right.
‫All together in different servers altogether.
‫So that like basically for latency issues, like I say, California customers, we're going to put a
‫database, Shahd, just for California customers.
‫And you're going to hit if you're from California, we're going to hit you based on on a like a proxy
‫school.
‫We're going to detect where IP addresses are from and we're going to serve you to the database or if
‫it's read, for example, to the database instance that has the California table.
‫Right.
‫Versus if you're going from Asia, we're going to hit you with an Asian server.
‫Right.
‫So that's the Hidatsa IP address is different, completely different IP address.
‫So that's a beautiful, beautiful design.
‫Obviously, it's a little bit complicated, but but yeah.
‫So if you think about it, the client is aware of the of the Shard.
‫Right.
‫Which is Bignone on and sharding.
‫That's that's one of the big thing that I don't like about Chani.
‫And I know Vitesse and other technologies are trying to solve this.
‫But still it's a it's a it's a big it's a big investment for anyone back engineers.
‫So the table names, this is like a little bit of just detail the horizontal partitioning table name
‫changes of that back end.
‫You have like multiple table names and they are changed.
‫Right.
‫However, in the Sharding case, the timetabling stays the same almost.
‫Right.
‫Because the query is exactly identical.
‫Doesn't change.
‫Right.
‫But the server way to which you're executing the query against actually changes.