1. Objective Design an efficient, scalable, and cost-effective logging architecture using Google Cloud Storage (GCS) for storing login history or event logs, with potential integration into analytics platforms like BigQuery or Dataflow. 2. Choosing the Right Format: JSON vs. Parquet Format Pros Cons Ideal Use Case JSON – Human-readable- Easy to generate- Flexible structure – […]
JSON Data in MySQL: Best Practices & Tips
JSON in MySQL: Best Practices & Pitfalls Since MySQL 5.7 started supporting the JSON data type, I’ve noticed more and more developers around me saying things like, “Let’s just use a JSON column!” At first, I thought, “That sounds flexible and easy!” — but after actually using it in production, I learned the hard way […]
Exporting Existing AWS Infrastructure to Terraform
Here is the complete Terraform export guide in one single file, with section titles clearly emphasized. Exporting Existing AWS Infrastructure to Terraform 1. Overview It is possible to export an existing AWS environment into Terraform code. Although AWS does not provide a native method, the Terraformer tool can be used to convert AWS resources into […]
Go Development Tips & Best Practices
1. Avoid Using panic panic should only be used for truly exceptional situations. Instead, return errors. Bad Example: Good Example: 2. Use Early Returns Reduce nesting and improve readability by returning early. Bad Example: Good Example: 3. Always Check Errors Ignoring errors can make debugging difficult. Bad Example: Good Example: 4. Avoid Overusing init Excessive […]
AWS Multi-Account Best Practices
1. Utilize AWS Organizations 2. Clear Account Separation 3. Identity Management 4. Security Management 5. Network Design 6. Cost Management 7. CI/CD Pipeline Management 8. Monitoring & Operations 9. Account Creation & Deletion 10. Disaster Recovery & Backup Conclusion Proper AWS multi-account management enhances security, cost efficiency, and operational effectiveness. Leveraging AWS Organizations, SCPs, and […]
Optimistic Locking and Pessimistic Locking in Databases
1. Overview To prevent concurrent update conflicts in a database, two main locking strategies are used: Optimistic Locking and Pessimistic Locking. Understanding their differences helps in selecting the right approach for a given scenario. 2. Optimistic Locking Definition Mechanism SQL Example Success: If no other updates occur, the update is successful.Failure: If another update has […]
Node.js EOL (End of Life) and Mitigation Strategies
1. Node.js Support Lifecycle Node.js follows a release schedule, and each version goes through three phases before reaching EOL (End of Life): 2. Node.js EOL Schedule As of March 2025, the EOL schedule for Node.js versions is as follows (check the official site for the latest updates): Version LTS Start LTS End (EOL) 18.x (LTS) […]
Understanding Amazon QuickSight Datasets
1. What is a QuickSight Dataset? An Amazon QuickSight dataset is a structured collection of data used for visualization and analysis in QuickSight.It connects to external data sources (Athena, S3, RDS, Redshift, etc.) and allows users to build dashboards and reports. 2. Key Functions of a Dataset 3. Types of QuickSight Datasets Amazon QuickSight supports […]
Resolving “This branch has conflicts that must be resolved” in GitHub
When merging a pull request in GitHub, you may encounter the message:“This branch has conflicts that must be resolved.”This indicates that the changes in your branch conflict with the target branch (e.g., main or develop), and the conflicts must be manually resolved before merging. 1. Identifying the Conflicting Files Checking Conflicts in GitHub UI 2. […]
Is AWS RDS db.t3.micro Suitable for Production?
Among RDS instances, the db.t3.micro type is the most cost-effective and is commonly used for testing and validation purposes.But can it withstand production workloads? Additionally, in what use cases would it be suitable?I have summarized these points in this article Overview of db.t3.micro db.t3.micro is a burstable instance type in AWS RDS. It is the […]