Hi,
one reason for me for switching over from MySQL to PostgreSQL was that there's a better support for files in PostgreSQL, e.g. stored directly in the file system rather than represented as BLOBs inside the DB.
Does anyone have a hint that can demonstrate how to implement this with the dotConnect tool chain?
Thx alot in advance
Ekki
File Sample?
Re: File Sample?
To work with large files we recommend to use a PgSqlLargeObject class.
Please refer to:
http://wiki.postgresql.org/wiki/BinaryFilesInDB
http://www.devart.com/dotconnect/postgr ... bject.html
If you are using LinqConnect, the more suitable solution for this scenario is to use bytea datatype to store such files in the database and work with them in the application as with array of bytes.
If you have any additional questions, feel free to contact us.
Please refer to:
http://wiki.postgresql.org/wiki/BinaryFilesInDB
http://www.devart.com/dotconnect/postgr ... bject.html
If you are using LinqConnect, the more suitable solution for this scenario is to use bytea datatype to store such files in the database and work with them in the application as with array of bytes.
If you have any additional questions, feel free to contact us.
Re: File Sample?
Thanx a lot. Using your information it seems I can implement the request. Have a great weekend!