File Sample?

File Sample?

Postby Ekki » Thu 28 Nov 2013 15:57

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
Ekki
 
Posts: 29
Joined: Sun 24 Nov 2013 18:50
Location: Ilmenau, Germany

Re: File Sample?

Postby MariiaI » Fri 29 Nov 2013 15:01

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/postgresql/docs/?Devart.Data.PostgreSql~Devart.Data.PostgreSql.PgSqlLargeObject.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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: File Sample?

Postby Ekki » Fri 29 Nov 2013 15:18

Thanx a lot. Using your information it seems I can implement the request. Have a great weekend!
Ekki
 
Posts: 29
Joined: Sun 24 Nov 2013 18:50
Location: Ilmenau, Germany


Return to dotConnect for PostgreSQL