Re: Simple question from a beginner: Can I use PostgreSQL as a file database?

https://Dataverse.org is used by The Royal Danish Library (I have made a
setup while employed there) - glassfish server with PostgreSQL as
databasebackend. A very detailed documentation of how to setup is available
too.
Works fine and is free. Be sure to follow recommendations from
dataverser.org.

/Poul

Den tir. 25. maj 2021 kl. 14.01 skrev Baum Kataster <treeclimate(at)gmail(dot)com>:

> 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(at)hotmail(dot)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!
>>
>

--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA