Tag Archives: Database

Kotlin: Database Migration – Harmonica 0.0.4


Warning: Parameter 2 to qtranxf_postsFilter() expected to be a reference, value given in /home/and-beyond/www/main/wp-includes/class-wp-hook.php on line 286

I tried to create Kotlin database migration library.

Continue reading Kotlin: Database Migration – Harmonica 0.0.4

Make PostgreSQL Accessible from Outside


Warning: Parameter 2 to qtranxf_postsFilter() expected to be a reference, value given in /home/and-beyond/www/main/wp-includes/class-wp-hook.php on line 286

I will introduce how to make PostgreSQL accessible from outside clilent. ホストOSから VirtualBox の中の PostgreSQL にアクセスする方法 の内容と重複する部分があります。

Continue reading Make PostgreSQL Accessible from Outside

PostgreSQL: Show Column Values Vertically retrieved by SELECT SQL


Warning: Parameter 2 to qtranxf_postsFilter() expected to be a reference, value given in /home/and-beyond/www/main/wp-includes/class-wp-hook.php on line 286

Here, I introduce the way to show values vertically which are retrieved by SELECT SQL in PostgreSQL.

Continue reading PostgreSQL: Show Column Values Vertically retrieved by SELECT SQL

PostgreSQL: How to Get Current Year, Month, Day, Hour, Minute and Second


Here is the way to get current year, month, day, hour, minute and second in PostgreSQL.

Continue reading PostgreSQL: How to Get Current Year, Month, Day, Hour, Minute and Second

How to Access to PostgreSQL in VirtualBox Guest OS from Host OS


Warning: Parameter 2 to qtranxf_postsFilter() expected to be a reference, value given in /home/and-beyond/www/main/wp-includes/class-wp-hook.php on line 286

Here’s a tips to connect PostgreSQL in VirtualBox guest OS, from host OS. Host OS can be Windows and Mac, because this is change of PostgreSQL setting.

Continue reading How to Access to PostgreSQL in VirtualBox Guest OS from Host OS