Let’s get this party started

Photo by Geran de Klerk on Unsplash

In part 1, we talked about what Postgresql is, the intended use, and how to install it. Once we got Postgresql installed, we were ready to create our database. To open Postgresql, we were actually using the user “Postgres”. This is kind of like your default admin account. We used this because we don’t have any current users created, but that is something we will be doing a little later down the road. For this part, we need to create our tables. In the last part, I talked about creating my “Recipe” database. …


Let’s start from the beginning

Photo by James Hammond on Unsplash

Not too long ago I wrote an article comparing MySQL versus Postgresql. Although it was just a general overview, I grew an interest in Postgres. Now, this isn’t the first time I’ve heard of Postgresql, and I have tried using it before. However, it’s been a little while since I’ve touched it, and figured now would be a good time to take a dive right back in and make a tutorial. First, we will need to talk about what Postgresql is, then how to install it, and finally how to get it started up. …


Battle of the lightweight Databases

Photo by Roman Synkevych on Unsplash

Just recently I made an article about what TinyDB is and how to use it. While explaining TinyDB, I noticed several parallels to SQLite. That got me to wonder how similar the two Databases are. In theory, both databases have relatively the same goal. Both databases seek to be lightweight, document-based databases that are simple to set up and maintain. Although they both seem to have the same goals, we can look at how different TinyDB may be from SQLite. This will also help us determine which database would be better suited for our projects, depending on what goals you…


If you’re not using them, you should be

Photo by Grant Ritchie on Unsplash

When it comes to writing Python code, there are a lot of tools that can be very helpful to the developer. One such, in particular, is Python virtual environments. In a nutshell, this is a tool that allows you to isolate your project from potentially interfering with other python projects. Using these may sound like a great idea, however, they do have some cons as well. Let’s take a deeper dive into what virtual environments are all about.

What’s so great about them?

As was already mentioned, virtual environments isolate your project from the host system and enable you to run a Python project without…


A Built-In Database For Pure Python Projects

Photo by Noah Negishi on Unsplash

While browsing through Medium, I discovered a few articles about how Python has a built-in database. Having piqued my curiosity, I wanted to know more about it. But then I discovered the majority of these articles were talking about SQLite. Nothing wrong with that. We talked a little about SQLite in the past, how it is a database that is embedded in nature and therefore only needs a document to exist. SQLite would be a good choice for small Python projects that are intended for more personal or mobile use.

But somehow I wasn’t satisfied with this answer. SQLite is…


Back up your data people!

Photo by benjamin lehman on Unsplash

One day in early January, I was writing some code when major problems started occurring with my development server.

Bolting to the basement and running over to the server rack, I immediately assessed the situation and started troubleshooting the issue. After a short amount of time, I was able to determine that a failing hard drive in the raid array was causing all the problems.

Unfortunately, I forgot that this particular server was still using RAID 0 (don’t use this if you don’t want to risk losing your data) and hadn’t changed it, which provided more fault tolerance. In the…


A deeper dive into the querying language for APIs

Photo by Markus Spiske on Unsplash

Not long ago I wrote a post about the difference between GraphQL and REST. While I did a little digging into GraphQL to form the comparison, what I found is that this querying language could be very powerful but has a steep learning curve. There were a few concepts, such as having only a single endpoint, that made me think that we need to know more about GraphQL before trying to use it.

When learning more about it, not only will it be important to know when is ideal to use GraphQL, but also what the advantages and disadvantages may…


A Python Web Framework For Creating Dashboards

Photo by Stephen Dawson on Unsplash

Around my office job, there are have been several discussions about the inclusion of dashboards. Typically, we used them to represent data to our business users, but with the new system, it was pushed to the back burner. With dashboards on my mind, I wondered what Python had, not for work but personal use. After a quick google search, I found a web framework called “Dash”. So let’s look into what Dash is, get it installed, then run through a brief tutorial, or trial run, of how to use it.

What Is Dash?

Dash is a Python open-source web framework used to build…


So many to choose from…

Photo by NOAA on Unsplash

With the onset of summer quickly approaching, checking the weather will become a daily chore to ensure that my gardens get the appropriate amount of water they need to survive and prosper. Most people, either check the forecast given by their local news channel or have a favorite website that provides accurate data. However, for me, I want to do something a little different. Instead of hearing about it on TV or looking it up on some website, I want to obtain my forecast through an API call.

Why?

Some of you are probably thinking that using a weather API instead…


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…

Mike Wolfe

Software Developer, Tech Enthusiast, Runner. Current project http://sqlcheater.com/ Connect with me on LinkedIn: www.linkedin.com/in/michael-wolfe-176212125

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