What's new
- Removed psycopg2 requirement (dependency)
- Dependency calls were replaced by an abstract classes
- ABColumn replaced by child classes SQLite3xColumn PostgreSQLxColumn
- Fixing typing issues
- Docs update (issue https://github.com/v1a0/sqllex/issues/60)
- Tests structure changed, finished tests for postgresqlx
- Changed abstractions sructure for psql engine ([v0.3.0b2](https://github.com/v1a0/sqllex/commit/863f7f26a286c8006e828fbcdc945946d9a623c8))
- Minor bugfix
How to use Postgres now
Due to `psycopg2` was removed from sqllex dependencies now you have to install it manually for postures support (or you can use any similar engine). After this just add one new parameter ("engine") into PostgreSQLx constructor:
python
import psycopg2
db = sx.PostgreSQLx(
engine=psycopg2, Postgres engine
...
)
Read [PostgreSQLx docs](https://github.com/v1a0/sqllex/blob/main/docs/about-postgresqlx.md) for more details.
Why **psycopg2** is not "from-the-box" anymore
Many developers who use sqllex only to work with SQLite have complained about problems installing the package due to the psycopg2 dependency. I also had these difficulties. One and only decision was to install this dependency manually from binaries. Therefore, it was decided to rid the library of a problematic dependency, but leave the ability to connect it back as needed.