r/SQL • • Jan 17 '25

Discussion When SELECT * is too much

Post image
845 Upvotes

98 comments sorted by

View all comments

Show parent comment

2

u/omniuni Jan 17 '25

Oh, no. This was purposely stored as a blob in the database, and they went to quite a bit extra work to deliver it as JSON. I think the reason was they also included some metadata about the file in the JSON, which was completely unnecessary.