davethemaker

Category: database

  • Migrating to RDS

    In this post, I’m going to reference a lab that I am working on- the scenario is we have a single EC2 instance running Linux OS, an Apache server, and an app with PHP (LAMP stack). The instance is doubling as a database server, which is not ideal because then we are responsible on patching,…

  • AWS Architecting MySQL and Workbench

    In this exercise, I’m going to pull together a number of different threads – namely, the design and implementation of the infrastructure to spin up an EC2 instance (hosting Workbench, which will allow me to interact with a database) and an RDS MySQL instance. My objective is to be able to create a database and…

  • Not cookies..Baking an AMI!

    In a previous post I manually spun up an EC2 instance and then installed and configured an Apache server and MariaDB to run a WP instance. It was useful for learning purposes, and as a reference of the benefits of automation! In this post, I’m going to be baking an AMI image, that is, creating…

  • BabySteps Back-End Dev’t

    In previous posts, I built out python code for an application wherein a user could sign up, log in with authentication, and track his/her activities leading to their specific goals. Previously, I had used key-value pairs within a dictionary and lists to store my input values, and once the application session closed, that data was…

  • Back-End Dev’t With Flask

    LIke other posts I’ve made recently, this one will detail my efforts to learn the Flask framework hand-in-hand with what I’ve been learning recently: Python, SQL, databases, and more. There’s a lot of information, both conceptual and technical, and it’s really helpful to have these kinds of notes to be able to reference down the…

  • Containers w/ Alembic, Postgres DB, VSC + RAW vs ORM SQL Queries

    This posting is where I’m going to post the steps that I took to do the following: 1) set up Visual Studio Code to work with Containers 2) download docker images 3) connect to various containers which all are geared up to build a python-flask-PG DB application 4) work with alembic and flask to work…

  • Building out a Postgres SQL Database for Goal-Tracking App

    In a previous post, I detailed the steps I took to create an application, crafted lovingly with Python, which allowed a user to log in, authenticated that user, and allowed a user to set goals and to track their activities leading to achieve those goals. One of the challenges that I ran into with building…

  • Postgres DB Manipulation Queries with SQL

    In my last post, we walked through the building out of a database, first starting with an ER diagram, then translating that into tables, columns, attributes. In this post, we’re going to dive deeper into SQL. For creating a table, we use this kind of syntax: Then, we insert data into the table: Let’s check…

  • Postgres: ER diagram > DB tables

    In this posting, I’m going to detail the steps that I took to successfully complete an exercise, where a ficticious company has given requirements for its operations, reflected by an ER diagram. My mission is to translate that into a technical solution, creating a Postgres database, complete with tables, to meet those requirements. Let’s get…

  • DBs +Data Modeling

    I’m learning to work with databases so will save some of my learning in these posts. There are four main types of DBs: flat file (like AWS S3 bucket), Relational (SQL), schemaless (NoSQL) and key-value store. I recently created a python application that used a key-value approach to store data, but it was rudimentary in…