September 25, 2020 Python

Getting Started with MySQL and Python

Introduction For any fully functional deployable application, the persistence of data is indispensable. A trivial way of storing data would be to write it to a file in the hard disk, but one would prefer writing the application specific data to a database for obvious reasons. Python provides language support for writing data to a wide range of databases. Python DB API At the heart of Python support for database programming is the Python DB API (PEP – 249) which […]

September 25, 2020 Python

Analyzing API Data with MongoDB, Seaborn, and Matplotlib

Introduction A commonly requested skill for software development positions is experience with NoSQL databases, including MongoDB. This tutorial will explore collecting data using an API, storing it in a MongoDB database, and doing some analysis of the data. However, before jumping into the code let’s take a moment to go over MongoDB and APIs, to make sure we understand how we’ll be dealing with the data we’re collecting. MongoDB and NoSQL MongoDB is a form of NoSQL database, enabling the […]

September 25, 2020 Python

Working with Redis in Python with Django

Introduction Data is increasingly becoming a valuable commodity in the current era of technology and this necessitates the optimization of storage and access to this data. There are quite a few notable solutions for the storage of data, including Relational Database Management Systems (RDBMS) such as MySQL and PostgreSQL, which store data in a structured format using rows and columns and the relationships within the data. Apart from RDBMS, there are key-value stores that store data based on unique keys […]

September 25, 2020 Python

Integrating MongoDB with Python Using PyMongo

Introduction In this post, we will dive into MongoDB as a data store from a Python perspective. To that end, we’ll write a simple script to showcase what we can achieve and any benefits we can reap from it. Web applications, like many other software applications, are powered by data. The organization and storage of this data are important as they dictate how we interact with the various applications at our disposal. The kind of data handled can also have […]

September 25, 2020 Python

Integrating H2 with Python and Flask

Introduction H2 is a lightweight database server written in Java. It can be embedded in Java applications, or run as a standalone server. In this tutorial, we’ll review why H2 can be a good option for your projects. We’ll also learn how to integrate H2 with Python by building a simple Flask API. The Features of H2 H2 was built with performance in mind. “H2 is a combination of: fast, stable, easy to use, and features”. Although H2 is prominent […]

September 21, 2020 Python Leave a comment

A SQLite Tutorial with Python

Introduction This tutorial will cover using SQLite in combination with Python’s sqlite3 interface. SQLite is a single file relational database bundled with most standard Python installs. SQLite is often the technology of choice for small applications, particularly those of embedded systems and devices like phones and tablets, smart appliances, and instruments. However, it is not uncommon to hear it being used for small to medium web and desktop applications. Creating a Database and Making a Connection Creating a new SQLite […]