Re: Simple question from a beginner: Can I use PostgreSQL as a file database? - Mailing list pgsql-general

From Baum Kataster
Subject Re: Simple question from a beginner: Can I use PostgreSQL as a file database?
Date
Msg-id CAC5HKqC=0fSzTe-=E9a0f_o+qbhkmzoNkUo9it5iyaHDT2=OZw@mail.gmail.com
Whole thread Raw
In response to Simple question from a beginner: Can I use PostgreSQL as a file database?  (Wen Yi <UNYouth@hotmail.com>)
Responses Re: Simple question from a beginner: Can I use PostgreSQL as a file database?
List pgsql-general
Basically, you can store binary data by using blobs but that is not the best practice.
A better approach would be to store your information in the database and to add a varchar column in which you store the folder and file name where the file is stored on your computer. Then you can retrieve it from there without bloating your database through excessive use of blobs.
You can find many good tutorials on PostgreSQL here: https://www.postgresqltutorial.com/

Am Di., 25. Mai 2021 um 13:49 Uhr schrieb Wen Yi <UNYouth@hotmail.com>:
Hi everyone!
I'm a middle student and new to join this mail list.
I just want to ask a simple question:
Can I use PostgreSQL as a file database?
(I plan to make a web system to store my class note with some personal file)
Please give me some suggestions,thank you in advance!

pgsql-general by date:

Previous
From: Wen Yi
Date:
Subject: Simple question from a beginner: Can I use PostgreSQL as a file database?
Next
From: Radomír Kůs
Date:
Subject: pgadmin4 SRPM