Python is a known modular language which imports many useful operations from its standard library. Of course, it isn’t possible to program Python without using it. It has become an excellent alternative for many programmers because it is an open source program which was developed under an OSI license. You can download, install and run it on any computer without any charge. It is available in various builds and supports around 21 different operating systems making it have universal appeal. Python Database Drivers Packages and Projects Below is a python database drivers library list which would be useful for any programmer interested in python: redis-py 3.5.x will be the last version of redis-py that supports Python 2. The 3.5.x line will continue to get bug fixes and security patches that support Python 2 until August 1, 2020. redis-py 4.0 will be the next major version and will require Python 3.5+. This package contains a pure-Python MySQL client library, based on . redis-p y - The Redis Python Client. PyMySQL - Pure Python MySQL driver compatible to mysql-python. PEP 249 Most public APIs are compatible with mysqlclient and MySQLdb. NOTE: PyMySQL doesn't support low level APIs _mysql provides like data_seek, store_result, and use_result. You should use high level APIs defined in . But some APIs like autocommit and ping are supported because doesn't cover their usecase. PEP 249 PEP 249 asyncpg is a database interface library designed specifically for PostgreSQL and Python/asyncio. asyncpg - A fast PostgreSQL Database Client Library for Python/asyncio asyncpg is an efficient, clean implementation of PostgreSQL server binary protocol for use with Python's asyncio framework. You can read more about asyncpg in an introductory . blog post asyncpg requires Python 3.5 or later and is supported for PostgreSQL versions 9.2 to 12. psycopg2 - The most popular PostgreSQL adapter for Python. Psycopg is the most popular PostgreSQL database adapter for the Python programming language. Its main features are the complete implementation of the Python DB API 2.0 specification and the thread safety (several threads can share the same connection). It was designed for heavily multi-threaded applications that create and destroy lots of cursors and make a large number of concurrent INSERTs or UPDATEs. This project adds Python 3 support and bug fixes. I hope this fork is merged back to MySQLdb1 like distribute was merged back to setuptools mysqlclient - mysql-python fork supporting Python 3. A modern, feature-rich and highly-tunable Python client library for Apache Cassandra (1.2+) and DataStax Enterprise (3.1+) using exclusively Cassandra's binary protocol and Cassandra Query Language v3. cassandra-python-driver - Python driver for Cassandra. Motor is a full-featured, non-blocking driver for Python and applications. motor - The async Python driver for MongoDB. MongoDB Tornado asyncio A simple database interface for that builds on top of to provide a Python DB-API ( ) interface to . pymssql - A simple database interface to Microsoft SQL Server. Python FreeTDS PEP-249 Microsoft SQL Server A developer-friendly library for Apache HBase. HappyBase - The official Python client for MongoDB. PyMongo A supercharged SQLite library built on top of apsw. It is a feature-packed Python package and for utilizing SQLite in Python by . SuperSQLite Plasticity It is intended to be a drop-in replacement to Python's built-in , but without any limitations. It offers unique features like and . SQLite API remote streaming over HTTP bundling of extensions like JSON, R-Trees (geospatial indexing), and Full Text Search SuperSQLite is also packaged with pre-compiled native binaries for SQLite and all of its extensions for nearly every platform as to avoid any C/C++ compiler errors during install. More published at : https://reposhub.com/python

Top 10 Python Database Drivers Packages and Projects

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

104 Stories To Learn About Go

105 Stories To Learn About Functional Programming

100+ Free Pluralsight Courses to learn Python, Java, and Spring Boot

10 Websites to Learn JavaScript for Beginners

104 Stories To Learn About Programming Top Story

104 Stories To Learn About Go

105 Stories To Learn About Functional Programming

100+ Free Pluralsight Courses to learn Python, Java, and Spring Boot

10 Websites to Learn JavaScript for Beginners

104 Stories To Learn About Programming Top Story

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps