AWS Well-Architected Framework – The 5 Pillars

The AWS Well-Architected Framework is a set of Documents and Tools that sets out best practices and procedures to follow to build high quality applications in the cloud on AWS

The core of the well architected framework is 5 pillars that group the important considerations and practices that you need to stick to when building in AWS.

The 5 Pillars of the AWS Well-Architected Framework

  • Security
  • Reliability
  • Performance Efficiency
  • Operational Excellence
  • Cost Optimization
Continue reading “AWS Well-Architected Framework – The 5 Pillars”

Find the size of a table in Postgres

You often need to know the size of a table in postgres and there is no particularly easy way to get that information directly from the psql client.

Fortunately, all of the information is in there and is available through nice simple functions.

All you have to do is pull it together and a stock query will normally do.

The below query will get you a list of all of the tables in your database, it will show you the size of the associated indexes as well as the size of the associated TOAST objects.

If you want the size of your database, I would tend to just do a ‘\l+’ in psql but if you want to do it in SQL for some reason then you can just do:

And then if you want the size of all of your databases then its a simple change so that it looks like:

And finally, if you want a size breakdown of all of the objects in your database – so that you can see all of the indexes as well as the tables then you can find that with:

IAM Role in AWS

In AWS IAM Roles are similar to IAM Users in that they can have policies and permissions attached to them. However, they cannot be authorized (login) and they do not really have the policies etc attached to them. They appear to have them but underneath, those policies flow down the the actual users beneath.

The idea is that Roles will help you to group users together and also that they can help you in temporarily granting a level of access or permission to a user and give you an easy way to revoke that.

Continue reading “IAM Role in AWS”

AWS IAM Notes – AWS Solutions Architect

This is some rough notes on IAM in AWS, covering IAM Roles, IAM Users and IAM Policies. The notes are aims at studying for the AWS Solutions Architect Certification and should cover the main points required for that exam.

AWS IAM can be summed up by saying that it authenticates and authorities you to and in AWS.

Root user is first user and has all permissions to everything on the account. It can’t be removed.

Continue reading “AWS IAM Notes – AWS Solutions Architect”

Amazon S3 Games

Amazon S3 is a huge benefit to the gaming industry. In this day of downloads being the main way to access games, it is a massively popular medium for storing the game data to be served out to gamers. Its distributed, fault tolerant and highly scalable architecture mean that it is a reliable way to get game files to users.

Did you know that you can run games directly on Amazon S3 though?. HTML5 games can live in an S3 bucket and be served directly from there.

There are quite a few games running ang being served directly from s3 buckets. 

Continue reading “Amazon S3 Games”