Skip to content

Instantly share code, notes, and snippets.

@jdbfsilva
jdbfsilva / numpy-sqlite3.py
Created October 9, 2020 19:37 — forked from pnavarro-algometrics/numpy-sqlite3.py
Insert numpy array into a sqlite3 database
import sqlite3
import numpy
# Array of 4 columns and 100 rows
data = numpy.random.rand(100, 4)
# Create a sample database
conn = sqlite3.connect('/tmp/sample.db')
cursor = conn.cursor()