Dataframe to postgresql - Saving the dataframe to memory using StringIO

D'Arcy Cain darcy at VybeNetworks.com
Thu Oct 22 08:37:15 EDT 2020


On 10/22/20 7:23 AM, Marco Sulla wrote:
> I would add that usually I do not recommend saving files on databases. I
> usually save the file on the disk and the path and mime on a dedicated
> table.

I used to do that because backing up the database became huge.  Now I use 
ZFS snapshots with send/receive so the backup only copies the changed blocks 
so I keep it in the database.  That way the data is available from any 
client with database access without the need to give access to the server.

PostgreSQL can handle it.

-- 
D'Arcy J.M. Cain
Vybe Networks Inc.
A unit of Excelsior Solutions Corporation - Propelling Business Forward
http://www.VybeNetworks.com/
IM:darcy at VybeNetworks.com VoIP: sip:darcy at VybeNetworks.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature
Type: application/pgp-signature
Size: 236 bytes
Desc: OpenPGP digital signature
URL: <https://mail.python.org/pipermail/python-list/attachments/20201022/a660eef4/attachment.sig>


More information about the Python-list mailing list