Posts...

A while ago I had to process XML loaded in a PostgreSQL database. The task was to extract references from a publication structure. Fortunately, PostgreSQL allows you to use XPath in plpgsql , but there are some things you need to be aware. First, you need to note all namespaces: Then, you can use…

TL;DR : There are two things you can do: Change in Language & Region -> Advanced... When converting a text to columns, you can specify the delimiter ( Step 3 of 3 -> Advanced... ) Regional settings The regional settings will affect all applications, not only Excel. Here you can specify the…

NOTE : You need to be able to reach download mode at least ( Power + Volume Up ). If you don't you need to go search somewhere else how to get to this point. Prerequisites You'll need the following: A Windows machine. Windows 8 is what I tried, but I think Win 10 will do as well. USB 2.0. I haven't…

TL;DR: If you can't enter recovery (but you can enter download mode) and you've installed Lollipop stock back from CM13, you need to erase everything ( CSE Flash on your LG Flash Tool ). The other day I've updated CM13 to a new nightly and it got stuck on boot loop. After searching on the…

TL;DR : If it's your code, check the version play services ( com.google.android.gms:play-services-\* ). If you're using a library, check if the library has a version using play services >= 8.1.0 . If not, you'll need to clone and upgrade it yourself. The other day I got an interesting error coming…

Today I got the lovely UNEXPECTED TOP-LEVEL EXCEPTION from the dexer in android. Looking on the net yielded several causes and resolutions. Note : I'm using Gradle 2.10, Android Studio 2.0.0-beta2 Caching Apparently, sometimes Gradle is shooting itself in the foot with the caching. The first thing…

TL;DR : Once you prepare the connection, pg_dump is your friend. Recently, we had to migrate a large-ish DB (1.5 TB) from a Windows installation to a Linux one in order to accommodate a series of third party extensions. We have split the process in three: Prepare the migration Migrate users Migrate…

TL;DR : Select Nova Settings -> App and widget drawers -> Hide apps (scroll down bit) -> select the apps you want to hide. I've noticed that my app drawer started to get cluttered with stuff I'm not really using (like the Audio FX stuff). since some of the things I can't remove (system apps…

TL;DR : Use android.support.v4.app notification mechanism. Steps are: Create a WearableExtender: Extend the notification mechanism: Trigger the notification: After reading various sources , I got my application to send notification to my watch using the code above. At the beginning, I thought the…

TL;DR: Note that Pixmap.drawPixel(x, y, colour) expects a RGBA8888 colour, even if the pixmap is not RGBA8888 . Today I wanted to create a background with a bunch of different pixels and I had a lot of problems, displaying different colours from what I had in my array. The process is simple…