Product
Introducing License Enforcement in Socket
Ensure open-source compliance with Socket’s License Enforcement Beta. Set up your License Policy and secure your software!
DbCls is a versatile client for multiple databases, enabling the editing and preservation of SQL queries in a file, and executing queries directly from the editor, thereby providing a convenient interface for data representation.
Briefly, this application combines the kaa editor and the visidata data visualization tool.
pip install dbcls
dbcls -H 127.0.0.1 -u user -p mypasswd -E mysql -d mydb mydb.sql
dbcls -c config.json mydb.sql
Where config file is:
{
"host": "127.0.0.1",
"port": "3306",
"username": "user",
"password": "mypasswd",
"dbname": "mydb",
"engine": "mysql"
}
or from bash file
#! /bin/bash
CONFIG='{
"host": "127.0.0.1",
"port": "3306",
"username": "user",
"password": "mypasswd",
"dbname": "mydb",
"engine": "mysql"
}'
dbcls -c <(echo "$CONFIG") mydb.sql
-H --host
Host to connect to
-u --user
Username to connect as
-p --password
Password to use when connecting to server
-E --engine
Database engine, options are: mysql, postgresql, clickhouse
-d --database
Database to use
-P --port
Port number to use for connection (optional)
-c --config
Path to a config file to use
See github issues: https://github.com/Sets88/dbcls/issues
FAQs
dbcls is a versatile client that supports various databases
We found that dbcls demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Product
Ensure open-source compliance with Socket’s License Enforcement Beta. Set up your License Policy and secure your software!
Product
We're launching a new set of license analysis and compliance features for analyzing, managing, and complying with licenses across a range of supported languages and ecosystems.
Product
We're excited to introduce Socket Optimize, a powerful CLI command to secure open source dependencies with tested, optimized package overrides.