Skip to content

Posts...

Page 23 of 47

Use XPath in PL/PGSQL for Batch Processing

March 5, 2016Categories: Software, Tutorial
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…

Change Decimal Comma to Dot in Excel Mac

March 3, 2016Categories: IT, Tutorial
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…

Definitive Tutorial to CM13 on LG G2 D802

February 24, 2016Categories: Hardware, IT, Tutorial
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…

Clean Factory Reset for LG G2 (802)

February 22, 2016Categories: Hardware, IT
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…

GoogleApiClient .connect() Interface or Class

February 14, 2016Category: Software
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…

Fix Gradle Error: UNEXPECTED TOP-LEVEL EXCEPTION

February 10, 2016Category: Software
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…

Migrate PostgreSQL Between Two Machines

February 5, 2016Categories: IT, Tutorial
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…

Hide Apps in Nova Launcher Drawer

January 28, 2016Categories: IT, Tutorial
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…

Add Wear Notifications to Android App

January 24, 2016Category: Software
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…

LibGDX drawPixel has Wrong Colours

January 17, 2016Category: Software
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…
PreviousNext

All tags