September 2, 2018 | In: Programovanie

Postgresql pridanie usera

Pred spustenim servera, treba zmenit ownera na subore : server.key

chown postgres.postgres /var/lib/postgresql/8.4/main/server.key

V novsich verziach to mozno netreba.

potom prihlasit sa na psql

1. su – postgres

vytvorenie noveho superuser

CREATE ROLE mysuperuser2 WITH SUPERUSER CREATEDB CREATEROLE LOGIN ENCRYPTED PASSWORD ‘mysuperpass2’; // heslo musi byt v uvodzovkach

a potom sa da zvysok upravit v pgadmine

Share This:

August 30, 2018 | In: Programovanie

mysql natural sort

Natural sort in mysql

Share This:

How to remove svn needs-lock in all files in folders and subfolders

Use the check-for-modifications dialog, show all files (including not
modified ones).
Select all files, right-click, choose “properties”. Then remove the
svn:needs-lock property.

Share This:

August 20, 2018 | In: Správa linuxu, Video-Audio

mp3 gain

Increase the volume of an mp3 on linux

Share This:

August 18, 2018 | In: Správa linuxu, Video-Audio

mp3 cut

How to cut mp3 on linux?


Share This:

August 18, 2018 | In: Programovanie

pocet riadkov kodu

Ak chceme pocet riadkov v kode

find . -name '*.php' | xargs wc -l

Share This:

Transpiling code means converting the code in one language to code in another similar language. (sass -> css, TS ->JS)

import syntax isn’t much different from the require syntax, but import has extra flexibility for more advanced cases

setup js workflow:


arrow functions: let x = num => x * 2;


Building an Ionic Geolocation Tracker with Google Map and Track Drawing—Google-Maps-API

Ionic Local Notifications (Schedule, Payload and Callback) [v3]

Share This:

source from:

Share This:

SCSS crash course; aka – collection of existing sources used as a reminder for myself, and perhaps some random dude…

Share This:

Why you should reconsider your decision – support

Let me give you one example… let’s say you need to submit your homework or need to access your class, etc. Now imagine that the website and the whole university portal is down twice a week (which is not uncommon), so what you do? You contact technical support. They will probably answer within 24h (like this is helpful if your deadline is in next few hours). You explain your problem, and this is what you get:

1. Clear your browsers’ cache and cookies (after clearing your cache, please close all browser windows and start a new browser session)
2. Close the browser, then re-open it.
3. Try an alternate browser (Internet Explorer, Firefox, or Chrome).
4. Reboot the computer/laptop.
5. Try a different computer/laptop.

So you take a deep breath, you try to explain you did all of that, and if you get some answer at all (which is not uncommon for them not to answer at all) you get something like this:

…it appears to be some kind of computer issue on your end causing this issue.

Thank you very much for nothing (as usual). You try to take another deep breath and explain that unless they won’t borrow you their PC, it is not going to solve your problem. After that, they usually stop answering for good.

You try to log the next day and suddenly everything works as expected… issue on my pc? Let me be clear here! I didn’t reboot my PC at this point, not even closed my browser…

Now you might be thinking; this guy is just moaning… yes, I tried contacting them, by phone, email, wrote an official complain, participated in their surveys… no change at all, same shit all the time…

This is only a tip of an iceberg and I’m going to post every shit they did and will do from no one until they will realize they can’t ignore customers paying 1.3k for one module and get away with this shit.

Kirk out

Share This: