Building an API in Spring that connects to a MariaDB database

A person standing in a foggy field.
A person standing in a foggy field.
Photo by Jakub Kriz on Unsplash

Spring is a framework that allows you to create enterprise-level applications. The problem arose where it took many configurations to get an initial application up. This is where Spring Boot came along.

“Spring Boot allows you to abstract (hide) these configurations. So you can get a preconfigured template application.” — From part 1 of this series

Here in this article, you’ll be shown how to create a Rest API in Spring Boot. This API will be a CRUD (create, read, update, delete) application that connects to a SQL database — in this case, a MariaDB database.

If you’re new to Spring or you just need a refresher in Spring and its concepts, the previous article explains the basics. …

The basics of API development in Spring Boot

Spring Boot programming language logo
Spring Boot programming language logo
Image credit: Sprint Boot

The world of back-end frameworks is much more uncommon than that of front-end frameworks. You always hear about JavaScript and its flavors such as React, Vue, and Angular (cough cough). On YouTube, the number of front-end videos multiplies by the second, and for a lot of people including myself, the first back-end language we might hear about is PHP. It took me a while to realize that Python can do similar things to Flask and Django. But again, I did not see these flooding my notifications like JavaScript and general Python and Java languages.

When browsing job descriptions, especially for jobs in my country, one of the most common back-end frameworks requested by employers is Spring Boot. By this time, I was already accustomed to frameworks like Flask and Express when I decided to learn this seemingly popular framework. I can say based on my experience that the journey was not fun. …

Why is it necessary?

the statement if_name_==’_main_’:
the statement if_name_==’_main_’:
Photo by author generated from carbon

You might have seen this one before: the syntax which often gets ignored because it doesn’t seem to hinder the execution of your code. It may not seem necessary, but that’s only if you’re working with a single Python file.

Let’s Get Right Into It!

Let’s start out by deconstructing the statement from left to right. We already know what an if statement is; however, the most important part of the statement are the two things being compared.

Let’s start with __name__ .This is used to denote the name of the file that is currently being run, but there is a trick to this. …

Populating a MySQL Database with Dummy Data using Pandas

Image for post
Image for post
Photo by aitoff from pixabay

In this article we’re going to demonstrate how to generate dummy data and input for a MySQL database. Majority of the times we need to create a database to test some software that we’ve built. To do this, we can use Structured Query Language (SQL) to create a mock database system. However, problems may arise if we want to test hundreds or even thousands of records. There is definitely no way we could write that many insert statements into our SQL scripts to meeting our testing deadlines for product deployment, that would be too tedious and time consuming.

To help with this problem, our trusty friend Python comes to assist ! …

That can save you a lot of time !

Image for post
Image for post

Using python over the years, I came across some useful features that would have saved me a lot of time if I had known about them a little bit earlier. These little python gems can help keep your code more DRY( Do Not Repeat Yourself) and clean.

By the time you are finished with this article, I can guarantee you that you will be using some of these features in your very own python programs.

Note: You can use any IDE or text editor that you are familiar with ( python’s default IDE is known as “IDLE” and that can also be used). For these features, I will be demonstrating using Visual Studio Code (VS Code) with a python extension.

Creating unit test in python

A woman coding on her laptop
A woman coding on her laptop

As developers or programmers, call yourself anyone. As long as you write code there is often one thing that gets overlooked. Testing. Testing is that part of development where you’re suppose to rigorously test your applications to ensure that they meet the required functionalities.

Let’s start of with why we even do testing in the first place:

  1. The need for less manual testing. Because the test cases are pre-written, there is no real reason to conduct manual testing anymore. Most times, especially with large applications you have to run through a lot of stages in the software to test if a certain feature works. This could be avoided with testing. Imagine having to use certain inputs every time your application runs. …


Jordan Williams

Enjoys creating software that make tasks simpler. Always trying to gain new knowledge and expertise.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store