Skip to main content

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

Project description

Downloads

🤐 What is Quick SQL Connector ?

  • 🖇 Saves upto 80% of code lines as compared to other libraries.

  • 😃 Gives you simple interface to execute mysql commands easily.

💽 Pre-requisites & Installation

  • MySQLServer and MySQL Command-Line Client should be installed on your machine.

😋USING PIP

  • pip install quicksqlconnector

😈FOR LINUX FRIENDS

  • python3 pip install quicksqlconnector

🙄How to use?

Use 'quicksqlconnector' keyword to import

from quicksqlconnector import quicksqlconnector

Creating instance of module

DB = quicksqlconnector('host', port, 'username', 'password', 'database-name:optional')

quicksqlconnector only have one method which is 'query'

It has two arguments, query and parameters.

Some Examples

pass your 'mysql commnad' as a 'string' in 'query' method to execute query.

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

What's coming?

  • It will soon support other SQL databases including: Microsoft SQL server, SQL Lite, Postgres SQL etc.

🔗Useful Links

PyPi - Visit Here

Website - Visit Here

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

Uploaded Source

Built Distribution

quicksqlconnector-1.5-py3-none-any.whl (4.9 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