Valery YakovlevExporting results from Postgres to CSVThere is a convenient way to export results of your query to CSV. Directly from postgres CLI.Nov 8, 2023Nov 8, 2023
Valery YakovlevSelect in jsonb array exampleIn this article we’ll consider example of selecting db entries by postgres jsonb field. Particularly, we’ll perform select operation on…Apr 28, 2020Apr 28, 2020
Valery YakovlevThreads are not stopped problem (nice JVisualVM charts!)I noticed that the app was failing with following error:Feb 10, 2020Feb 10, 2020
Valery YakovlevPostgreSQL: Create table asCreate table as is an effective way to make a copy of a database table including all the columns with their types, and data.Feb 6, 2020Feb 6, 2020
Valery YakovlevDate is always serialised as longI discovered that dates were serialised as timestamps (longs) in controller responses in our project. Despite all attempts to override…Dec 18, 2019Dec 18, 2019
Valery YakovlevCron spring scheduler memoI always forget cron notation so will specify here short memo on how to use cron.Aug 16, 2019Aug 16, 2019
Valery YakovlevJOOQ: How to check that row existsIn order to check if row exists using JOOQ, one should use fetchExists() method and pass there a select query, with required conditions.Jun 27, 20191Jun 27, 20191
Valery YakovlevCommand line youtube downloaderTypically when I wanted to download a youtube video I installed some chrome plugin or went to third party web site with lots of ads and…Apr 11, 20191Apr 11, 20191