Posts
All the articles I've posted.
-
Programmers SQL #2 — Sorting Isn't sort, It's ORDER BY
The second problem was easy to solve. When I thought of sorting, sort came to mind first, but in SQL it's ORDER BY. I also used multi-column sorting for the first time, something I only knew conceptually before.
-
Programmers SQL #1 — SELECT · FROM · WHERE have an order
I started solving Programmers problems to study SQL. On the first problem I hit a syntax error because I didn't follow clause order, then worked through it by looking up AS · AVG · ROUND one by one.
-
Studying the Port Domain #5 — Busan Port Is One Space, But the Data Is Scattered
On whether to get public data as files or via API, and what the Ministry of Oceans and Fisheries, Busan Port Authority, and Korea Customs Service each hold. A record of learning that even though everything happens in one port, the data is split across different agencies.
-
Studying the Port Domain #4 — Identifiability, and Public Data Is Just a Record
An IMO number never changes until the ship is scrapped. I went through the code systems for ships, cargo, and equipment, looked at how to get data from PORT-MIS and UNI-PASS, and worked out why public data can't be used for analysis as-is.