quicksqlconnector 1.5.2

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

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.

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

• Buy Us a Coffee - Just one cup!
• Email - Click Here
• PyPi - Visit Here
• Website - Visit Here