python-sql

python-sql

Python Software Foundation

About

Write and execute queries in a fully interactive SQL editor. JackDB has everything you'd want in a database client, including: syntax highlighting, code formatting, and intelligent autocompletion. Snippets allow your most useful SQL queries to be saved and shared. Simply write and save any query in JackDB, and share the snippet publicly with your team. Whenever anyone updates a snippet, everyone gets access to its latest version. Security is our highest priority at JackDB. Roles are a very convenient and secure way to restrict database access to authorized users and provision new users with access to data sources. Explore everything in your database, not just tables and views. View your indexes, schemas, and other important system details such as tablespaces and user sessions.

About

SQLPro Studio is a fully native, cross-platform database management tool. It supports a wide range of database systems and provides several features including syntax highlighting, SQL autocompletion, customizable themes, and tabbed interfaces for managing multiple queries simultaneously. It also offers cloud support for services like Amazon RDS, Microsoft Azure, and Heroku, along with SSH tunneling and master password protection for enhanced security. SQLPro Studio is optimized for performance and user experience, providing an intuitive interface without relying on Java, ensuring faster and more reliable operation. You can execute multiple queries and have the results for each displayed at the same time, including any errors and messages. SQLPro boasts an intuitive interface, where the most basic to advanced database needs are easily accessible.

About

It's free of charge for everybody, for any purpose (including commercial). It's safe, as anyone can review the source code. The SQL Editor window assists users with SQL syntax hints & highlighting, provides pretty-print code for matter, marks syntax errors. You can Ctrl+click on table mentioned in SQL query to open that table (or index, or trigger, or view). You can execute SQL statements that refer to multiple databases within a single query, thanks to a transparent database attaching mechanism built into the SQL Editor of SQLiteStudio. You can implement your own collation sequences (i.e. algorithms for comparing 2 values, that could be used in ORDER BY clause, etc). There is a portable distribution, no need to install it just download the package, decompress and run and no administrator rights are required.

About

python-sql is a library to write SQL queries in a pythonic way. Simple selects, select with where condition. Select with join or select with multiple joins. Select with group_by and select with output name. Select with order_by, or select with sub-select. Select on other schema and insert query with default values. Insert query with values, and insert query with query. Update query with values. Update query with where condition. Update query with from the list. Delete query with where condition, and delete query with sub-query. Provides limit style, qmark style, and numeric style.

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Audience

Database Management solution for businesses

Audience

Developers and database administrators searching for a tool providing robust features for managing multiple database systems

Audience

SQLite database management platform for developers

Audience

Developers searching for a solution offering a library to write SQL queries

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

API

Offers API

API

Offers API

API

Offers API

API

Offers API

Screenshots and Videos

Screenshots and Videos

Screenshots and Videos

Screenshots and Videos

Pricing

$49 per user per month
Free Version
Free Trial

Pricing

$17.07 per month
Free Version
Free Trial

Pricing

Free
Free Version
Free Trial

Pricing

Free
Free Version
Free Trial

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Company Information

JackDB
Founded: 2014
United States
www.jackdb.com/product/

Company Information

SQLPro Studio
Founded: 2015
United States
www.sqlprostudio.com

Company Information

SQLiteStudio
sqlitestudio.pl/

Company Information

Python Software Foundation
United States
pypi.org/project/python-sql/

Alternatives

DBeaver Community

DBeaver Community

DBeaver Corp.

Alternatives

DBeaver Community

DBeaver Community

DBeaver Corp.

Alternatives

Database Tour Pro

Database Tour Pro

Vitaliy Levchenko Software

Alternatives

Valentina Studio

Valentina Studio

Paradigma Software
DBeaver Community

DBeaver Community

DBeaver Corp.
Valentina Studio

Valentina Studio

Paradigma Software
NGS-IQ

NGS-IQ

New Generation Software
QStudio

QStudio

TimeStored
SQLGate

SQLGate

CHEQUER
Aqua Data Studio

Aqua Data Studio

AquaFold, an Idera, Inc. company
Valentina Studio

Valentina Studio

Paradigma Software

Categories

Categories

Categories

Categories

Integrations

Amazon Aurora
Amazon RDS
Amazon Redshift
Apache Cassandra
Azure SQL Database
Domino Enterprise MLOps Platform
Heroku
Java
MariaDB
Microsoft Azure
MySQL
Oracle Database
PostgreSQL
Python
SQL
SQL Server
SQLite
Snowflake
Visplore

Integrations

Amazon Aurora
Amazon RDS
Amazon Redshift
Apache Cassandra
Azure SQL Database
Domino Enterprise MLOps Platform
Heroku
Java
MariaDB
Microsoft Azure
MySQL
Oracle Database
PostgreSQL
Python
SQL
SQL Server
SQLite
Snowflake
Visplore

Integrations

Amazon Aurora
Amazon RDS
Amazon Redshift
Apache Cassandra
Azure SQL Database
Domino Enterprise MLOps Platform
Heroku
Java
MariaDB
Microsoft Azure
MySQL
Oracle Database
PostgreSQL
Python
SQL
SQL Server
SQLite
Snowflake
Visplore

Integrations

Amazon Aurora
Amazon RDS
Amazon Redshift
Apache Cassandra
Azure SQL Database
Domino Enterprise MLOps Platform
Heroku
Java
MariaDB
Microsoft Azure
MySQL
Oracle Database
PostgreSQL
Python
SQL
SQL Server
SQLite
Snowflake
Visplore
Claim JackDB and update features and information
Claim JackDB and update features and information
Claim SQLPro Studio and update features and information
Claim SQLPro Studio and update features and information
Claim SQLiteStudio and update features and information
Claim SQLiteStudio and update features and information
Claim python-sql and update features and information
Claim python-sql and update features and information