Upgrade Path

Not so sure about choosing different talent path? If you are a gamer, you might have encounter this thing. The same thing goes to electronics, especially PC. There are at least two major platform to choose based on processor. Once you have chosen your desired platform according to your budget, necessity, and software compatibility, the you can browse around components from various manufactures.

After a moment you’ll realize that there are a lot. You start yourself with reviews, comparison, and budget. Tech advances so fast these days. One day you see an announcement of new processor, you’ll get another the next day. Your mind get confused of so many options. One day you decide to resort to one last bastion, which is Requirement.

Not everyone needs fancy machine but everyone needs a machine fit to their needs. From that point of view, you can decided which machine you want to build. After that, you remember the character you have made earlier in a particular game needs to be leveled up and you need to decide its proper talent. Things back to square one again, you say to yourself.



Project Update

Sometimes it fixes many problem, sometimes it fixes some and creates some, and if you are not lucky, it creates a whole new set of problem. Compatibility issue is the most likely problem to happen. That’s why people like to delay update and after too long you realize that your components are already far behind and doing update will probably generate only problem instead. Then you decide to run it anyway. If that’s the case, then please pray.

And since this is not your original work, you don’t know what components are there and what are their function. Now you’re looking at terminal and wonder if you really need all of those.

Ubuntu on Windows

It seemed weird at first but it works now. Please kindly refer to this article or this article. In short, you’ll need to enable Windows Subsystem for Linux feature, go to Store, pick your desired distribution from available choices, then install. After several minutes of downloading the application, you can run your Linux on Windows like normal application. It’s on terminal, though.

Ubuntu on Win10

It seems to cover basic terminal operation such as directory management, file archiving, archive extracting, and downloading something using wget. It also allows you to install things. I haven’t tried on something with GUI such as web browser or games, for that matter. At least I can try python for now. Go ahead and type your usual command.

$ apt-get install python

Ubuntu on Win10 2


Interdepartmental Secrecy

This would be mostly about rant. That’s it. My work with a particular client has been running since last year in developing a system to store and make simple analysis regarding all of their work, in short. Their substantial work, however, has ties with several bodies in the same level as theirs. These ties imply data connection between them and protocols with which data can be interchanged. From this point, they argue which data can be shared either publicly or internally.

The definition of secrecy, of confidentiality belongs to data-master, as I usually call it. The master has every right to declare which are confidential and which are not. In the latter case, the data might be in public domain for public review. The data-masters have their superior, their supervisor which has also every right to command them to release everything they have. At some point they, the data-masters simply agreed but later one person stood up and challenge the forum about possible consequences.

Personally attending the forum, I had to contribute one or two arguments, which were later considered as rude and sharp by my colleagues. Seeing that attendees seemed to be confused about which would be hidden in our system and which would be open for public, it was only fair to make a point or two for their misconceptions, in short sentence of course.

I beg your pardon for pointing this out again and again. From your requirement, you might let your data be visible on public domain. This aspect has been very clear for us from the beginning that public shall not see data on this level of detail. They are only to see, if necessary, the final data containing final result. The on-going data shall not be for them to see. For personal inquiry regarding their case and how far their case have been handled, they have been given credential unique to themselves to access such information. Therefore, I thought there is no need to expose our storeroom to all crowds.

A colleague of mine reprimanded¬† me for being rude again but at this point, I couldn’t be anymore careless. It’s their data, their integrity, their system. While being maintained by me (and my friends, we formed a formidable team here), I, as representation of my team, cannot let our work be only a toy instead of serious collaboration.

The conclusion was that we would develop a prototype which would have intentional data breach. Such prototype would allow public domain to see data, which were deemed confidential at first but later requested to be public. This prototype, however, would not be deployed on formal server but on one PC which belongs to a colleague, from which all access would only be permitted from localhost.

Following meeting should be held afterwards with regard of this experimental and intentional breach. Different stakeholders, I assume, will either fight against themselves head on while figuring out why these data should be hidden and why not by request of higher authorities, or they would willingly submit to these authorities.

postgis Extension

A friend of mine told me to use postgresql for spatial web development. I haven’t acquired any reference as to why this particular database should be chosen. Since he works in spatial analysis, I just follow his words. My work is mainly done on Windows platform since I have tendency to game while working. To work on spatial database, I need to install postgis extension on my database. There are several ways on how to do this. There are zip files you can extract to your postgresql folder or you can download binary file containing your extension or you can use tools which can find you the most suitable postgis. I chose the third and began my dependency towards StackBuilder.

I have gotten use to utilize StackBuilder tool provided by postgresql itself. If you download the postgresql installer, you might find StackBuilder under bin folder. From there, you just run it, choose your local sever, choose Spatial Extensions, and there you can find suitable postgis bundle.

StackBuilder is not a default tools though. If you download the postgresql installer provided by BigSQL, this tool isn’t available. You’ll need to download postgresql installer from EnterpriseDB to get StackBuilder tools. I haven’t familiarized myself with those from BigSQL. They might have something different. But for now, I prefer to use tools I’m familiar with.

Impression of pgAdmin

I happen to use pgAdmin tools quite often. It makes things easier for database management. But then I stumbled upon pgAdmin 4. It’s not as intuitive as pgAdmin III. It came to me first when I want to create new table. The steps begin with the same right-click, create table, and then the table is there. But I couldn’t create columns while in create table dialog. On the other hand, pgAdmin III allows me to do this particular task. The UI of pgAdmin 4 seems out of Windows-UI sense. Below is pgAdmin 3.

See how simple the UI is? A friend of mine told me that he rarely uses this tool because he uses migration command line provided for his working framework. He only uses pgAdmin as browsing tool. This tool comes with postgresql-9.5. I tried with version 10 and 9.6. Both of them uses pgAdmin 4. Compared to 9.6, 9.5 only comes with postgis 2.3 which is fine since I don’t know how the versions differ from each other and I haven’t experienced anything crucial related to these versions.¬†2.3 works just fine.

Now this is pgAdmin 4. It seems like web browser to me and it feels not natively Windows-UI. It also works slower than the previous version. While surely 10 and 9.6 provide several improvements compared to their predecessor, my deployment environment still use postgresql-9.3. I wonder if database created on 9.5 would work just fine on 9.3. By the way, this is a pgAdmin 4 UI.

Again, this is only impression of mine towards these two product. Those who prefer entering command line through Terminal or working in Linux/UNIX environment shouldn’t have this issue.

Back to the Olden Days

Does that sound right? Anyway, this would refer to using good old Windows XP again after a while. Current hardware generation is normally not supported by Windows XP. For example, first Core i3 processor wasn’t supported by this operating system directly. Some said that one had to tweak some of the included drivers but since there is a software called virtual machine, why not give it a try?

How cool is that seeing that legendary background once again?

Next thing to do was software for work. There are drivers, tools, editor, and security application that might be necessary. Those, however, might need some adjustment. Several software might not support Windows XP any longer which means one should browse around several archives to find compatible version. But that’s a story for another day.

Good Day.