使用 GROUP BY 優化 AWS Athena 查詢
分享一個最近使用 AWS Athena 進行大型資料集查詢時所用到的 SQL 查詢優化小技巧。AWS Athena 是一個無伺服器的互動式查詢服務，讓使用者可以透過標準 SQL 語法直接分析儲存在 Amazon S3 中的資料，無需預先配置或管...
Hi! I'm Allen
A DevOps Engineer
Experienced backend developer who is skilled in operations and cloud services . Passionate about exploring both frontend and backend technologies in my free time. My work style is adaptable, but I strive for precision and rigor.
I Love
Love sharing!
Check Out These Fun Projects I did
Blog
This is a simple blog made with Tailwind CSS , Alpine.js , Laravel and Livewire . Whether it is technical problems encountered at work, video games recently played, or interesting things that happened in life, they will be written here to share with everyone.
Go →
Note
Here are the notes I use to record learning Whether learning new operation techniques or researching new programming languages, they will be recorded here. I hope it can help those in need, and everyone is welcome to provide comments and suggestions!
Go →
Slide
After studying, there is nothing more fun than sharing your new knowledge with others I often share various techniques and knowledge friends and learn from them. Everyone is welcome to take a look!
Go →
Check it out!
My latest posts
使用 Fluent Bit 將 Docker 日誌傳送至 S3 上儲存
我們公司內部有些服務是使用 Docker 容器運行的。前陣子我們想要把容器運行的日誌（Log）上傳到雲端中儲存，所以我開始尋找有哪些方式可以達到這個目的。幸好 Docker 本身就支援多種日誌驅動程式，所以要將日誌上傳...
使用 PHP 來寫瀏覽器測試吧！
熱門測試框架 Pest 的作者 Nuno 大大，在今年的 Laracon US 上正式發表了 Pest 4。這次的大版本更新同樣帶來了許多亮點，其中最受矚目的就是整合了流行的 e2e（End-to-End）測試框架 Playwright。所以！現在你也能直...
提交一個 PR 到 Inertia.js
最近開始在惡補過去的年度目標，也就是用 Inertia.js 搭配 Svelte 與 Laravel 來寫個 SPA 網站。不得不說不用寫 API，而且前端與後端都能使用自己喜歡的技術，在開發上真的是一件很讓人愉快的事情，。來說說前幾週向...
在 Inertia.js 中防止用戶登出後返回敏感頁面
最近開始在用 Inertia.js 搭配 Laravel 與 Svelte 寫網頁。不用不知道，一用嚇一跳，有了 Inertia.js 當做前後端的粘合劑，我除了不用寫 API 以外，還可以在前後端都使用自己喜歡具工具，開發起來真的非常舒服。不過...
Revert 合併後的修改提交
在工作上與別人合作寫程式的時候，基於保險與禮貌，我們不能隨隨便便 Reset 別人的提交，而是應該使用 Revert 產生一個新的提交來撤銷原本的修改。Revert 的指令相單簡單，不過如果你是想要 Revert 一個已經合併後的...
From Dev to DevOps
My Past Made Me
Learn to be a DevOps Engineer
Through developing blogs, I came across cloud services and various maintenance tools, and discovered the fascination of DevOps. How to ensure the quality of the code and automatically deploy it to the official environment to run stably is a very interesting thing to me. By chance, I got an offer to be a DevOps engineer and decided to change my career path to become a DevOps engineer.
AWS
Azure
GCP
K3s
Terraform
Ansible
Actions
Python
Learn Frontend Skills and Start Writing Blogs
With the advice of my predecessors, I spent a few months to develop my own blog and build it on cloud service. I shared my passion for technology and the challenges I encountered in my work through articles on my blog, hoping to help people who encountered the same problems as I did. Writing articles has benefited me a lot, not only helping me to deepen my memory, but also allowing me to meet a lot of like-minded partners.
PHP
Rust
Laravel
Livewire
Svelte
TypeScript
Tailwind
AWS
Learning Backend Development
I decided to become a backend engineer because of my interest in web development at work.Although I started late, with the help of my coworkers and my own efforts, I gradually grew into a qualified backend engineer and accumulated rich experience in backend development.
PHP
Laravel
MySQL
Redis
Nginx
Newcomers to Information Security
My first job was in the information security field. I assisted in the development of security tools, and also assisted in the design of security courses, the preparation of target environment and the writing of teaching materials. I learned a lot of basic knowledge related to information security in this job, and also successfully obtained a basic CEH certification.
PHP
Laravel
MySQL
Python
These stuff are so cool!
The Skills I Specialize In
Hey! my friends
Want to Know More About Me ?
In fact, I am also...
01
A Full Stack Developer
After work, I like to explore technology areas that are completely different from my job. I've dabbled in frontend, backend, and even databases. Although these areas may seem unrelated to my job, through these explorations I've been able to gain a deeper understanding of developers' needs and create efficient workflows and service architectures tailored to their needs.
02
A Good Listener and Communicator
I believe that communicating with others and listening to their needs is essential to the success of a team. Through good communication, we can not only learn more from each other, but also understand how to work together more effectively.
03
A lover of outdoor activities
Lounging on the couch, watching an animation or a movie, or sitting in front of the computer thinking about how to solve the bugs make me relax. But apart from staying at home, I also like to go outdoors. Enjoying the sun, running, biking and camping, these are my favorite outdoor activities.