SQLite Forum

python sqlite3 not support numpy type?
Login
First off, the [set of data types natively supported by SQLite][1] is small. SQLite is not going to natively support every possible data type in every programming language that has a SQLite binding.

The Python SQLite binding could provide a *mapping* between numpy data types and SQLite data types, but that's entirely off-topic here. Take it up with the maintainer of your `sqlite3` module. This appears to be a core Python module, so my outsider's guess would be to post to [the Python ideas mailing list][2]. There may be a more appropriate place to send it, though.

Regardless, SQLite cannot affect what Python and numpy do. It's just a data storage engine. It takes what its callers give it, stores it, and offers ways to retrieve the data later. Data mappings are at a layer above that.


[1]: https://www.sqlite.org/datatype3.html
[2]: https://mail.python.org/mailman3/lists/python-ideas.python.org/