I have an application that collects thousands of PDF files each year. Instead of storing the actual files inside the database, we organize them in a structured subdirectory and only record the file name and location in the database.
The reasoning is simple: once collected, these PDFs don’t change. If they were stored directly in the database, it would grow unnecessarily large, and every backup would include the same static, unchanged data — wasting disk space and time. By keeping the database lean and storing the PDFs externally, backups remain efficient and the files are still accessible to other applications when needed. Of course, your application may have different requirements, so this approach might not be the optimal strategy in every case. Javier, Javier Valencia, PE 14315 S Twilight Ln Olathe, KS 66062 913-915-3137 From: [email protected] <[email protected]> On Behalf Of [email protected] Sent: Wednesday, November 26, 2025 3:28 PM To: RBASE-L <[email protected]> Subject: [RBASE-L] - Saving PDF inside DB Hello everyone, I have used R:base to store all kinds of images (BMP,PNG,JPG,ICO, etc) without a problem, but it seem that I missed out the class on how to store and retrieve a PDF file. Is there anyone who has done that (I imagine the answer is yes) and care to tell me what I'm doing wrong? Thank you in advance for the help you can give me. Dr. Robert Rugilo -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . To view this discussion visit https://groups.google.com/d/msgid/rbase-l/cc100161-466b-494f-9f37-bbfce51c8a10n%40googlegroups.com <https://groups.google.com/d/msgid/rbase-l/cc100161-466b-494f-9f37-bbfce51c8a10n%40googlegroups.com?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/0da801dc5fbe%24ee43fbd0%24cacbf370%24%40vtgonline.com.
