Blog Archives

Ecto Composable Queries

For a while, I wondered how it was possible to prepare a query in Ecto that involves a join, then pass that query on and add a condition based on that join. The above example will look for the name

Posted in Ecto, Elixir

The great Vision Quest of 2016

Occasionally one starts to feel stagnant in a world of ever-faster-evolving technologies. More and more sites seem to be adopting transpiled Javascript frameworks, and thus it’s time to start hitting some education. I’ve chosen React, as that’s what seems to

Posted in Uncategorized

Ecto and tricky joined tables

Elixir’s Ecto framework has a lot of quirks. For the first time, I wanted to try to sort on a table that I joined up to another table using a LEFT JOIN. Furthermore, these fields are in a JS Datatable,

Posted in Uncategorized

Ecto EXISTS clauses with stuff in ’em

I have always loved the EXISTS() clause in PostgreSQL. It’s a super-convenient way of finding records that have associated records in another table without actually joining that table into your main query. Great for when you’re only interested as to

Posted in Uncategorized Tagged with: ,

Selenium Grid Status as JSON

Oy, modern developers want things packaged so nicely for them. I’ve become one of them over the last few years. Which is why I was surprised to see that Selenium Grid, which has a bunch of other API calls, doesn’t

Posted in Uncategorized

Go on, Emp.ex!

Had a great time attending the first ever Empire City Elixir Conference today. It’s really awesome to see how excited people are about a new language – the momentum is palpable and I truly believe this is where most heavy

Posted in Uncategorized Tagged with:

Easy-peasy major PostgreSQL version upgrade for Mac

The thought of doing a major version upgrade in PostgreSQL (in this case, 9.4.5_2 to 9.5.3), always gives me the heebie-jeebies. It could be that a couple years ago, when we finally got our 9.1 database at my startup out

Posted in Uncategorized

Interacting with ReactJS forms as an outsider

Recently I was attempting to automate data entry on a site that was powered by ReactJS. We’re definitely in a new world of tools that the kids are using these days – you can’t just plug data into an input

Posted in Javascript, ReactJS

Controlling Amazon EC2 instances with Elixir

Had a need to start, stop, create, and terminate EC2 instances from my Elixir-based Phoenix Framework app. While there isn’t yet a solid EC2 management library for Elixir, there’s a full-on solid one for Erlang called Erlcloud which does just

Posted in Elixir, Phoenix

Phoenix Framework – Setting an associated ID back to nil using a form

When using a Phoenix Framework form, I had a select box on my page which had an option to set a belongs_to value to nil. The form would usually send the ID, but when the nil value is selected, it

Posted in Ecto, Elixir, Phoenix