nsj-sql-utils-lib

What it is and what it does

nsj-sql-utils-lib is a collection of Python utilities for database operations, centered on simplifying DAO (Data Access Object) implementation and database connection management. It provides adapter classes for PostgreSQL (via psycopg2) and MySQL (via mysql-connector-python), a standalone PostgreSQL connection handler, and a command-line database updater for applying versioned schema migrations from a structured file hierarchy.

The package is designed for teams building systems with direct database access, offering helpers to reduce boilerplate when constructing SELECT, INSERT, and UPDATE statements. The db-updater subcommand allows you to manage database schema changes from a directory structure (functions, scripts, views) and can be invoked via pip or Docker. It depends on SQLAlchemy, sqlparams, and python-logging-loki alongside the database drivers.

Use it for:

• Build DAO classes for PostgreSQL or MySQL without writing repetitive SQL construction code.
• Manage database schema migrations and function deployments using the db-updater CLI with version tracking.
• Wrap existing psycopg2 or MySQL connections in a standardized adapter interface for consistent query building.
• Automate database updates in Docker environments using the provided updater image.
• Centralize database utility logic across multiple projects in a single installed library.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Provides Python utilities for database access, including DAO helpers, connection adapters for PostgreSQL and MySQL, and a command-line database updater for managing schema migrations.

Yes, if you need DAO utilities and a lightweight database updater for PostgreSQL or MySQL. The low install friction and absence of known vulnerabilities are positives. However, the aging maintenance status (382 days since last release) and unclear license mean you should verify the license terms and accept slower updates. Not suitable for projects requiring active support or strict license compliance.

Install

nsj-sql-utils-lib on PyPI

pip install nsj-sql-utils-lib

uv add nsj-sql-utils-lib

poetry add nsj-sql-utils-lib

Installing nsj-sql-utils-lib

Before you install

Low install friction with a pure-Python wheel. Maintenance status is aging—last release was 382 days ago—so expect slower response to issues, though the package remains functional for its stated purpose.

License in practice

License status is unclear; no SPDX identifier or raw license text is available. Review the repository before adopting in a commercial or restricted-license context.

Quickstart

pip install nsj-sql-utils-lib

from nsj_sql_utils_lib.dao_util import dbadapter3
adapter = dbadapter3.DbAdapter(connection)
# Use adapter to build DAO queries

Requires one of the runtime database drivers (psycopg2_binary for PostgreSQL, mysql-connector-python for MySQL) to be installed separately.

Verify before relying

• Whether the package is actively maintained or in maintenance-only mode given the 382-day gap since last release.
• Specific Python version compatibility beyond the stated >=3.4 requirement.
• Whether the db-updater CLI is production-ready or still in alpha (classifier shows Development Status :: 3 - Alpha).

Package facts

Evidence: nsj_sql_utils_lib-2.1.3-py3-none-any.whl

Tags

More Libraries packages