[SciPy-user] storing numpy arrays

Conor Robinson conor.robinson at gmail.com
Thu Mar 12 17:39:15 EDT 2009


Look into pytables.

On Thu, Mar 12, 2009 at 2:35 PM, Michael Hearne <mhearne at usgs.gov> wrote:

> I have a MySQL database, in which I would like to store a numpy array as
> a BLOB.  I'm trying to find out the easiest/most efficient way to
> store/extract this data.
>
> I looked at scipy.io.write_array, which looked somewhat promising, until
> I saw the notice that this method is deprecated in favor of numpy.savetxt.
>
> I could potentially use scipy.io.savemat/loadmat, but that would require
> writing to a binary (.mat file), then reading it back in again just to
> stuff it into the database.
>
> I could also use pickle, but I found a bug report somewhere that pickle
> may do strange things to the array in the process or reading or writing.
>
> Does anyone have any suggestions?
>
> Thanks,
>
> Mike
>
> _______________________________________________
> SciPy-user mailing list
> SciPy-user at scipy.org
> http://mail.scipy.org/mailman/listinfo/scipy-user
>



-- 
Conor Robinson | Emergent Analytics, Inc.

Cell: 530.318.7354
Office: 949.873.5150
Fax: 714.776.0534

---
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. If you are not the intended recipient you are
notified that disclosing, copying, distributing or taking any action in
reliance on the contents of this information is strictly prohibited.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.scipy.org/pipermail/scipy-user/attachments/20090312/9bc01383/attachment.html>


More information about the SciPy-User mailing list