Breaking News: Grepper is joining You.com. Read the official announcement!

store numpy array in database

Cook's Tree Boa answered on November 17, 2019 Popularity 5/10 Helpfulness 1/10

answer store numpy array in database

related store numpy array in database

store numpy array in database

Comment

cur.execute("select arr from test")
data = cur.fetchone()[0]

print(data)
# [[ 0  1  2  3  4  5]
#  [ 6  7  8  9 10 11]]
print(type(data))
# <type 'numpy.ndarray'>

Popularity 5/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: database numpy store whatever

Link to this answer
Share Copy Link

Contributed on Nov 17 2019

Cook's Tree Boa

0 Answers Avg Quality 2/10

Closely Related Answers

store numpy array in database

Comment

import sqlite3
import numpy as np
import io

def adapt_array(arr):
    """
    http://stackoverflow.com/a/31312102/190597 (SoulNibbler)
    """
    out = io.BytesIO()
    np.save(out, arr)
    out.seek(0)
    return sqlite3.Binary(out.read())

def convert_array(text):
    out = io.BytesIO(text)
    out.seek(0)
    return np.load(out)


# Converts np.array to TEXT when inserting
sqlite3.register_adapter(np.ndarray, adapt_array)

# Converts TEXT to np.array when selecting
sqlite3.register_converter("array", convert_array)

x = np.arange(12).reshape(2,6)

con = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_DECLTYPES)
cur = con.cursor()
cur.execute("create table test (arr array)")

Popularity 5/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: numpy whatever store database

Link to this answer
Share Copy Link

Contributed on Nov 17 2019

Cook's Tree Boa

0 Answers Avg Quality 2/10

store numpy array in database

Comment

cur.execute("insert into test (arr) values (?)", (x, ))

Popularity 5/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: database numpy store whatever

Link to this answer
Share Copy Link

Contributed on Nov 17 2019

Cook's Tree Boa

0 Answers Avg Quality 2/10

store numpy array in database

Contents

More Related Answers

store numpy array in database

Closely Related Answers

store numpy array in database

store numpy array in database

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.