@cbaggini
Data Analyst @ Environment Agency
Nothing here yet.
Nothing here yet.
May 7, 2021 · 1 min read · Lately, I have been looking for automated tools to improve the quality and security of my apps. I have looked at two online apps for this, SonarCloud and LeftShift. They are both intuitive and easy to setup; they can also be connected to GitHub and G...
Join discussionMay 1, 2021 · 4 min read · In this post, I will explain how to create interactive HTML reports including widgets such as maps and interactive graphs using R. I assume that the reader is familiar with basic R. I will use two public APIs from the Environment Agency to download d...
Join discussionApr 23, 2021 · 2 min read · Lately, I have been learning how to use Node.js and Express to build APIs. There are no fixed standards to build APIs, but reading online I identified some common themes on how to build a functional and usable API. Some common themes were: Don’t retu...
Join discussionApr 15, 2021 · 2 min read · In this post, I am going to explain how you can use indexes to speed up SELECT queries on a PostgreSQL database. Most of what this post covers will apply to any type of SQL database, but the syntax may be specific to PostgreSQL. I spent the last mont...
Join discussion