Recently I came across a need to create a Linux shell script to run a PostgreSQL SQL query, export it in CSV Format and send it attached to an email. The following is a self-explanatory Linux shell script outlining the process.
The following short article explains how to use Netsh command line scripting utility to add or delete inbound and outbound Windows firewall rules. [Read more…]
The following short example shows a simple example of how to query Google Natural Language API by posting JSON as text using cURL in PHP. [Read more…]
Recently I came across a situation where I needed to perform the MySQL search in such way, that it would account for typos in user search queries. For example, if the database of words in MySQL contained only the word “assistance” and the user typed the misspelled word “asistence”, I had to be able to return the correct word “assistance” as a closest possible suggestion from the database. It seemed like a trivial task at first, but it took me quite a while to figure the SQL query that had a good balance between performance and overal quality of results. [Read more…]
The technology is dramatically amending our workplaces. In this post, I touch on ethical dilemmas associated with electronic surveillance of employees. [Read more…]
Recently I got asked about my views on Amazon AWS and their 100% redundant cloud computing SLA. Here is a couple of notes I took on the subject… [Read more…]
I examine a hypothetical scenario of a growing medium size company that is planning to migrate to a cloud environment. I suggest an Amazon AWS cloud service as a possible solution and also cover deployment models as well as some very high-level implementation details and benefits of cloud PaaS services. [Read more…]
The following short post contemplates some of the often asked questions connected with referencing and discusses the importance of referencing in general.
In this article, I offer a couple of thoughts on what I believe to be the three most significant aspects of the successful research. I talk briefly about the definition of research first, then concentrate on describing the main characteristics and their importance. [Read more…]
The following article is a short visual on how to move remote desktop on Windows 10 from the default port 3389 to any other available port.
With the recent fast adoption of Internet and cloud environments, the focus of software development shifted from building single user type applications, into a realm of constructing software capable of handling numerous local or remote users. The core benefit of multi-user applications lies in their capacity to tolerate synchronized access from simultaneous users. Other advantages often include the ability to support different types of desktop and mobile devices using a variety of operating systems. [Read more…]
I am not using NetBeans myself but had to work with it on one of the projects. Here is a short guide on how to clone Github project into NetBeans.
The following post outlines the process of converting Aspell language dictionary for any language into Mysql or MariaDB database. [Read more…]
The Java recognizes the limited nature of abstract classes and interfaces and their inability to become an object or a traditional class. Nevertheless, it is the absence of the qualities above and the ability to use abstract classes in various objects that proves to be incredibly useful to developers. In this article, I briefly outline the possible application of abstract classes and interfaces as well as provide examples to highlight the contrast between them.
In this article, I illustrate the process of writing a simple Java program. [Read more…]