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

Поиск
Список
Период
Сортировка
От Poul Kristensen
Тема Re: Simple question from a beginner: Can I use PostgreSQL as a file database?
Дата
Msg-id CAAOuvVp5eeOKWi2nnPA+gm-r8L45p660ZsY6KKHRGP9ov0puKw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Simple question from a beginner: Can I use PostgreSQL as a file database?  (Baum Kataster <treeclimate@gmail.com>)
Список pgsql-general
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@gmail.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@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!


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

В списке pgsql-general по дате отправления:

Предыдущее
От: Ashesh Vashi
Дата:
Сообщение: Re: pgadmin4 SRPM
Следующее
От: Hellmuth Vargas
Дата:
Сообщение: Re: ON CONFLICT DO NOTHING ignored on bulk insert