{"id":7221,"date":"2021-04-13T14:45:17","date_gmt":"2021-04-13T14:45:17","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/pymongo-and-other-python-modules-for-database-engines\/"},"modified":"2026-11-03T19:28:15","modified_gmt":"2026-11-03T19:28:15","slug":"pymongo-and-other-python-modules-for-database-engines","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/en-gb\/blogs\/pymongo-and-other-python-modules-for-database-engines\/","title":{"rendered":"PyMongo and other Python modules for database engines"},"content":{"rendered":"

Overview<\/strong><\/p>\n

In general, developers use shell scripts to automate database tasks such as exporting and importing data, gathering database (DB) statistics, tablespace monitoring, blocking sessions, DB locks, and so on. <\/p>\n

Python has become one of the most popular programming languages over the last seven or more years. This post covers different DB modules used in Python for various database engines and shows how to use the PyMongo module to query and insert data into a MongoDB\u00ae collection.<\/p>\n

Intro to Python modules<\/strong><\/p>\n

Python is an object-oriented and high-level programming language. It has a wide range of modules for different implementations such as web development, data science, Linux\u00ae administration, and so on. The following table shows details about the database engine and relevant Python modules:<\/p>\n

| Database Engine | Python Module |
\n| — | — |     
\n| Oracle | cx_oracle |
\n| PostgreSQL | psycopg2 |
\n| MongoDB |pymongo |
\n| MySQL | mysql.connector and pymysql |
\n| Cassandra | cassandra-driver |<\/p>\n

CX_ORACLE<\/strong><\/p>\n

cx_oracle<\/em> is a Python module that allows you to access Oracle databases and adheres to Python database API specifications. This module is compatible with Oracle Database 11.2, 12c, 18c,19c, and 21c.<\/p>\n

PSYCOPG2<\/strong><\/p>\n

psycopg2<\/em> is a Python module that allows you to access PostgreSQL databases and adheres to Python database API specifications. One of the key features is that it enables multi-threaded applications that open multiple cursors to perform concurrent inserts and updates.<\/p>\n

PYMONGO <\/strong><\/p>\n

pymongo<\/em> is a module that allows you to access mongo databases and perform database queries on MongoDB database objects such as collections, documents, and so on.<\/p>\n

MYSQL.CONNECTOR<\/strong><\/p>\n

mysql.connector<\/em> is a module that allows you to access MySQL databases and adheres to Python database API specifications. It enables database queries.<\/p>\n

CASSANDRA-DRIVER<\/strong><\/p>\n

cassandra-driver<\/em> is a Python driver for Apache Cassandra databases and is compatible with the Cassandra query language (CQL). By using this module, you can connect to and query Cassandra databases.<\/p>\n

 PyMongo demonstration<\/strong><\/p>\n

Python programming performs different CRUD (Create, Read, Update, and Delete) operations in MongoDB. The following steps show you how to download pip, install the pymongo<\/em> module, and write and execute a Python script with PyMongo:<\/p>\n

\n1. Run the following command to check the version of Python on your Linux server:<\/p>\n

        # python –version
\n        Python 2.7.18<\/em><\/p>\n

2. Use the following commands to install pip and  PyMongo:<\/p>\n

        # yum install python-pip
\n        # pip install pymongo<\/em><\/p>\n

3. Open the text editor of your choice and write the following Python script
\n   (mongo-crud.py<\/strong>) to perform CRUD operations on a collection in the MongoDB:<\/p>\n

        #!\/usr\/bin\/python
\n 
\n        from pymongo import MongoClient
\n        client = MongoClient(host = ‘localhost:27017’, username=”dba”, password=”user123″)<\/em>
\n 
\n        mongodbinfo = client.server_info()
\n        print (“Printing MongoDB Server Information”)
\n        print (mongodbinfo)<\/em><\/p>\n

      print (“##################################################”)<\/em><\/p>\n

     print (“Mongo DB version”)
\n        print (“db version:”, mongodbinfo[“version”])<\/p>\n

    print (“##################################################”)<\/p>\n

db = client.empdb
\n        empdetails = db.employeedetails
\n        print (“Existing collection information”)
\n        printcollection = empdetails.find()
\n        for i in printcollection:
\n            print (i)<\/em><\/p>\n

    print (“##################################################”)<\/em><\/p>\n

print (“Adding one document to the collection”)
\n        details = {“name”: “Andy”, “designation”: “Clerk”}
\n        newentry = empdetails.insert_one(details)
\n        print (” newentry:”, newentry)
\n 
\n        printcollection1 = empdetails.find()
\n        for i in printcollection1:
\n            print (i)<\/em><\/p>\n

print (“##################################################”)<\/em><\/p>\n

print (“Performing a search on the collection”)<\/em><\/p>\n

  search = empdetails.find_one({ ‘name’ : ‘Jack’})
\n        print (search)
\n        print (“##################################################”)<\/em><\/p>\n

print (“Adding multiple documents to the collection”)
\n        entry1 = {“name”: “Cathy”, “designation”: “Data Operator”}
\n        entry2 = {“name”: “Susan”, “designation”: “Operations Manager”}
\n        newentries = empdetails.insert_many([entry1, entry2])
\n 
\n        printcollection2 = empdetails.find()
\n        for i in printcollection2:
\n            print (i)<\/em><\/p>\n

4. Execute the Python script by running the following command. The output looks similar to the following image: <\/em><\/p>\n

   # python mongo-crud.py<\/em><\/p>\n

\"py<\/p>\n

Conclusion <\/strong><\/p>\n

Python was one of the most trending programming languages in 2020 with a wide range of implementations. Python provides database engineers alternatives to shell scripting for database task automation<\/p>\n","protected":false},"excerpt":{"rendered":"

PyMongo and other Python modules for database engines<\/p>\n","protected":false},"author":2,"featured_media":7223,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26321","content_type":"blog","created_by":"10130","authored_on":"2023-11-30T15:45:17+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Dinesh Miriam, Oracle Database Administrator, Rackspace Technology","seo_description":"Automate DB tasks using Python and PyMongo module for MongoDB collections. Ideal for developers seeking Python-based DB automation.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26321-insights_image-database-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"MongoDB","product":"","publisheddate":"2021-04-13T14:45:17","rxt_solutions":"Data, Databases","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"PyMongo and Python for DB Engines | Rackspace Technology","field_topics":"","field_slug":"pymongo-and-other-python-modules-for-database-engines","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-7221","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/comments?post=7221"}],"version-history":[{"count":2,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7221\/revisions"}],"predecessor-version":[{"id":9188,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7221\/revisions\/9188"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media\/7223"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media?parent=7221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/categories?post=7221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/tags?post=7221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}