Skip the EPSO Online Test

Posted by in EPSO, Tutorial

TL;DR:: Replace the end of the application URL from e.g. 1947_en to 1947/apply_en. These days, EPSO is in the habit of launching calls with multiple fields with a twist: each field has its own application page. So, if you just want to browse the fields for more details (e.g. Talent Screener in specialist competitions), you’d have to go through the test each time. Quite time consuming… The URL for a field is:

where [field_id] is the identifier of the call and [lang] is the language. E.g. for Enterprise Resource…read more

Electron App
Use SCSS, Luke!

Posted by in Project Management, Software

Traditionally, I’ve been a LESS supporter. The way it does mixins for example seems to me more intuitive. However, I noticed that my go-to framework (bootstrap) is now doing SASS-first and then LESS. So, one adapts… and the option in angular-cli makes things less painful. What was painful was to convert a bunch of LESS code to SCSS :/ Here are some findings relative to using SCSS in my application: Webpack does it nicely via the sass-loader You can use relative, absolute and ~ paths to refer to other resources….read more

Electron and WebPack – Live Reloads

Posted by in Software, Tutorial

I wanted to create a skeleton with Electron, Angular 2, capable of live reload while in development. I’ve settled on the following framework: Electron (d’oh!) Angular 2 Angular CLI (because it makes it easy to generate boilerplate code) SASS (SCSS in fact) Webpack 2 and Babel After a lot of trial and error (and also scouring the internet for solutions), I think I reached a nice-ish solution. Following articles outline the steps and functionalities I implemented. Why angular-cli Is it alive? Use SCSS, Luke! Adding Webpack Electron-ize Babel-ize Empower VS…read more

Electron App
Is It Alive?

Posted by in Software, Tutorial

TL;DR: Yes, but it’s limping badly. Now that I’ve created the angular app, I wanted to find out if I could develop an Electron app without actually adding the Electron dependency yet. My naive findings are: You can develop any ui-related bit I could not implement actual business logic. This is due to the fat that browsers don’t have access to some things like fs. If you want to add more functionality (e.g. debug vs release options), you need webpack.

Electron App
. Why angular-cli?

Posted by in Software, Tutorial

The decision has been made for me since I’m new to Angular in general and the CLI offers a package deal particularly where code generation and initial package management is concerned. There’s also the boon of webpack, which is used as engine. Although the balance tilts heavily in favour of using angular-cli, this package also has a bunch of flaws, apparent to me also because of the end target: No multiple webpack configs. Angular CLI only has an optimised configuration and doesn’t expose hooks to be able to alter it…read more

Debug Electron in VS Code

Posted by in Software

TL;DR: You need to follow the server (electron) client (VS code debugger) approach. Be aware of OS specifics! So far, my approach towards development/debugging would be to write some code, test it, rewrite, test… all with a bunch of console.log() statements. That’s not efficient at all and since VS code has debugging capabilities, I’ve decided to find out how. First, when you enter the debug mode, you’re presented with a default configuration containing of two parts: A launch part – designed to launch your application An attach part – designed…read more

Rise and Fall of WebPack Dev Server in My Project

Posted by in Software

Disclaimer: This is a log of my journey developing an electron app. I’m working at a small electron app and I was experimenting with webpack-dev-server, so I can try to do live reloads. First, I’ve started the app as a web app (no electron dependencies whatsoever). At this stage, running:

off npm run would allow me to load and reload every time I did a change. Perfect solution I thought and I started to add electron via a simple app. The idea was to load the scripts off a…read more

Change Packages Paths in NodeJS

Posted by in Software, Tutorial

TL;DR: Edit %appdata%\npm\etc\npmrc and add prefix and cache entries to specify the locations where node puts packages. Every time I install a new framework/dev environment I have to look where they put files. Having a roaming profile is a pain and I need to make sure it doesn’t get too crowded. Otherwise, logging in takes 30+ minutes. The latest victim is NodeJS. This installs a lot of files for all packages in 2 directories (I found so far): Cache – a cache of installed modules Global – a place where…read more

Select Rows Where Value from One Column Matches Other Column

Posted by in Software, Tutorial

TL;DR: Use a JOIN. I’ve got a table representing a tree, using two columns:

and I want to select all children for parents whose CLASS_ID have a certain value (e.g. abcd). The way I could do it was via a JOIN statement:

This will: Perform a join where child.parent_prop_id = parent.prop_id Filter only parent.class_id = ‘abcd’ Simple. Bonus This will work with other databases as well :) HTH,