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 coverd!. Quick SQL Connector is a python library that lets you execute MySQL, PostgreSQL, and SQLite queries with just one line of code.

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

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', 'database-name')

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

  • mysql
  • sqlite3
  • postgres

quicksqlconnector only have one method which is 'query'.

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

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

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))

🔗Useful Links

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.2.tar.gz (4.0 kB view hashes)

Uploaded Source

Built Distribution

quicksqlconnector-1.5.2-py3-none-any.whl (5.2 kB view hashes)

Uploaded Python 3

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