Comparing the Relational Database Management System to the Object-Relational Database Management System

Photo by Nicole Mason on Unsplash

A little bit ago I compared MySQL to SQLite. It was both something I enjoyed writing and something I found interesting. I wanted to carry forward this and use it as a deeper dive into other Database Management Systems. I decided to learn more about Postgres and thought the comparison would help to clear up areas of confusion if any were to be found. Also, by comparing there seems to be a deeper dive into aspects other than just the syntax.

Let’s start looking at what Postgres is and how it differs from MySQL without any further delay.

What Is PostgreSQL?

PostgreSQL also…

Which is the better API model?

Photo by Isaac Smith on Unsplash

While thinking about the next topic to write about, I played around with the idea of building a project and incorporating GraphQL. Branching into more APIs, I thought it would be the perfect fit. But then I realized how little I knew about GraphQL. Although knowing the context and recognizing the name, I know very little about the language. Looking back further, I realize that in the past, when discussing different languages and frameworks I would often mention GraphQL, and yet never took the time to dig into what exactly it is and how to properly implement it.

After a…

Photo by Myke Simon on Unsplash

Plex is a client-server media player that can be used to stream videos, play music, watch live TV, listen to podcasts and so much more. It also does a wonderful job of organizing your personal media files as well as photos into collections. The player even has its own mobile app and can be run on many devices including a Raspberry Pi. But what if you’re one of those people who likes to learn and builds everything they use from scratch (I sometimes get this way)? …

Exploring the differences between two popular databases.

Photo by Javardh on Unsplash

As a change of pace, I decided to take a trip back to Databases. This time though, I wanted to do a little comparison instead of another tutorial-style post. Thinking about my time in college, I remember a particular class where we discussed using either MySQL or SQLite. In the end, we used SQLite due to the portability, but this got me thinking. The conversation would suggest that MySQL and SQLite were very similar, however, I know that is not the case. So how are they different? And are there any areas they are very similar? So in this post…

Part 1: It’s time for a rematch

Photo by Markus Spiske on Unsplash

A few years ago, I wanted to build a note-taking web application in an attempt to lighten the load of my backpack when walking around my college campus. Wanting to try something really different, Django was chosen. Unfortunately, after getting everything installed, following some tutorials, and starting to code, I immediately ran into problems. To start, the documentation on Django’s website did not match the version that installed on my computer (this was causing problems with what I was looking to accomplish). Which was a little confusing since I had followed that site's steps to install Django. The other problem…

Part 1: Getting Started

Photo by Taelynn Christopher on Unsplash

While branching out to coding games, I’m currently trying to stay oriented around Python. But I wanted something either two-dimensional or three-dimensional instead of text-based this time. In my research, I found out about an engine called Ren’Py. Although not command-line nor VS Code, my usual choices for development, Ren’Py uses its custom engine for development.

Lately, I have been thinking about creating a novel-styled game with interaction. Like a choose-your-own-adventure type of game. Even without a full concept, I would need to know what I’m able to do, and how I can build the game. …

From Installation to Implementation: Part 6

Photo by Markus Winkler on Unsplash

Previously on MongoDB

In part five, we learned about how to update documents using a few different Mongo commands. We also discussed that due to having embedded documents, it would be a little more difficult to update because of the chance details are overwritten. While updating, we learned we could update every field, or we could update only specific ones. Once we discussed a few different methods of updating, we decided to take a little time to think about how we would want to update our FastAPI portion.

This Time on MongoDB

Having taken a little time, I decided how I want to update our documents. Keep…

It’s quick and dirty, but it works

Photo by jesse orrico on Unsplash

When I finished writing my previous post, I spent some time thinking about the hundreds of pictures sitting in a single directory on my Samba share. When I first placed them there, I had this dream that one day, they would be neatly organized into separate directories. However, the thought of having to view each one individually and then move it to its proper directory seemed like a painful task. That is until I realized that a couple of MySQL tables and a little Python code could really help speed up this tedious task.

The idea that I had in…

Here is how it can be fixed…

Photo by Echo Grid on Unsplash

A few months ago, I wrote a few MYSQL tables to use while learning to create JSON web tokens with a Python API. A fairly simple task, however, recently it was brought to my attention that I made a mistake. For the primary key, I used a CHAR value that would represent a GUID (Globally Unique Identifier). Because MYSQL does not have a GUID datatype, I selected to use the CHAR data type to hold my generated value. This way, the database was not required to generate the key, as it would be created in my backend code. Although this…

I never thought it would be this easy

Photo by ShareGrid on Unsplash

Feeling adventurous, I once again thought about my ultimate plans for automation, which included building out all of my own programs. But what to do next? As I start towards creating a YouTube channel for tutorials like my blogs, I realized that I would need to use a video editor. However, maybe that is something I could build myself? To jump into a full video editor would be too much too soon, especially considering I don’t know what all an editor should include yet. But instead, I could start much smaller, such as with pictures. So, the only reasonable choice…

Mike Wolfe

Software Developer, Tech Enthusiast, Runner. Current project

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