Scripts and tips

Bash scripting memo

Linux

A memo on useful commands to create a bash script.

Talend : bind variables in SQL query

Talend

Problem exposed. On Talend, there is not always the possibility to do make a select query prepared with the binding of variables, as on dBeaver. It would indeed be interesting to be able to make a request as below...

Number of opened/openable files on Linux

Linux

On Linux as on Windows, there are thresholds fixing the number of files open simultaneously per process and for the whole system. Here are some commands to display them.

Allow geolocation in HTTP

HTML / JS / CSS

If you develop a website locally, you do not necessarily use an SSL certificate. Unfortunately, this blocks certain features, such as geolocation. Here's how to work around the problem.

Talend: fix "Plugin X or one of its dependencies could not be resolved"

Talend

On Talend, you can have the following exception: "An error occurred (java.lang.Exception: [ERROR] Plugin X or one of its dependencies could not be resolved: Cannot access central (https://repo1.maven.org/maven2/) in...

Talend: avoid modifying context variables during a job

Talend

On Talend software, on a job, it's possible to assign the value of a context variable, via a tJava, by writing for example: context.myVariable="abc";There is no error and most of the time it goes very well. Except...

Read and edit ePUB files

Various tips

An overview of some software on Windows to view ePUB files.

Fix "Unknown: failed to open stream: No such file or directory in Unknown on line 0"

PHP

While viewing your website, you may have the following two errors displayed: Warning: Unknown: failed to open stream: No such file or directory in Unknown on line 0 Fatal error: Unknown: Failed opening required...