Skip to content

Instantly share code, notes, and snippets.

AWSTemplateFormatVersion: '2010-09-09'
Description: Resources for Wild Ryde rider photo processing workflow.
Outputs:
RiderPhotoProcessingStateMachineArn:
Value:
Fn::GetAtt:
- RiderPhotoProcessingStateMachine
- Arn
FaceDetectionFunctionArn:
Value:
@khoa-le
khoa-le / gist:73e18cf9638c525b24d6941a14b8aa5f
Created February 9, 2023 07:25
Open AI Create Lamba services
Sure, here's an outline of the steps you can follow to develop an AWS Lambda function using PHP that reads data from an Excel file and saves it to Amazon DynamoDB:
Create a new Lambda function: Log in to the AWS Management Console, navigate to the Lambda service, and create a new function. Choose the "Author from scratch" option, and select PHP as the runtime.
Add an Amazon S3 trigger: In the designer section of the Lambda function, you can add an S3 trigger to trigger your function every time a new Excel file is uploaded to an S3 bucket.
Read the data from the Excel file: You can use a PHP library such as PHPExcel to read the data from the Excel file. You can access the uploaded file using the S3 bucket and key passed in the event data to the function.
Save the data to DynamoDB: To save the data to DynamoDB, you can use the AWS SDK for PHP to interact with the DynamoDB API. You can create a new DynamoDB table or use an existing one to save the data.
@khoa-le
khoa-le / gist:120e59dd87a3001ff30ecbf7f4494f96
Created February 7, 2023 09:01
Get SQL Log and time execute of Laravel Query Builder
\DB::enableQueryLog(); // Enable query log
// Your Eloquent query executed by using get()
dd(\DB::getQueryLog());
ffmpeg -i video.mov -c:v libvpx-vp9 -crf 30 -b:v 0 -b:a 128k -c:a libopus video.webm
#Convert video from 4K to FullHD
```
ffmpeg -i 50周年-PRビデオ_Final.mov -vf scale=1920:1080 -c:a copy output1080vid.mp4`
```
@khoa-le
khoa-le / gist:ba36820d2a62f2d40f674f0f4ee12f8c
Created February 6, 2023 10:52
Create cover image from 1 frame of video
ffmpeg -i video.mp4 -vframes 1 -f image2 cover.jpg
{ "transactions": 86430,
"availability": 99.97,
"elapsed_time": 299.43,
"data_transferred": 1568.13,
"response_time": 0.34,
"transaction_rate": 288.65,
"throughput": 5.24,
"concurrency": 97.42,
"successful_transactions": 86430,
"failed_transactions": 22,
@khoa-le
khoa-le / abc1.json
Last active September 28, 2022 07:51
{ "transactions": 28599,
"availability": 99.59,
"elapsed_time": 299.60,
"data_transferred": 933.64,
"response_time": 1.01,
"transaction_rate": 95.46,
"throughput": 3.12,
"concurrency": 96.64,
"successful_transactions": 28599,
"failed_transactions": 119,
@khoa-le
khoa-le / gist:e9587af6827ee66f9e046b9a83c74185
Created January 22, 2021 04:54
Create 4G Swap For Linux
#Create 4G swap (128M*32)
sudo dd if=/dev/zero of=/swapfile bs=128M count=32
sudo chmod 600 /swapfile
sudo mkswap /swapfile
sudo swapon /swapfile
6. Enable the swap file at boot time by editing the /etc/fstab file.
Open the file in the editor:
sudo ss -lptn 'sport = :10026'
@khoa-le
khoa-le / next-js-snippet.js
Created April 7, 2020 03:52
next.js snippet
##Use SWR to call ajax in client site
import useSWR from 'swr'
const fetcher = url => fetch(url, {
'Content-Type': 'application/json',
}).then(r => r.json());
function Profile() {