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

2021-05-25 Thread Poul Kristensen
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.

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

2021-05-25 Thread Baum Kataster
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

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

2021-05-25 Thread Wen Yi
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!