TechnoApple Blogs
Developer's daily notes, blogs, and tutorials about software development, C#, Node.js, Javascript, AWS.
Use Big Query to aggregate data to find ranking
2023/12/05·2 min readCompare Similar DataSet in BigQuery
2023/08/07·1 min readHow to use BigQuery to Extract JSON Array
2023/08/05·1 min readHow to Use Big Query to Get Single Columns Values from All Rows
2023/06/06·1 min readHow to Use Big Query SQL Procedure
2023/06/05·1 min readHow to GCP Function locally with Node.js
2023/06/01·1 min readThis blog show how to test GCP Cloud Function locally with Node.js.
Deploy GCP Cloud Function with Event Trigger via PubSub
2023/04/06·2 min readThis blog create simple Node.js and deploy to GCP Cloud Function as PubSub Event Trigger.
Deploy GCP Cloud Function with Http Trigger
2023/04/06·1 min readThis blog create simple Node.js and deploy to GCP Cloud Function as Http Trigger.
How to Create AWS EC2 by Terraform
2023/02/03·2 min readThis blog will demonstrate how to setup AWS EC2 with Terraform at local
Install Terraform at macOS
2023/02/01·1 min readCRUD with Cloud Firestore and Node.js by Google Cloud Function
2022/10/06·4 min readThis blog show how to do CRUD operation with Firestore and Google Cloud Function
Use TypeScript with Google CloudFunction and Deploy locally
2022/10/01·4 min readThis blog show how to setup TypeScript with CloudFunction and Deploy to Google Cloud locally
How to Change DNS Nameservers from Godaddy to Point to AWS Route 53
2022/08/09·2 min readThis blog shows how to change your DNS Nameservers from Godaddy to point to the AWS Route 53. Assume you have registered a DNSdomain at Godaddy, but you want to host a website at AWS, here will provide steps on how to achieve this goal.
Install nvm for Running Different Node.js Version Locally
2022/07/09·1 min readHow to create GCP Monitoring Alert
2022/03/18·2 min readThis blog shows how to create monitoring alert with GCP and provide few examples.
Async Defer Inline or External Script Tag in JavaScript
2022/03/10·2 min readThe difference between async, defer inline and external script tag execution order.
PubSub to BigQuery via Dataflow with GCP
2021/11/16·2 min readGCP Pub/Sub is managed messaging service provide by GCP, this blog demo how to create Pub/Sub and use dataflow to subscribe datainto BigQuery.
Quick Start to Install Google Cloud Cli
2021/11/01·1 min readThis blog shows a quick memo on how to get started with GCP cloud cli.
Setting Up Next.js on AWS EC2 Instance
2021/10/02·2 min readNext.js is a React-based web application framework built on top of Node.js web application, AWS EC2 is Amazon AWS Service's cloudcomputing which hosts the VM in the cloud. In this tutorial, we will manually create an EC2 instance and then SSH into theinstance and install and set up the Next.js.
How to Auto Remediate AWS resources By Using AWS Config
2021/09/11·1 min readAWS Config is a service that will record and evaluate all the changes at your AWS services, it will also provide remediate thechanges. This blog will demo how to use AWS Config to auto remediate S3 bucket to enable the versioning.
How to Setup Swagger with Next.js
2021/09/09·4 min readThis blog walk through how to use Swagger / OpenAPI to add API document to Next.js, a node.js framework. It will cover how tocreate to API at Next.js and add API Document with Swagger by swagger-jsdoc and swager-ui-react.
How to Delete GCP Projects
2021/07/08·1 min readThis is a quick note on how to delete unused GCP Projects to save money.
How to Setup Swagger OpenAPI with Express.js
2021/07/01·3 min readThis blog walk through how to use Swagger / OpenAPI to add API document to the Express.js, node.js framework, it will cover how tocreate to API at Express.js and add API Document with Swagger by using OpenAPI 3.0 specification.
Use Lambda with Node.js to Insert Data Into DynamoDB
2021/06/01·2 min readThis blog show how to create AWS Lambda with Node.js and insert record into DynamoDB, also shows manully deploy Lambda as packageto AWS from the your local develop environment.
How to Deploy Lambda with Node.js with Package Dependencies
2021/05/06·3 min readAWS Lambda is serverless compute service and let you run code at AWS's managing servers on the cloud, you will only worry aboutyour code and AWS will manage the underneath servers. This blog is trying to show how to get start with Lambda by use Node.js withpackage dependencies, the code will include one dependency module util, it'll will use zip to compress the index.js andnode_modules folder.
How to Deploy Lambda with Node.js without Dependencies
2021/05/03·3 min readAWS Lambda is serverless compute service and let you run code at AWS's managing servers on the cloud, you will only worry aboutyour code and AWS will manage the underneath servers. This blog is trying to show how to get start with Lambda by use Node.js withNo package dependencies.
How to Self-Hosted Sentry.io at AWS EC2
2021/05/01·3 min readThis blog shows how to self-hosted Sentry.io with AWS EC2.
How to Getting Started with Sentry Error Tracking
2021/04/01·2 min readThis blog shows how to get started with Sentry.io for tracking JavaScript errors and performance.
How to Collect Memory Disk Usage By Using CloudWatch Agent
2021/03/20·2 min readThis blog provides a quick guide on how to set up CloudWatch Agent manually on EC2 Linux Instance, CloudWatch Agent enables you tocollect system or custom metrics from Amazon EC2 instances across operating systems. You can install CloudWatch Agent on AWS Cloudor on-promise server, Linux, or Windows as well.
List of AWS CloudTrail Record Fields
2021/03/07·1 min readAWS CloudTrail helps you record all API call at your AWS account, it enables you to detect who is making what kind of changes tothe AWS environment.