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

Uploaded source

Built Distribution

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