Andrewsy's Space

Stay Hungry,Stay Foolish

Building a Jira Ticket Developer AI Agent with GitHub Copilot

Have you ever dreamed of an AI assistant that can automatically create feature branches and implement code based on Jira

Building an MCP Server for Automated Diagnosis Simulator Management

Background: The Challenge of Manual Simulator ManagementIn our development workflow, we rely heavily on a diagnosis simu

Leverage AI Tools to write code base on Jira ticket requirements.

Have you ever imagined if AI can help you write code based on Jira ticket requirements? The AI technology is advancing r

Speech Translator base on Azure Speech Service

Today we’re going to talk about how to build a speech translator using Azure Speech Service of Azure AI . We’ll be using

Conversational RAG Chatbot - Build a Chatbot with LangChain and Chainlit

In previous blog, we have converting the PDF documents into the FAISS vector index, and saved in the local. Now, we will

Deploy User Friendly AI Interface Chatbot on Local by Using Ollama + Open-WebUI.

In Previous blog, we talk about how to running DeepSeek large language model (LLM) on local machine by using Ollama. For

Data Analysis Chart by Generative AI

In data analysis, we often need to create charts to visualize the data by using BI tools, such as Tableau, Power BI, AWS

The Intelligent SQL Generator base on Spring AI with AWS Bedrock

The generative AI is a type of artificial intelligence (AI) that can learn from data and generate new data. In this arti

MySQL 8.x CTEs feature - WITH clause

MySQL Common Table Expressions (CTEs) are a powerful feature introduced in MySQL 8.0. CTEs are a type of MySQL 8.0 that

Manage the Existing Cloud Resources By Using Pulumi Import

In many real-world scenarios, cloud infrastructure is already in place before adopting infrastructure as code (IaC) solu

2024-10-09

AWS Glue Iceberg tables schema can't be updated with Pulumi

Cloud Native

ContextRecently, we’re planing to use Pulumi to manage all current existing AWS Glue Datacatalog tables which are Iceber

2024-09-19

User Survey Feedback Sentiment Analysis Base on AWS Cloud Solution

Cloud Native

IntroductionThe App Product User Survey Feedback Sentiment Analysis Solution is a cloud-based solution that uses AWS ser

2024-09-10

How to Fix AWS S3 Event Replacing Space With '+' Character Sign in Object Key Name

Cloud Native

The issue with AWS S3 Event notifications is that it replaces spaces with ‘+’ character sign in the object key name. Thi

2024-08-16

SQL 中的 IS DISTINCT FROM 语法详解

Database

在SQL查询中，比较操作符 = 通常用于检查两个值是否相等。然而，当涉及到处理缺失值（NULL）时，这种操作符就会面临挑战。为了解决这一问题，SQL 提供了 `IS DISTINCT FROM` 操作符，它用于精确比较两个值是否不同，即使这

2024-08-15

详解 SQL 中的 LAG 函数

Database

最近在做数据分析，需要挖掘数据随时间变化的信息。所有数据物理存储在AWS S3上，通过AWS Glue Catalog和AWS Athena进行数据查询。AWS Athena支持SQL语言，可以对数据进行分析。在处理时间序列数据或分析行间变

2024-08-02

How to query tree-structured relation data in MySQL

Database

To query hierarchical relational data in MySQL, recursive Common Table Expressions (CTEs) are typically used. However, M

2024-07-26

MySQL 8.x CTEs feature - WITH clause

Database

MySQL Common Table Expressions (CTEs) are a powerful feature introduced in MySQL 8.0. CTEs are a type of MySQL 8.0 that

2024-07-04

Using Pulumi to Import the AWS Resources of the Other Region

Cloud Native

ContextBy default, the Pulumi import the resource in the region which is specified in the Pulumi.yaml or Pulumi.<stac

2024-06-25

Keras3.0 - A Multi-framework Machine Learning Library

AI/ML

Keras3 is a full rewrite of Keras that enables you to run your Keras workflows on top of either JAX, TensorFlow, or PyTo

2024-06-14

Web Security - Understanding the X-Frame-Options HTTP Header

Frontend

Recently, we build a frontend website as a nginx docker image, before go live on production. We asking the security team

5 / 21