Skip to main content

Run MySQL, PostgresSQL, SQLite queries with just one line in python. The Ultimate SQL Library.

Project description

QuickSQLConnector

Developers are struggling to execute a query and what if you need to execute another query somewhere else? That's a lot of code to rewrite again. You don't have to do this because QuickSQLConnector got you covered!. Quick SQL Connector is a python library that lets you execute MySQL, PostgreSQL, and SQLite queries with just one line of code.

Reducing 80% lines of code and get more done and it's all done in the same syntax with all SQL databases mentioned.

Downloads PyPI version PyPI license Generic badge

Installation 💿

USING PIP

pip install quicksqlconnector

FOR LINUX FRIENDS

python3 pip install quicksqlconnector

To update Quick SQL Connector to the latest version, add --upgrade flag to the above commands.

Write your first query.

Use 'quicksqlconnector' keyword to import

from quicksqlconnector import quicksqlconnector

Creating instance of module

DB = quicksqlconnector('database','host', port, 'username', 'password')

NOTE : If you're using SQLite, you must provide database file name as follows.

DB = quicksqlconnector('sqlite3', database_name='my_example_database')

For database, it has 3 options (case-sensitive).

  • mysql
  • sqlite3
  • postgres

quicksqlconnector only have one method which is 'query'.

DB.query('query','parameters:optional')

FOR SQLite, you don't need to use parameterized quieries as it is not supported in SQLite.

It has two arguments, query and parameters, parameters are optional.

# EXAMPLES FOR 'MYSQL'

DB.query("SELECT * FROM test where id= %s", (input_user,))
DB.query("SELECT * FROM test")
DB.query('CREATE TABLE test(name varchar(10), id int(10))')
DB.query("INSERT INTO test values(%s, %s)", ('harry', 13))

# EXAMPLES FOR 'SQLITE'

DB.query('DROP TABLE movie')
DB.query("CREATE TABLE movie(title varchar(1), year int(1), score int(1))")

# EXAMPLE FOR 'POSTGRESQL'

DB.query('SELECT datname FROM pg_database')

See test.py for more examples.

🔗Useful Links

Route Link
Buy me a Coffee Visit
Email Visit
PyPi Visit
Website Visit

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

quicksqlconnector-1.5.3.tar.gz (4.0 kB view details)

Uploaded Source

Built Distribution

quicksqlconnector-1.5.3-py3-none-any.whl (5.4 kB view details)

Uploaded Python 3

File details

Details for the file quicksqlconnector-1.5.3.tar.gz.

File metadata

  • Download URL: quicksqlconnector-1.5.3.tar.gz
  • Upload date:
  • Size: 4.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.1 CPython/3.10.2

File hashes

Hashes for quicksqlconnector-1.5.3.tar.gz
Algorithm Hash digest
SHA256 2bc12761f0bc934d63e2a0ee61b0e2249f71ccd51c74b51277996b7fc681fa8c
MD5 baea18e41f049c98a70e58003a169c73
BLAKE2b-256 fbba981abf0ac9c264dca7c4f1cbe5a28ff245c0dbf85e95a9c50c3aae234e1c

See more details on using hashes here.

File details

Details for the file quicksqlconnector-1.5.3-py3-none-any.whl.

File metadata

File hashes

Hashes for quicksqlconnector-1.5.3-py3-none-any.whl
Algorithm Hash digest
SHA256 16ee75716f3f7823a4492c6c8ec6208429af627477b3a96533c5efe0d55f25e3
MD5 39bee89e3be9e920bfd36bff72190b91
BLAKE2b-256 79c26d78442db2a2501f15301188ce432ffdc31b47b7cee9ea2fd9e720d863e8

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page