-
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…
-
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,…
-
Pure Python for Daily Steps App
Today I want to practice what I’ve been learning in Python around data structures by building an application that will allow a user to sign up, log in, then add values to different metrics – all of which point towards the user achieving their goals. There won’t be a database for this app, just storing…
-
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…
-
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…
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
davethemaker 