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.

Advertisements

Leave a comment

Filed under Tech

New Entry on Gaming

It has been a consideration about writing another theme related to game. While primarily done Android smartphone, sometimes the pleasure is also carried out on PC. The games are casual and mostly free, such as Guild Wars 2 (Free Edition, of course), The Division (Basic without any expansion pack), and Skyforge. On smartphone, there are Alto’s Adventure and Cookie Run: OvenBreak. This leisure activity is neither on daily basis nor routine, only when the time is available, such as today. When people read new category, Game, what would they think? Is it about gaming peripherals such as exotic mouse with high DPI, or maxed out visual effect on certain AAA title? Or, is it a review on gaming hardware such as brand new GPU with its supposed to be powerful feature? The idea, which has been considered, was that of writing something casual, such as what game is in play and what interesting scenes are there.

Thus, new category is born.

Leave a comment

Filed under Game

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.

Leave a comment

Filed under Tech

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.

Leave a comment

Filed under Tech

If We Could Disappear

If we could be faceless,  if we could disappear for a while, where would we go?

If we are not meant to stay, where would we continue our wander?

Leave a comment

Filed under Music

Disavowed

You will provide support for now-unpredictable person. You will, in time of need, provide necessary logistics, bird view, and protection. Your already short time will only be limited. Get to it.


I thought we had a deal in which I had to stop everything in my doing to take care the unpredictable, just like you had decided, which required me to focus all my resources as support.

No. It has never happened. Such thing has not ever been asked from your disposal.

I see.

Leave a comment

Filed under Melodica

Equilibrium

I would say that for every quality you desire from something, there is a price to pay. The trick is that keen observation is required to get optimal combination between price you can afford and quality you can compromise. That somehow requires experience which some people have not.

Leave a comment

Filed under Melodica