View Post

Economical mumbo-jumbo

In English by xpil0 Comments

Whilst browsing the Internet I recently ran into an interesting (and probably totally unreallistic) idea: universities should be free from charge for all students. Their (i.e. universities’) income should be funded exclusively off a tax charged unconditionally from all alumni for the first years after they graduate. This would – in theory – lead to situation where „better” schools would …

View Post

Next prime date

In English by xpil0 Comments

Dates in Ireland are usually written as DD MMM YYYY i.e. 5 Sep 2016 or 12 Jan 2000 and so on. However, from database perspective (which is my personal favourite) I like storing date values as integers of YYYYMMDD i.e. 20160905 or 20000112 etc.

View Post

0, 1, 8, 144 (EN)

In English, Jestem, więc myślę by xpil0 Comments

While surfing the Internet I recently found an interesting (although completely incomprehensible) proof of a conjecture stating that 0, 1, 8 and 144 are the only perfect squares in the famous Fibonacci sequence. For greenhorns: Fibonacci sequence starts with 0 followed by 1, then each subsequent terms is a sum of two preceding terms: 0, 1, 1, 2, 3, 5, …

View Post

Dates clusterfuck: MSSQL vs Excel

In Branżowe, English by xpil0 Comments

Dates are usually the most error-prone element of various computer systems. There are so many different date formats, standards and representations. On top of this there are different calendars, too. Overall one could probably get a PhD on the topic without even scratching the surface of it.

View Post

How to create an empty file in Windows cmd shell

In Branżowe, English by xpil0 Comments

I faced an interesting[citation needed] task recently. For each file sent over via the ftp channel I was supposed to generate an empty *.OK file and send it over immediately after the main file transfer was completed. This allows the receiving party to process the file on their side with minimum delays. Let’s say we are sending 5GB of csv …

View Post

Xenial Xerxus and WordPress – upgrading your VPS

In English, Techniczne by xpil0 Comments

It is very important to keep your software updated. Forget to upgrade your apache to the latest version and you’re screwed. Forget to install recent security patches and you’re pwned. And so on. So, when I logged on to my VPS this morning and saw a big message saying that „…blahblahblah new version of Ubuntu is now available, please upgrade …

View Post

UTF != UTF

In Branżowe, English by xpil0 Comments

I have recently faced a very annoying issue with one of the ETL processes. Very annoying issues are often easily resolvable in simple ways[citation needed] and thankfully this was one of them. However, before I managed to solve it, I wasted a whole bunch of otherwise perfectly usable minutes which is something I always loathe. By writing this entry I …

View Post

WordPress: conditional widgets

In Branżowe, English by xpil8 Comments

Have you ever pondered over how to make a WordPress widget (in)visible only on certain pages, or categories, or just on the home page etc? If you haven’t then don’t. It is pretty much boring. However, if you are losing your sleep over widgets conditionality (is this even a word?), you will be able to restore your inner peace very …

View Post

Sh*t happens

In English by xpil0 Comments

  As Confucius used to say, shit happens. He was a smart lad so there is no point not to believe him. Shit that happens to happen is usually a bad shit. More or less. Ocasionally you discover that some of the bad shit happens only to unravel a surprisingly good shit later on which is exactly my case, right …