CodingShawn

Streaming Response part.2: Implementing Streaming with AWS Lambda, Python, FastAPI, and OpenAI: Leveraging the AWS Web Adapter

Jul 11, 20243 min read

Our company has a new requirement involving a series of data analyses followed by a summary of conclusions using OpenAI. However, the colleague...

Streaming Response part.2: Implementing Streaming with AWS Lambda, Python, FastAPI, and OpenAI: Leveraging the AWS Web Adapter

Streaming Response part 1: Server Sent Event

Jul 1, 20242 min read

3 methods to stream response In fact, to achieve the Streaming effect, you can use three methods: Server Sent Event (SSE) => This is the method...

Calling AWS Lambda Function URLs with IAM Auth

Jun 27, 20242 min read

In a previous article, I detailed the process of utilizing GitHub Actions and AWS CDK to deploy Python code to AWS Lambda, including the setup of...

用 Github Action and AWS CDK 部署 Python 到 AWS Lambda

Jun 18, 20241 min read

今天幫忙同事研究怎麼把 python 的 code 部署到 AWS Lambda，但是必須透過 Github Action 進行部署。自己本身不太熟 python，所以搞了一個下午Q"Q不過還好是搞成功了～～ 這是最後完成的 example repo，有需要的人可以直接複製，接著照我 README...

如何在 Node.js 使用 mysql 套件做到資料批量更新

May 10, 20231 min read

一直用 UPDATE 不斷失敗 本來想說跟批量插入的寫法差不多，但一直試都不行 const params = [ ['PROCESSING', '111'], ['PENDING', '222'] ] const sql = 'UPDATE dashboards SET status =...

MySQL 批量插入跟多次單筆插入的效能差異

May 9, 20231 min read

批量插入會 rollback 回滾 如果批量插入 100 筆資料，其中一筆有問題的話，其他筆的資料也會回滾，所以結果就是就是 100 筆通通成功，或者 100 筆都不成功。 批量插入的效能比較好 我是參考這三個文章： MySQL 批量插入数据，一次插入多少行数据效率最高？ Which is...