tag:blogger.com,1999:blog-2376655286569024124Wed, 27 Aug 2025 12:43:35 +0000PHPjQueryApacheMySQLGitWordPressdockerreactAJAXJSONarrayhtaccesshtml tableoracle 12cupdate.htaccessDOMHighlightIFSSHSVNSymfonyTypeScriptVirtualBoxWindowsaliasesaxiosbranchdatabase tabledebugdeleteexecutefile permissionsinsertinstalllinuxmultiple sitesnodejsobjectpushqueryremote reporeplacesearchxdebug1.1302APCAPICASECRYPT_BLOWFISHDependancy InjectionFIND_IN_SETFormGKEGNOME desktopGoogle Kubernetes EngineGoogle MapsHEADJSONPKDiff3MeldOOPOverridePDOPEARPHP Design PatternsPrepareProductionRedirectRewrite TipsSOAPSWITCH CASESimplePostToolSoapClient classTDDTextTwitterWPXMLaddadd file to SVN ignoreadditionsand criteriaanimateapache solrassertionasyncauto incrementawaitbackendbearer tokenbindParamblowfishboostrapbowerbranch as commitbranch from commitbranchesbrowsercachecartcentoscheckboxchmodchownclear cacheclient idclient secretclonecommandcommitcomparecomposerconcurrent callsconflict resolutionconnect derived tableconsolecontrollercreate linux usercreate user and databasecross sitecryptcurldatabase connectivitydelaydelete filedependancydifftooldocker imagedownload filedry rundumping variableeclipseenv. variableerror logevent attachevent removeexceptionexpand partitionfailedfilter array of objectsflashbackfor loopforeachfunctiongetgettergit deamongit protocolgitlabgpartedgrant typegruntgulphelm charthierarchicalhookshttpd.confiFrameininner joininstall Aptanainstall JDKiteratejsjwtlist numeric permisssionsloaderlocallocal repositorylodashloglooplufthansa apimassmcryptmembermergemerge branchmergetoolmigratemodelmongodbmount usbnmp installnode_modulesnpmnullonone way hashoracleoutpackpaginationparamsparent_idparseparse tablepassphrasepasswordphpstormphpunitportionprivateprocedureprotectedproximity searchpublicpublisherputqueuereactjsready to rumblerebaseremote repositoryreplace objectrepositoryresize volumerestful apirevertrowrow by rowrsarunsaltsame tablesavesearch JSONset ajax headersettershell scriptshortcodesingle IPsingle hosting accountsplit VMDKstopPropagationstoredstringsubfolderssubscribertabletartest memcachetest memcachedtimingtokentracking branchtranslate stringtranslate themetriggertrunkubuntuundefinedunpackupdate objectupgradeupload folderuseMemouseStateversion controlwatch variablewebweb serverwebgrindwebrootworkflowzip archiveBest tutorials and tips for developers.https://all4developer.blogspot.com/noreply@blogger.com (Nikola Bodrozic)Blogger105125tag:blogger.com,1999:blog-2376655286569024124.post-3819653311414581177Sat, 25 Feb 2023 17:04:00 +00002023-02-25T14:23:22.087-08:00useMemouseMemo prevents unnecessary rendering of child components: import React, { useState, useEffect, useMemo } from "react"; &nbsp; const Child = ({ param }) =&gt; { useEffect(() =&gt; console.log("child rendered at ", new Date().toLocaleTimeString()) ); return &lt;div&gt;prop in child: {param}&lt;/div&gt;; }; &nbsp; const App = () =&gt; { const [counter, setCounter] = useState(3); https://all4developer.blogspot.com/2023/02/usememo-hook.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-1639266469786505426Tue, 01 Nov 2022 00:21:00 +00002023-02-25T10:12:27.660-08:00addarrayreplaceuseStateWorking with Array of Objects and Objectanother example with delete update https://all4developer.blogspot.com/2022/10/react-usestate-hook.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-8074847283430618438Thu, 01 Sep 2022 10:43:00 +00002022-09-01T03:52:18.966-07:00Bable can transpile ES6 code to JS code that can be processed by Node.Folder and file structure:Here is package.json <!--HTML generated using hilite.me-->{ "name": "node-server-using-es6", "version": "1.0.0", "description": "Node Server compiles code to ES6 using babel", "main": "lib/index.js", "scripts": { "build": "rimraf build &amp;&amp; babel src -d dist", "start": "nodemonhttps://all4developer.blogspot.com/2022/09/nodejs-and-es6.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-570185014848350744Thu, 27 Jan 2022 09:45:00 +00002022-01-27T01:47:01.156-08:00For React project create folder .vscode an in it launch.json <!--HTML generated using hilite.me-->{ "version": "0.2.0", "configurations": [ { "type": "chrome", "request": "launch", "name": "Launch Chrome on localhost:3000", "url": "http://localhost:3000", "webRoot": "${workspaceFolder}/src", "userDataDir": "$https://all4developer.blogspot.com/2022/01/launch-browser-in-code.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-1770644041362924256Fri, 21 Jan 2022 17:15:00 +00002022-01-21T09:15:46.935-08:00Passing function as argument and callback in setState. <!--HTML generated using hilite.me-->import React from 'react'; export default class App extends React.Component { state = { users: [], status: 'initial', }; componentDidMount() { this.getUsers(); this.myCoolFunction('first', 'second', (result) =&gt; console.log('yay the result is', result)); this.myCoolFunction(https://all4developer.blogspot.com/2022/01/react-callback.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-3410878874882953539Mon, 22 Nov 2021 19:12:00 +00002021-11-22T11:22:40.300-08:00delete filegulpreactreplaceReplace &amp; Delete files in build folder using Gulp gulpfile.js&nbsp; <!--HTML generated using hilite.me-->const gulp = require('gulp'); const replace = require('gulp-string-replace'); const rimraf = require('gulp-rimraf'); function changeLang() { const searchFor = '&lt;html lang="en"&gt;'; const replaceBy = '&lt;html lang="de"&gt;'; return gulp.src('./build/*.https://all4developer.blogspot.com/2021/11/gulp-react.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-6161061420880904167Sat, 20 Nov 2021 00:54:00 +00002021-11-19T16:56:12.840-08:00CSP HTTP header and Meta Tag must be synchronized. There must be two hashes one for hard coded JavaScript other for generated JavaScript tag.&nbsp; index.html &lt;!DOCTYPE html&gt; &lt;html lang="en"&gt; &lt;head&gt; &lt;meta charset="UTF-8" /&gt; &lt;meta name="viewport" content="width=device-width, initial-scale=1.0" /&gt; &lt;meta http-equiv="X-UA-Compatible" content="ie=edge" https://all4developer.blogspot.com/2021/11/csp-and-dynamically-generated.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-5042309348811159626Mon, 15 Nov 2021 20:47:00 +00002022-06-07T11:41:53.429-07:00gitlabreactGitLab for React Make sure you are using same node image in the pipeline and Dockerfiles optimised .gitlab-ci.yml using artifacts stages: - build - test - push image: name: node:16-alpine entrypoint: [""] build_r: stage: build artifacts: paths: - node_modules/ - package.json - package-lock.json expire_in: 1 day before_script: - apk -U upgrade https://all4developer.blogspot.com/2021/11/gitlab-pipeline-and-react.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-5653803287109815572Fri, 10 Sep 2021 19:04:00 +00002021-09-10T12:04:44.981-07:00ApachedockerDockerfile for installing Apache on Ubuntu: FROM ubuntu:20.04 ENV TZ=Europe/Berlin RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime &amp;&amp; echo $TZ &gt; /etc/timezone RUN apt-get update &amp;&amp; apt-get -y install apache2 EXPOSE 80 CMD ["/usr/sbin/apachectl", "-D", "FOREGROUND"] Build and run <!--HTML generated using hilite.me-->docker build -t ubu-apache . docker run --name=https://all4developer.blogspot.com/2021/09/apache-on-ubuntu.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-2950645575706491519Sun, 18 Jul 2021 16:31:00 +00002021-07-18T09:42:03.375-07:00boostrapcheckboxreactTypeScriptWorking with React Bootstrap checkbox import React, { PureComponent } from &quot;react&quot;; import Form from &quot;react-bootstrap/Form&quot;; interface CheckBoxState { checkedColors: any[]; } interface CheckBoxProps { foo: string; } class CheckBox extends PureComponent&lt;CheckBoxProps, CheckBoxState&gt; { constructor(props: CheckBoxProps) { super(props); this.state = { https://all4developer.blogspot.com/2021/07/react-checkbox.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-8220497896722426236Fri, 07 May 2021 16:54:00 +00002021-05-07T09:56:38.351-07:00Postgres &amp; Adminer on Docker stack. version: '3' services: postgres: image: postgres:13.2-alpine restart: always environment: POSTGRES_PASSWORD: secret POSTGRES_USER: pguser POSTGRES_DB: pgdb ports: - "5432:5432" volumes: - pg-data:/var/lib/postgresql/data networks: - pg-network &nbsp; adminer: image: adminer:https://all4developer.blogspot.com/2021/05/postgres-adminer-on-docker.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-3509457165448548327Thu, 15 Apr 2021 18:57:00 +00002021-07-20T11:00:52.097-07:00nullTypeScriptundefinedHere is how to use in combination to determine if property is null or undefined. interface Product { id: number, name?: any } let product: Product = {id: 5, name: "some str"}; if(product!.name) console.log("ok") product = {id: 5} if(product!.name) console.log("not printed") product = {id: 5, name: null} if(product!.name) console.log("not printed") Second if will not be excecated https://all4developer.blogspot.com/2021/04/typescript-question-mark-and.htmlnoreply@blogger.com (Nikola Bodrozic)Munich, Germany48.1351253 11.581980519.824891463821153 -23.5742695 76.445359136178837 46.7382305tag:blogger.com,1999:blog-2376655286569024124.post-872822743173337275Thu, 04 Feb 2021 21:34:00 +00002021-02-04T13:34:46.591-08:00Here is how to create a log file for your script: SET echo ON SET feedback ON SET SERVEROUTPUT ON SET linesize 500 COL spoolname new_value filename SELECT TO_CHAR(systimestamp, 'YYYY_MM_DD_HH24_MI_') || (SELECT SYS_CONTEXT ('userenv', 'current_schema') FROM dual) || '_log_name.log' AS spoolname FROM dual; SPOOL &amp;filename -- start main SQL script INSERT INTO my_table (total) VALUES (25)https://all4developer.blogspot.com/2021/02/oracle-spool.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-505656048021912952Fri, 22 Jan 2021 00:58:00 +00002021-01-21T17:52:58.430-08:00Oracle package with procedure, function and global variable CREATE OR REPLACE PACKAGE my_package AS g_fav_num NUMBER := 5; PROCEDURE my_proc (val INTEGER); FUNCTION double_func (in_val IN NUMBER) RETURN NUMBER; END my_package; / CREATE OR REPLACE PACKAGE BODY my_package ASPROCEDURE my_proc (val INTEGER) IS BEGIN g_fav_num := g_fav_num + val; INSERT INTO my_table ( https://all4developer.blogspot.com/2021/01/oracle-package.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-8929467608784578252Thu, 17 Dec 2020 22:37:00 +00002020-12-17T14:41:21.209-08:00logoracle 12ctableIn Oracle 12c&nbsp; you create table: CREATE TABLE msg_log ( id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY, ts TIMESTAMP WITH LOCAL TIME ZONE, schema_name VARCHAR2(15), message VARCHAR2(250) ); <!--Created using ToHtml.com on 2020-12-17 22:31:01 UTC--> &nbsp;Create procedure: CREATE OR REPLACE PROCEDURE log_message ( message IN https://all4developer.blogspot.com/2020/12/logging-table-in-oracle.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-2738385454558996643Thu, 10 Dec 2020 07:44:00 +00002020-12-18T14:41:18.601-08:00exceptioninoracleoutparamsprocedurestoredSample of Oracle stored procedure with in &amp; out params &amp; exceptions. <!--HTML generated using hilite.me-->CREATE OR REPLACE PROCEDURE proc_name ( p1 IN VARCHAR2, p2 OUT VARCHAR2 ) AS msg VARCHAR2(30) := 'hello '; ex_some_exception EXCEPTION; BEGIN IF length(p1) &lt; 2 THEN RAISE ex_some_exception; END IF; p2 := msg || p1; EXCEPTION WHEN ex_some_exception THEN https://all4developer.blogspot.com/2020/12/oracle-stored-procedure.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-1221131069622124905Sun, 30 Aug 2020 09:18:00 +00002020-08-30T02:30:04.564-07:00Launch SQLPlus: [oracle@localhost ~]$ sqlplus Enter user-name: hr Enter password: EXEC HI -- HI is long running stored procedure Connect to Oracle as DBA and replace HR with you user sqlplus sys as sysdba select sid, serial#, status, program from v$session where username='HR'; ALTER SYSTEM KILL SESSION 'sid, serial#'; In SQL Developer: select s.username,s.sid,s.serial#,https://all4developer.blogspot.com/2020/08/kill-session-in-oracle.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-5603197945385996330Wed, 01 Jul 2020 06:59:00 +00002021-04-17T10:35:05.840-07:00Install OpenShift Origin on cloud machine with public IP Login to remote host $ ssh -i private_key user@nnn.nnn.nnn.nn Firewall settings&nbsp;cat /etc/firewalld/zones/public.xml &lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;zone&gt; &lt;short&gt;Public&lt;/short&gt; &lt;description&gt;For use in public areas..&lt;/description&gt; &lt;service name="ssh"/&gt; &lt;service name="https://all4developer.blogspot.com/2020/06/openshift-on-public-ip.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-3901529627920920369Fri, 12 Jun 2020 08:13:00 +00002020-09-10T15:31:31.768-07:00Node file app.js var nunjucks = require('nunjucks') var res = nunjucks.render( 'foo.html', { messages: ['foo', 'bar'], username: "mike" } ); console.log(res) template file foo.html {% if username === 'mike' %} {{ username }} {% endif %} {% for message in messages %} {{ message }} {% endfor %} Run node app.js Practical example for oracle log message var nunjucks = https://all4developer.blogspot.com/2020/06/nodejs-template-engine.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-2165464988994161805Wed, 18 Dec 2019 00:12:00 +00002019-12-17T16:29:18.463-08:00GKEGoogle Kubernetes Enginehelm chartMySQLHere is how to deploy and test connectivity of MySQL in Google Kubernetes Engine GKE # connect to cluster in Google Kubernetes Engine $ gcloud container clusters get-credentials &lt;your-cluster&gt; --zone &lt;your-zone&gt; --project &lt;your-project&gt; $ git clone --depth=1 https://github.com/helm/charts.git $ cd charts/stable/mysql $ vim values.yaml $ helm install --name dbserver -f https://all4developer.blogspot.com/2019/12/helm-chart-for-mysql-in-gke.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-2381183629559370299Tue, 17 Dec 2019 22:19:00 +00002021-07-23T10:16:59.896-07:00arrayfilter array of objectsiteratejslodashobjectreplace objectupdate objectBy using lodash you can loop through arrays and objects with ease const _ = require("lodash"); // replace object in array var arr = [{ id: 1, name: "Adam" }, { id: 2, name: "Bob" }]; var index = _.findIndex(arr, { id: 1 }); arr.splice(index, 1, { id: 100, name: "New man" }); document.write(JSON.stringify(arr)); document.write(`&lt;hr/&gt;`); // update object in array var mike = { id: 17, name: "https://all4developer.blogspot.com/2019/12/useful-javascript-snippets.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-4786550406008358388Sat, 16 Nov 2019 09:48:00 +00002021-09-09T14:32:49.005-07:00dockerdocker imagepushreactreactjsrepositoryThis tutorial shows how to create images and containers and push to hub.docker.com registry. GitHub repo is at https://github.com/nikola-bodrozic/Docker-ReactJS Simple Build on LinuxApache web server no Dockerfile, $(pwd) prints path to current folderdocker run -d --name apa -e TZ=UTC -p 8080:80 -v $(pwd)/html/:/var/www/html/ ubuntu/apache2 Development Build docker build -t reactapp:1.0 .docker https://all4developer.blogspot.com/2019/11/images-containers-and-docker-registry.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-121218323277490815Sat, 22 Jun 2019 21:04:00 +00002019-11-19T10:56:30.199-08:00dockerenv. variableOverrideshell scriptOverride env. variable and shell script defined in Docker file in run command. build an image docker build -t busybox . run container with env. variable &amp; run CMD in Dockerfile docker run busybox override env. variable in Dockerfile docker run --env ENV_TARGET=yahoo.com busybox override CMD in Dockerfile docker run busybox sh -c 'whoami &amp;&amp; pwd' Dockerfile FROM busybox WORKDIR /https://all4developer.blogspot.com/2019/06/override-env-variable-and-shell-script.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-6249804834578484401Sat, 22 Jun 2019 20:38:00 +00002019-06-22T13:45:05.910-07:00axiosconcurrent callsAxios can make multiple concurrent calls. In app.js calls to two end-points are started at the same time so total waiting time is 4 seconds. Server latency is 4 seconds for demo purposes. app.js const axios = require('axios') &nbsp; try { console.log("start"); function getUserName() { return axios.get('http://localhost:3000/heroes'); } &nbsp; function getId() { https://all4developer.blogspot.com/2019/06/axios-concurrent-calls.htmlnoreply@blogger.com (Nikola Bodrozic)0tag:blogger.com,1999:blog-2376655286569024124.post-6234811977778839561Mon, 17 Jun 2019 20:29:00 +00002019-06-22T13:48:48.463-07:00asyncawaitaxiosdelaydownload fileSometimes you need to wait for one (axios) call to finish to continue with next one. It's accomplished by using async/await. Last axios call in app.js downloads a file without waiting for getUser() to be finished. set server delay to 4 seconds for demo purposes { "name": "async-await", "scripts": { "serve-json": "json-server --delay 4000 --watch db.json", "start": "node app.js" },https://all4developer.blogspot.com/2019/06/axios-async-await.htmlnoreply@blogger.com (Nikola Bodrozic)0