Sunamo Blog

I am a bit sorry that I took such a long break from blogging, but from now on new posts should appear here a little more regularly. It will not be like the old days when there was something new almost every day, but there should definitely be something new at least a few times …

Can’t tear yourself away from programming even when you’re away from your PC? Do you have a phone/tablet running Android, ideally with a hardware keyboard? I meet these 2, or rather 3 conditions, so I installed the app AIDE (Android IDE) on my Sony Ericsson Xperia Mini Pro, and it made my dream come true …

Why in a double misfortune? Because I bought 2 identical phones and over time each of them developed some problem. They were Sony Ericsson Xperia Mini Pro phones, and each one came from official Czech distribution. However, given the state those phones were in, they wouldn’t have honored the warranty anyway, so I just paid …

When I was travelling to Karvina yesterday, a rather unusual train was standing at the station. It was hauled by an “Iron” locomotive of the Slovak Railway Company (hereinafter SZS) Cargo and had only one passenger coach and no freight wagons. What made it unusual was that I had never seen before a “passenger train” …

Sometime at the end of May I bought my new phone for the first time, a Sony Ericsson Xperia Mini Pro (SK17i), but it never made it to June – by an unfortunate accident it got run over by a bus (I write more about it at 👻 The server was taken down, the owner …

After quite a while, I’m back on the blog with another post. This time I managed to implement a simple but complete pager. All you need to pass to it are the IDs and how many items per page you want. Originally I had a pager that could only be used once. That was because …

While debugging the Ggdag website, I ran into an interesting problem. The thing is, I use transactions there, and I was also using methods from the class MSStoredProceduresI. When I tried to get the number of rows in a table, it threw this error: “ExecuteNonQuery requires the command to have a transaction when the connection …

It was my second ROM installation in the last 2 days on the same phone. At first I had this ROM: https://xdaforums.com/showthread.php?t=1899288 but I would not recommend it to anyone. At the moment, its latest update is from September 30 and today is November 10, so that is more than a month. That would not …

It took me an awfully long time to program (even though it is only a few lines of code), but it is finally here! The page is divided into 3 “Steps”: Step 1 The upper part shows the tables that already exist in the DB. This means that if you want to add new tables, …

Testing methodology: 2 databases were created, each with a single table containing only an int column and an NVarChar(20) column. The first one always received NULL values in the NVarChar column, while the second database received empty strings. Once again, my goal here is to save as much space as possible. And the result? The …