Dataframe to postgresql - Saving the dataframe to memory using StringIO

[Marco Sulla]

Never worked with ZFS, it sounds interesting. Anyway, IMHO it's much more
simple to save to disk also for debugging: you have not to extract the data
from the db if you need to inspect them.

On Thu, 22 Oct 2020 at 14:39, D'Arcy Cain <darcy at vybenetworks.com> wrote:

> 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
> --
> https://mail.python.org/mailman/listinfo/python-list
>