Skip to content

SQLLEX v0.3.0
Compare
Choose a tag to compare
@v1a0 v1a0 released this 02 Apr 05:50
· 5 commits to main since this release
v0.3.0
16f01f1

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 #60)
  • Tests structure changed, finished tests for postgresqlx
  • Changed abstractions sructure for psql engine (v0.3.0b2)
  • 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:

import psycopg2

db = sx.PostgreSQLx(
    engine=psycopg2,        # Postgres engine
    ...
)

Read PostgreSQLx docs 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.

Assets 2
Loading