programming [1 / 1]

SQLite Localtime Date Modifier is Slow

Today I found a weird bug in my company’s dashboard app where it took a long time to load data from SQLite database. The number of data is not too many (only around 400k> rows), yet it took several seconds to load. This is really weird, especially considering SQLite is famous for its reading speed. Turn out, this issue is happened because I was using localtime date modifier in my SELECT query.

Read more...
Build Static Qt 5.13.0 for Linux

While working on Qamel, I want it to support compiling static app for Linux and Windows. When targetting Windows, this is simple enough thanks to project like MXE and MSYS2 which already provided static Qt libraries. However, when targeting Linux platform, there are no choice except building static Qt libraries by ourself.

Read more...
Readability for Go

This post is an introduction for go-readability, a library for fetching the readable content from a web page. It’s released under MIT license and available here.

Read more...
Profiling Go Apps

There are several ways for profiling a Go application, but the easiest one that I’ve found is by using github.com/pkg/profile.

Read more...
Limiting Number of Goroutine

While scraping some data from website, I found out that some websites will deny your request if there are too many concurrent requests. To fix this, we need to limit number of goroutine that run at a time.

Read more...
Use Fathom for Analytic

Updated April 2019: I’ve stopped using analytic

Read more...
State of GUI App Development with Go in 2018

Several months ago, I’ve got a job to create a simple desktop app for my company. So, I’ve been looking for the packages, frameworks or toolkits for developing GUI app in Go. This post is intended as summary and brief analysis for packages that I’ve tried while working on my job.

Read more...