Posts...

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…

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…

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…

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…

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…

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…

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…

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…

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…

TL;DR : If you have BLOB s, you need to use UNION ALL . If you use UNION ALL , you need to partition off a criterion and select the first row. The other day I had to figure out how UNION works in Oracle, because we're retrofitting an application with extra features. Assuming I have 2 tables…