Written by 
(Image by peoplecreations on Freepik) “Implement now, plan later.” This was the comment of Filipinos after the Land Transportation Office temporarily suspended the implementation of an order fining vehicle buyers and sellers who failed to register their transactions with the government immediately. The government agency on Thursday, October 23, said that it is stopping the […]
A cool standard SQL:2003 feature is the aggregate FILTER clause, which is supported natively by at least these RDBMS: ClickHouse CockroachDB DuckDB Firebird H2 HSQLDB PostgreSQL SQLite Trino YugabyteDB The following aggregate function computes the number of rows per group which satifsy the FILTER clause: SELECT COUNT(*) FILTER (WHERE BOOK.TITLE LIKE ‘A%’), COUNT(*) FILTER (WHERE […]
Recently revisiting computer science fundamentals, I was interested to see how specific data structure applies to iOS development, starting this week one of most common data structure: the queue. My daily usage of data structure is often limited to native one available in iOS development: arrays, sets, dictionaries. However, if there is a data structure […]