Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to use sqlite3 in python on FreeBSD 10.3?

250 views
Skip to first unread message

Nan Xiao

unread,
Jun 15, 2016, 7:26:11 AM6/15/16
to
Hi all,

Greetings from me! I am a newbie of FreeBSD, and want to use sqlite3 in python on my FreeBSD 10.3. After installing python, it prompts I should install the following additional packages:

......
===========================================================================
Note that some standard Python modules are provided as separate ports
as they require additional dependencies. They are available as:
bsddb databases/py-bsddb
gdbm databases/py-gdbm
sqlite3 databases/py-sqlite3
tkinter x11-toolkits/py-tkinter
===========================================================================
From this post, it seems after installing above 4 packages, the sqlite3 should be able to work. But "impore sqlite3" still reports following errors:

>>> import sqlite3
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/local/lib/python2.7/sqlite3/__init__.py", line 24, in <module>
from dbapi2 import *
File "/usr/local/lib/python2.7/sqlite3/dbapi2.py", line 28, in <module>
from _sqlite3 import *
ImportError: No module named _sqlite3

Could anyone help on this issue? Thanks very much in advance!

Have a nice day!

P.S., I also submit this issue on SO, but unfortunately, I can't get any help from there, so I repost the question here, thanks!



Best Regards
Nan Xiao (肖楠)
Skype: xiaonan19830818
Jabber/XMPP: nan...@xmpp.ru.net
Telegram: nanxiao
Personal website (Chinese): http://nanxiao.me/
Personal website (English): http://nanxiao.me/en
Chinese DTrace website: http://chinadtrace.org/
_______________________________________________
freebsd-...@freebsd.org mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questi...@freebsd.org"

Eir Nym

unread,
Jun 15, 2016, 8:13:34 AM6/15/16
to
Hi, Nan,


> On 15 Jun 2016, at 12:32, Nan Xiao <n...@chinadtrace.org> wrote:
>
> Hi all,
>
> Greetings from me! I am a newbie of FreeBSD, and want to use sqlite3 in python on my FreeBSD 10.3. After installing python, it prompts I should install the following additional packages:
>
> ......
> ===========================================================================
> Note that some standard Python modules are provided as separate ports
> as they require additional dependencies. They are available as:
> bsddb databases/py-bsddb
> gdbm databases/py-gdbm
> sqlite3 databases/py-sqlite3
> tkinter x11-toolkits/py-tkinter
> ===========================================================================
> From this post, it seems after installing above 4 packages, the sqlite3 should be able to work. But "impore sqlite3" still reports following errors:
>
>>>> import sqlite3
> Traceback (most recent call last):
> File "<stdin>", line 1, in <module>
> File "/usr/local/lib/python2.7/sqlite3/__init__.py", line 24, in <module>
> from dbapi2 import *
> File "/usr/local/lib/python2.7/sqlite3/dbapi2.py", line 28, in <module>
> from _sqlite3 import *
> ImportError: No module named _sqlite3
>
> Could anyone help on this issue? Thanks very much in advance!
>

You should install databases/py-sqlite3 port for your system. This port as any other python library depends on python versions installed. You can read about specifying python version to build this library for in Handbook.

Dean E. Weimer

unread,
Jun 15, 2016, 8:57:51 AM6/15/16
to
> Have a nice day!
>
> P.S., I also submit this issue on SO, but unfortunately, I can't get
> any help from there, so I repost the question here, thanks!
>

use "pkg info | grep py" and verify that the packages did install
correctly, from one of my systems running Python with py-sqlite3, it
works fine. I am running WeeWX on this system which even though I am
using mySQL for most of the data, it still has some dependency on
sqlite3, so not only does it import, but I have applications using
py-sqlite3.

pkg info | grep py
py27-Babel-2.3.4 Collection of tools for
internationalizing Python applications
py27-Jinja2-2.8 Fast and easy to use stand-alone template
engine
py27-MarkupSafe-0.23 Implements XML/HTML/XHTML Markup safe
string for Python
py27-MySQLdb56-1.2.5 Access a MySQL database through Python
py27-alabaster-0.7.6 Modified Kr Sphinx theme
py27-cheetah-2.4.4_1 HTML template engine for Python
py27-configobj-5.0.6_1 Simple but powerful config file reader
and writer
py27-dnspython-1.12.0 DNS toolkit for Python
py27-docutils-0.12 Python Documentation Utilities
py27-imagesize-0.7.1 Python image size library
py27-markdown-2.6.5 Python implementation of Markdown
py27-pillow-3.1.1_1 Fork of the Python Imaging Library (PIL)
py27-pip-8.0.2 Tool for installing and managing Python
packages
py27-pycurl-7.21.5 Python interface to libcurl
py27-pygments-2.1.3 Syntax highlighter written in Python
py27-pystemmer-1.3.0_1 Snowball Stemming Algorithms for
Information Retrieval
py27-pytz-2016.4,1 World Timezone Definitions for Python
py27-setuptools27-20.0 Python packages installer
py27-six-1.10.0 Python 2 and 3 compatibility utilities
py27-snowballstemmer-1.2.0_1 Snowball stemming library collection for
Python
py27-sphinx-1.4.1 Python documentation generator
py27-sphinx_rtd_theme-0.1.9 Mobile-friendly py-sphinx theme
py27-sqlite3-2.7.11_7 Standard Python binding to the SQLite3
library (Python 2.7)
py27-tkinter-2.7.11_6 Python bindings to the Tk widget set
(Python 2.7)
py27-usb-1.0.0b1_1 Python wrapper around libusb
pyephem-3.7.6.0,1 Scientific-grade astronomical
computations for Python
python-2.7_2,2 The "meta-port" for the default version
of Python interpreter
python2-2_3 The "meta-port" for version 2 of the
Python interpreter
python27-2.7.11_2 Interpreted object-oriented programming
language
python3-3_3 The "meta-port" for version 3 of the
Python interpreter
python34-3.4.4_2 Interpreted object-oriented programming
language
root@weewx:/ # python
Python 2.7.11 (default, Jun 10 2016, 09:38:24)
[GCC 4.2.1 Compatible FreeBSD Clang 3.4.1 (tags/RELEASE_34/dot1-final
208032)] on freebsd10
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>>

make sure that the py27_sqlite3 or py34-sqlite3 depending on which you
are trying to use is installed. I have Python 2.7 set as system default
do to some requirements on the software. But also have Python 3.4
installed for some custom system maintenance scripts I have written,
those fortunately don't require any other python dependencies so it
seems to work OK having both installed.

--
Thanks,
Dean E. Weimer
http://www.dweimer.net/

Nan Xiao

unread,
Jun 15, 2016, 8:18:25 PM6/15/16
to
Hi Dean, Eir, and all,

Thanks very much for your kind help and time!

After using "pkg info | grep py", I find I have installed "databases/sqlite3" not "databases/py-sqlite3"!

I am very sorry for my stupid fault, anyway, thanks very much for all help again!



Best Regards
Nan Xiao (肖楠)
Skype: xiaonan19830818
Jabber/XMPP: nan...@xmpp.ru.net
Telegram: nanxiao
Personal website (Chinese): http://nanxiao.me/
Personal website (English): http://nanxiao.me/en
Chinese DTrace website: http://chinadtrace.org/

0 new messages