A while ago I started using Frigate as an alternative for the really crappy motion detection on my Foscam R2M IP camera and quickly found myself adding my other 2 Reolink camera's to it as well. However, CPU usage was pretty high despite it only having to handle 3 camera's and this inevitably leads to … Continue reading iGPU VAAPI acceleration on HA Frigate in Proxmox
Category: dev
Slow performance with NamedParameterJdbcTemplate
Today I tried inserting 256 rows in a single, empty PostgreSQL table which has only one index on it using Spring's NamedParameterJdbcTemplate . To my surprise the single transaction took over 3 minutes to complete, over 500ms per INSERT statement. To make things worse, the same inserts during integration testing on an H2 database completed … Continue reading Slow performance with NamedParameterJdbcTemplate
Adding Elastichsearch filebeat to Docker images
One of the projects I'm working on uses a micro-service architecture. Every micro-service is shipped as a Docker image and executed on Amazon AWS using ECS. This basically means that on a random number of servers, a (somewhat) random number of instances of a single micro-service can run ... and this about 15 times (the … Continue reading Adding Elastichsearch filebeat to Docker images
Log contextual information to all log messages in Spring Boot using Logback’s MDC
Logging is sometimes one of the things on which too little attention is spent, but when production errors start to arrive you'll sure want to have the maximum amount of information you want. Most logging implementations in Java will give you the time, the name of the class (or to be more precise, the name … Continue reading Log contextual information to all log messages in Spring Boot using Logback’s MDC
Using alternative credentials for Liquibase in Spring Boot
One of the projects I'm working uses Spring Boot to handle all database changes for each micro-service. One of the obvious requirements to make this work is a database user with DBA rights, otherwise it can not create, alter or drop tables. You could configure the default datasource to use such user, but this would … Continue reading Using alternative credentials for Liquibase in Spring Boot