This might be a little dumb question but why do we save text in the db instead of something smaller?Couldn't there be some other way to store data in the db like in a compressed form, and then have our computer, which wants the data, uncompress the data from the db? What I mean is to put the load on the computers and not on the db and bandwidth.Like let's say we store compressed form in the db, and have all the computing done by the user's computer. So if we would do a select statement it would compresse it into something only the db understands, and get back the compressed data which our computer would uncompress and show in the same way we get it now? or is text better?Wouldn't that be better considering there's usually a lot of load on the db and that it usually can become quite large? but if the data would be compressed already it would take up less space at least
Why does databases use text?
sql;mysql;sql server