davethemaker

Tag: database

  • Backend for AK – explore RDS

    Previously, I uploaded an html file to the relevant s3 bucket, setting the permissions for the public to access the contents, setting the CORS policy, and then deleting the cloudfront setup which I had created previously but wasn’t working correctly. I’ll add that in later but the focus is on building the functionality so that’s…

  • Visualizing SQL data

    I worked with data analysis using Panda, matplotlib and more during my studies at UW, but subsequently focused on cloud infrastructure and securing resources. Building out my database and SQL skills, I’m coming full circle to using visualization to better understand data- this is helpful in all sorts of ways! Here are some links to…

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

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

  • 3 Ways to Create MySQL Database Table

    In the past year, I’ve been building skills in working with a computer instance- configuration, placing it within a network, working with Linux and the command line, but it’s only now that I’m building a really important piece for application architecture- building a database. In this post, I’m going to create a database table for…

  • Linux & MySQL/MariaDB

    It’s interesting because I have always been drawn to understanding the big picture of things, and back when I first shifted to IT, I was intrigued with working with databases (and left me feeling dissatisfied with solely front-end stuff). I’m circling back to that, now, as I continue my Linux journey, and I find myself…