Best way to store heavily read/edited pdf files : mysql BLOB in db or store as files
I'm building an app that works heavily on pdf files (constantly stored and read , modified ) , would it be to store them in a file storage system and and load bytes to edit them or store them directly as bytes in the db. Files would typically be 100kb - 1/2 mb max. I'm confortable with either Prisma or Drizzle. I'm also using Planetscale and Uploadthing.
2 Replies
Whatever is the cheapest is the way to go. Check your bandwidth prices and decide for it accordingly
We had similar use case in our project.
we started to face issue whenever multiple PDF were requested at same time.
Instead we used s3 to save all our pdf file and its referred url is saved in the DB and the pricing was also relatively cheaper.