Author: Rob Giseburt
Rob Giseburt
02 Jun, 2021

Why you should use GraphQL

GraphQL was created in 2012 and open-sourced by Facebook in 2015 to relieve issues with the interfaces of the time, particularly for mobile devices with limited or flaky internet connections. Now managed by a foundation, GraphQL continues to provide an interface that allows making a single call that aggregates...
Rob Giseburt
25 May, 2021

Managing Complex Data with JSON in PostgreSQL, Part 3

In the first post of this series, we explained why you absolutely need to use jsonb columns in the PostgreSQL tables right now, and mildly chided you if you aren’t already. In the second post of this series, we demonstrated how to use triggers and constraints to make one...
Rob Giseburt
18 May, 2021

Managing Complex Data with JSON in PostgreSQL, part 2

In Part 1 we explained why you absolutely need JSONb columns in your PostgreSQL tables, and how they simplify the expression of complex data, including complex references and relationships. In this article, we’ll dive deeper into ways to use tables with JSONb columns, discussing constraints and triggers to guarantee...
Rob Giseburt
11 May, 2021

Managing Complex Data with JSON in PostgreSQL, Part 1

Are you looking at your stale, flat relational database and thinking: “It’s so rigid and lifeless!” Do you need polymorphism? Do you have a NoSQL database that has no obvious shape and is causing you lack-of-relationship nightmares? With JSON in PostgreSQL, you can have your cake and relationships too!...
Rob Giseburt
04 May, 2021

TypeScript to Make JavaScript Development Better and Faster

On a recent project involving AWS Lambda and AWS CDK, I made the decision to write the Lambdas in TypeScript to match the CDK code and found that it accelerated my progress noticeably. Later I realized that the back-end development team in that company had no TypeScript experience. I...
Rob Giseburt
25 Jun, 2020

Designing and Building a Ventilator Flow Sensor from Home, Pt. 3

This is part three of the Designing an Intelligent IoT Ventilator from Home series There’s a Flow Sensor Shortage In working on the Pressurizer proto-ventilator, one thing quickly became clear: There are two minimal metrics that need to be known at all times: pressure and volumetric flow. Pressure we...
Rob Giseburt
24 Apr, 2020

Designing an Intelligent IoT Ventilator from Home, Pt 2

In the previous post I described the motivation for and some background of our ventilator project. In this post I’ll dive a little deeper with some juicy details. To reiterate and expand somewhat on the previous post: Because this project started in response to a lack of available ventilators for the COVID-19 pandemic...
Rob Giseburt
22 Apr, 2020

Designing an Intelligent IoT Ventilator From Home, Pt. 1

This is part one of a series. In this post we talk about what we’ve done and why, and in the next post we talk about how in detail. In this time of Covid-19 I was looking for a way to help. Because of our g2core project I have an unusual...
Rob Giseburt
25 Jul, 2019

Use Python without Installing Python – the Docker Approach

While writing the Industrial IoT series, I came up with this trick that may be of use to you as well. Installing python can be a daunting task. If you are reading this from a web search, then you likely already know this. I will quickly cover how first...
Rob Giseburt
23 Jul, 2019

Part 2: Industrial IoT CI/CD – An update killed my coffeemaker

This post in the Enterprise IoT series is about applying CI/CD and Serverless techniques to IoT.