What Is IaSQL

I discovered an interesting open-source project today that has an entirely different approach from mine. Honestly, I couldn’t get along with it yet, but it might be in the near future I use it.

Do you have any ideas about creating your own AWS infrastructure, such as EC2s, ECS or etc. via PostgreSQL queries? This is the main idea of this open-source project: IaSQL.

IaSQL is a powerful tool that allows users to deploy infrastructure in AWS using PostgreSQL SQL queries. With IaSQL, users can define their infrastructure as code and automate the deployment process, making it easier to manage and scale their AWS infrastructure. In contrast to AWS consoles and infrastructure as code (IaC) tools, IaSQL lets developers manage cloud infrastructure as data in PostgreSQL.

To deploy infrastructure using IaSQL, users define their infrastructure as code using SQL queries. These queries are executed by IaSQL, which then deploys the defined infrastructure in AWS.

Here is an example of how to use IaSQL to deploy an EC2 instance in AWS:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16

-- Define EC2 instance parameters
SET ec2_instance_type = 't2.micro';
SET ec2_key_name = 'my-key';
SET ec2_security_group_id = 'sg-0123456789abcdde';

-- Create EC2 instance
CREATE RESOURCE ec2_instance (
  ec2_instance_type text NOT NULL DEFAULT ec2_instance_type,
  ec2_key_name text NOT NULL DEFAULT ec2_key_name,
  ec2_security_group_ids text[] NOT NULL DEFAULT ARRAY[ec2_security_group_id]
) AS
  SELECT aws_ec2.create_instance(
    ec2_instance_type,
    ec2_key_name,
    ec2_security_group_ids
  ) AS instance_id;

This SQL query defines the parameters for an EC2 instance and then creates the instance using the aws_ec2.create_instance() function. The resulting EC2 instance ID is then stored in the ec2_instance resource.

Using IaSQL, users can define and deploy a wide range of AWS resources using SQL queries. IaSQL supports many AWS services, including EC2, RDS, S3, and many others. One of the key benefits of using IaSQL is that it allows users to define their infrastructure as code, which can be version controlled and easily shared with other team members. This approach also allows for easier collaboration, as changes to the infrastructure can be reviewed and tested before being deployed.

I will try to do more exploration of the project and write about it again. You can take a look at project blog posts for more hints.