A simplier way to access SQLite tables, just like Numpy structured arrarys or Pandas dataframes.
>>> from dbastable import SQLDatabase
>>> db = SQLDatabase('test.db', autocommit=True)
>>> db.add_table('table1')
>>> db['table1']['col1'] = [1, 2, 3, 4]
>>> db['table1']['col2'] = ['a', 'b', 'c', 'd']
>>> print(db['table1'][2].values)
(3, 'c')
Its design is based mainly in the way you interact with Numpy structured arrays, Pandas dataframes and Astropy Tables, while keep the possibility of non-volatile and in-disk data storage.
The design of this package was made for very simple interactions with Python's sqlite implementation, so you can interact with sqlite databases without know SQL commands. So, if you need to work with simple tables, composed by columns of data in standard python formats and don't want to perform SQL queries manually, may be this package is for you.
As menioned above, we intended to perform only simple operations with this package. So, we intentionally limited the functionality. Do not expect perform complex queries here. This package is for simplicity. There are several alternatives that are more feature-complete.
I'm not a SQL master, nor a digital security guru. I'm an astrophysicist that do some python. So, if you want to use it, use with care.
The easiest way to install dbastable is via pip
pip install dbastable
Alternatively, you can clone the repository and install it manually:
git clone
cd dbastable
pip install -U .
or
pip install -U git+https://github.com/juliotux/dbastable
Development version is also available in pip:
pip install -U --pre dbastable
The documentation is available at https://dbastable.readthedocs.io/en/latest/
dbastable is licensed under the terms of the MIT license. See the file LICENSE for information on the history of this software, terms & conditions for usage, and a DISCLAIMER OF ALL WARRANTIES.