The Missing Bit

Blog posts

Keeping an ordered collection in PostgreSQL
2016-08-10

I’m hitting an issue I’m quite sure a thousand developers encountered before me: how to keep an ordered collection in an SQL database.

Keeping an ordered collection seems trivial at first, but can soon become quite complicated.

Lets summarize: what we have is a table A, referencing a table B via a foreign key, and we want to keep the B rows belonging to A sorted.

Read more »

 

Introducing backy, PostgreSQL background jobs for elixir
2016-08-09

 

Safari performance problem with absolute positioning
2016-08-08

While working on a React project, I noticed abyssal performances on Safari only.

It took me some time to figure out, but the culprit was the use of absolute positioning.

Read more »

 

File upload on android for JavaScript app
2016-08-04

Disclaimer: I had to implement this solution because of some imperatives (coder life…), but this is not good programming practice. Hopefully Android 5 will let us do it properly.

I have a web application that shares the code on desktop, iOS and Android.

Everything works fine, except that Android does not support <input type="file"> in WebView out of the box. While iOS will happily show an image picker if the accept attributes is set to image types, Android’s WebView will just do nothing.

Read more »