Posts

Content One of the biggest milestones for me in 2025 was seeing our company’s new repositories go live in May—and run smoothly throughout the rest of the year: the CRM (Customer Relationship Management) service and the Identity Server. After multiple iterations, prototypes, and rounds of internal feedback, both systems finally went into production. I was responsible for building both the Identity Server and the CRM service. With this setup, users can log in using different social media accounts and earn reward points when shopping in physical stores, through our mobile app, or via the online ordering website....

1. Introduction I had to design a DynamoDB schema to support both one-to-many and many-to-many relationships in my company’s invoice center. Coming from an RDBMS background, it took me about a week to really understand how to model these types of relationships in a NoSQL environment. There are several ways to approach it, and in this article, I’ll show you one of the most common patterns for handling relationships in DynamoDB....

1. Introduction Are you confused about the type of OAuth2 you should be using? Or do you not even know that there are several grant types in the OAuth2 protocol? Here’s a quick guide to help you understand the differences between them and determine which one you should use. 2. 4 Authorization Grant Types Authorization Code Grant The authorization code grant is the most common, secure, and recommended grant type. After the resource owner grants permission, the authorization server redirects them to a callback URL with an authorization code in the query string....

1. Introduction Imagine you need to generate a large report file and store it in AWS S3. As a software engineer, you must efficiently manage limited memory and network bandwidth in a distributed system. Here are 5 key benefits of using AWS S3 Multipart Upload to make this process more effective. 2. 5 Benefits Minimize Memory Usage With multipart upload, there’s no need to load the entire file into memory. Instead, you can divide the file into smaller chunks and upload them gradually....

Recently I have been using Server-Sent Events (SSE) to develop a feature where the server can notify the client at specific points in time. This article will provide an easy explaintion of what SSE is, when to use it, and how to implement it on both the client and server sides. 1. Introduction Imagine you need real-time updates on your website, such as displaying live stats from the server. While WebSocket might come to mind for creating bidirectional connection, that could be overkill if you only need one-way communication from server to client....

We’ll explore five of the most common sorting algorithms: Bubble Sort, Selection Sort, Insertion Sort, Merge Sort and Quick Sort. Each will be implemented in JavaScript, with an analysis of their time and space complexities. 1. Bubble Sort function bubbleSort(arr) { for (let i = 0; i < arr.length; i++) { for (let j = 1; j < arr.length; j++) { if (arr[j - 1] > arr[j]) { [arr[j - 1], arr[j]] = [arr[j], arr[j - 1]]; } } } return arr; } This code can be optimized by ruducing the numbers of iteration in the inner loop and exiting early if the array is already sorted....

This article provide a straightforward guide to dockerizing NestJS application for both develpoment and production environments. Dockerfile for Development First, let’s create a Dockerfile.dev for the development environment within our NestJS repository: # Dockerfile.dev FROM node:20-alpine WORKDIR /usr/src/app EXPOSE 3000 CMD ["npm", "run", "start:dev"] COPY package*.json ./ RUN npm install COPY . . In this Dockerfile, we specify the Node.js version along with the Alpine Linux distribution to minimize the image size....

Laravel 關聯性Model基礎操作：belongs_to, has_one, has_many, many to many 1. 一對一關係 has_one 假設兩個Model：店主Owner、商店Store，店主擁有一間商店(Owner has one Store)，商店屬於一位店主(Store belongs to Owner)。 Owner: - id - name Store: - id - name - owner_id 首先要為Store創建欄位owner_id，在migration中可以使用$table->foreignId('owner_id')建立欄位(foreignId等同於unsignedBigInt)。 Owner.php中寫入hasOne： // app/Models/Owner.php public function store() { return $this->hasOne(Store::class); } Store.php中寫入belonsTo： // app/Models/Store.php public function owner() { return $this->belongsTo(Owner::class); } 使用方法： // 從Owner角度建立Store // 方法一：使用create $o1 = Owner::find(1); $o1->store()->create(['name'=>'store1']); // 方法二：使用save $o1 = Owner::find(1); $s2 = new Store(['name'=?'store2']); $o1->store()->save($s2); // 從Store角度建立Owner $o2 = Owner::find(2); $s3 = new Store(['name'=>'store3']); $s3->owner()->associate($o2); $s3->save(); // 撈取該Owner的Store $o1->store; $o1->store->name; // 撈取該Store的Owner $s1->owner; $s1->owner->name; hasOne與belongsTo都可以獨立設置foreign key或owner key：...

PHP (Hypertext Prepocessor) 超文字預處理器，為直譯式的程式語言，可嵌入在HTML中使用。這裡記錄了PHP基礎語法與常見的函數。 1. 環境安裝與設定 下載PHP的方式： MAMP(適合Wordpress) Homebrew(適合Laravel等框架) 常見的web server: Apache Nginx(需要處理fpm) PHP自帶的web server(不是很好用) PHP設定檔為php.ini，位在/opt/homebrew/etc/php/8.1/ 1.1 Homebrew 安裝 PHP $ brew install php $ brew install [email protected] # reopen terminal $ which php # /opt/homebrew/bin/php $ ls -al "php安裝的路徑" $ brew link php $ brew unlink php $ echo $PATH # 前面的指令優先級較高 $ php -S 127.0.0.1:8000 # 運行index.php 2. PHP基礎語法 PHP使用<?php、?>作為開頭與結尾： <?php // php code ?> 2.1 註解 Comment // 單行註解，較常使用 # linux風格的單行註解 /* 這是 多行縮排 */ 2....

如何使用 Polymorphic Associations 多型關聯。 1. 使用情境 想像你正在設計「評論」功能的資料庫架構，使用者可以在幾乎任何地方留下評論，例如產品、貼文、活動等，此時你會想到使用一對多關係，為這三個 Model 設計出ProductComment、PostComment、EventComment，但此時你發現這三個資料表的欄位幾乎一模一樣，如果分成三個 Model 顯得相當冗餘，此種情景就相當適合使用Polymorphic 多型關聯來簡化資料庫的設計，使用Polymophic可以使模型在同一個關聯上屬於多個模型。 2. 使用方法 同樣以Comment這個model舉例，建立Polymorphic model的指令： rails g model Comment content:text commentable:references{polymorphic} 觀察一下產生的 migration 檔： # 產生的migration檔案，references版本 class CreateComments < ActiveRecord::Migration[7.0] def change create_table :comments do |t| t.text :content t.references :commentable, polymorphic: true, null: false t.timestamps end end end # 產生的migration檔案，較複雜的版本 class CreateComments < ActiveRecord::Migration[7.0] def change create_table :comments do |t| t.string :name t.bigint :commentable_id t.string :commentable_type t.timestamps end add_index :comments, [:commentable_type, :commentable_id] end end 接著執行rails db:migrate在資料庫產生資料表與更新schema。...