Welcome to TechScreen

Welcome to the TechScreen site. This side shall support the exchange of knowledge in the domain of Web Engineering and related aspects. As a side effect, this side is used for research on knowledge management technologies. User can pose challenges in the problem domain and can participate in quizzes. Further a bibliography about arcticles in different related domains is continously extended. Finally, questionnaires on different issues are provided. To be able to participate you need an account and a password from TU Wien's TISS system.

Failed SQL queries

There was a need in updating a big data set stored in Oracle database. Currently existing solution for this purpose was implemented as myBatis script. It contained resetting timestamps in form - '01-JAN-1970' . Execution of this script was constantly failing on environments with Czech localization. This was caused by DBMS installation creating a timestamp in a form - '01-LED-1970' , so the month was not recognized.

File got corrupted on Fileserver, Permanent way to avoid this issue

In my network I have a Fileserver with 2x4 TB disc capacity. I run debian on it. The initial configuration was to put the two HDDs on Software RAID 1. This setup worked perfectly fine for about 3.5 years. It worked until I needed a large zip file containing a game. A friend was at my home and we wanted to play this game. I allready had the file on my computer, he copied it from the Server. When he wanted to unzip it, WinRar throw some errors. He did not have any write permissions, so it was not possible that he or I had modify the file by mistake.

File got corrupted on Fileserver, Permanent way to avoid this issue

In my network I have a Fileserver with 2x4 TB disc capacity. I run debian on it. The initial configuration was to put the two HDDs on Software RAID 1. This setup worked perfectly fine for about 3.5 years. It worked until I needed a large zip file containing a game. A friend was at my home and we wanted to play this game. I allready had the file on my computer, he copied it from the Server. When he wanted to unzip it, WinRar throw some errors. He did not have any write permissions, so it was not possible that he or I had modify the file by mistake.

Migrate from Spring MVC Restful Web Service to Spring Boot

Every single day technologies are changing and new frameworks are coming making developers lives easier. Migrating project framework is not easy and sometimes it does not depend just on the developers decision, but also teams decision or even maybe interdepartmental decisions. Spring MVC is a complete HTTP oriented MVC framework managed by the Spring Framework and based in Servlets. The most popular elements in it are classes annotated with @Controller, where you implement methods you can access using different HTTP requests.

Creating a lot of thumbnails

It happens often that on the homescreen there are many images representing the content of the subpages. The images can not be the same as the ones in the subpages, since the homepage would take too long to load, especially for users with poor internet connection. Therefore for every single image, a thumbnail must be created. When wanting to create a thumbnail, the easiest possiblity is to open the image in a graphics editor and change the size manually. Nevertheless, when creating tens or hundred of thumbnails, this is not a solution.

Sending printscreen images

If I want to describe how to do something on a website or just point out something interesting there, I am always using printscreen images. Sometimes one image can save a lot of words and it is more descriptive and understandable. However, when using the default prtsc function and some graphic editor, the process takes too long and the images are saved in my computer, even when after sending them, I do not need them anymore. This whole process can be very annoying when sending many screenshots everyday.

Cancelling query in mysql phpmyadmin

When running query in phpmyadmin, the user is not informed about the progress of the query. When dealing with tables with milions of items, even very simple select can take tens of minutes. After submitting the query, the process is running and it can not be killed. Even when I close the browser window or try to open phpmyadmin in a new window, the process is still on and I can not find a way to kill it.

What tools to use for expanding software company

A start-up is preparing to receive a new seed capital that will be invested in extending of human resources, especially the software development team. However, CTO thinks that we overlooked setting-up a good development process during our initial development phase and need to find a strategy to improve it. Currently we use only a simple SVN repository to maintain codebase where all programmers commit their changes and project manager assigns tasks to each programmer using an e-mail or in person, but no further attempts to improve the development processes were made so far.

Mac does not boot (startup drive is corrupted?)

macOS does not boot anymore and the hidden recovery partition is damaged. A separate disk with the mac operating system is not available but the internal drive must be checked and, if possible, the OS should be reinstalled.

Assure quality of a software product

We are developing an analytical software product where the accuracy of all our data that we generate needs to be assured. However we recently had an incident where we provided wrong data to one of our clients. After careful examination we found a regression that was introduced to our production stacks after a recent release. As a result we almost lost the client and it affected our reputation of a reliable data provider. How can we avoid such incidents in future and assure that the data we are publishing have a good quality?

Pages

Subscribe to TechScreen Revised RSS