如果已有SQLite
、
PostgreSQL
或
MySQL
数据库,可以参考快速入门指南(
https://dataset.readthedocs.io/en/latest/quickstart.html)直接连接。
然后安装
Dataset,
pip install dataset。
代码示例:
import dataset
'''
# connecting to a SQLite database
db = dataset.connect('sqlite:///mydatabase.db')
# connecting to a MySQL database with user and password
db = dataset.connect('mysql://user:password@localhost/mydatabase')
# connecting to a PostgreSQL database
db