davethemaker

Category: Virtual Computing

  • 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…

  • 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…

  • First Steps with GitHub Actions

    As I learn AWS Cloud services and how to architect solutions, I am learning that there are a variety of automation tools that will be useful to know. While developing, for example, using a CI/CD tool like Jenkins of Github Actions will be useful, and then add containers, IaC tools like Terraform and I find…

  • 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…

  • Docker

    As part of my learning path (learning Python, Linux, AWS, DevOps, Networks and more), I am learning to work with Docker and containers. I’m going to post what I learn as I move along, starting with ground zero and then hopefully working up to more interesting aspects. Away we go! First, i downloaded the .dmg…

  • Creating AWS Launch Template for EC2

    I’ve been creating EC2 instances on a one-off basis, which is great practice, but as I am wanting to learn how to use IaC methodologies, I wanted to explore creating a launch template. First, I selected Launch Template from within the EC2 dashboard. I gave the template a name, selected the Amazon Linux x86 AMI…

  • Connecting EC2 with MySQL and Making Stuff

    For this exercise, I spun up an EC2 instance, then spun up a MySQL database instance, and connected the two. I followed the AWS tutorial ‘Creating and connecting to a MySQL DB instance’. First, I created an EC2 instance within the default VPC. I selected the AWS Linux 2023 AMI, using Free Tier configuration parameters,…

  • Configuring AWS CLI

    To work with the AWS cloud resources, the AWS CLI needs to be downloaded and installed on your particular computer OS. Then, it needs to be configured- I used the AI responses from a google query to learn that I first needed to create a user within IAM, give that user permissions, and download a…

  • First Foray into CloudFormation

    I’m interested in learning Infrastructure as Code, and since I’ve been diving deep into the AWS waters, decided to cozy up to CloudFormation. Here’s what I did to launch an AWS EC2 instance using that tool: First, I created a stack and uploaded a custom .yml file There were a few attribute options, but I…