Lookups in Apache Druid are a way to replace values by keys in datasources, without needing to actually change anything in the datasources. This is extremely useful for repeatable data. Common examples are replacing a country-code with the country name, language-code with the language name, and so on. For me…

ElasticSearch allows putting data into date-time fields in different formatting. You may have one field that was put as a numeric Epoch time (Unix / POSTIX time), and another that was put as an ISO datetime. fieldEpoch: 1621616091 fieldISO: 2021-05-21T15:04:05Z Then, you might want to create a field script that…

The standard for running an NGINX webserver for PHP is with PHP-FPM — PHP FastCGI Process Manager(see nginx docs, digitalocean docs). I experienced some major performance enhancements when switching from standard PHP on Apache HTTPD webserver to NGINX with PHP-FPM in my websites. PHP-FPM started as an independent project (many…

Couchbase query language N1QL is very annoying when it comes to WHERE...IN clause. I find it very odd that it decided to go different than RBDMS SQL queries, and require square brackets ["value1", "value2"] instead of the round brackets that are so common pretty much in every tool (and for DB people: in RDBMS SQL). A full functioning example for Couchbase N1QL: SELECT fields FROM bucket WHERE field IN ["value1", "value2", ...]

In Java, I come across a lot of unused “setter” and “getter” methods. Creating setters and getters often strikes roots with developers that work with Hibernate and Lombok. …

The foundation for a healthy project is a high standard of automated tests. When your code is well tested, with tests that cover actual scenarios and user behaviors, modifying the code is not as risky task as it was otherwise. …

Prettier can format your code, and one can have JetBrains WebStorm or IntelliJ do that from within the IDE. This guide assumes you installed prettier globally. Versions older than 2018.1 Go to File> Preferences (WebStorm) or Settings(IntelliJ) > Tools> External Tools. Click the Plus sign to add a new External Tool. Fill in the…

When using Docker to deploy an application, it is best to rebuild the application continuously — for example whenever the application is rebuilt. This way, one’s integration servers can be automatically up-to-date, and run end-to-end tests on the latest code. Docker has great positive influence on development processes and continuous integration…