1. SimpleSQLite¶
1.1. Summary¶
SimpleSQLite is a Python library to simplify SQLite database operations: table creation, data insertion and get data as other data formats. Simple ORM functionality for SQLite.
1.2. Features¶
Automated SQLite table creation from data
- Support various data types of record(s) insertion into a table:
dict
namedtuple
list
tuple
- Create table(s) from:
CSV file/text
JSON file/text
pandas.DataFrame instance
tabledata.TableData instance loaded by pytablereader
- Get data from a table as:
pandas.DataFrame instance
tabledata.TableData instance
Simple object-relational mapping (ORM) functionality
2. Installation¶
2.1. Install from PyPI¶
pip install SimpleSQLite
2.2. Install from PPA (for Ubuntu)¶
sudo add-apt-repository ppa:thombashi/ppa
sudo apt update
sudo apt install python3-simplesqlite
3. Dependencies¶
3.1. Optional Dependencies¶
- loguru
Used for logging if the package installed