Published in RockedScience·May 9Building Smart Home IoT Devices with the Google Cloud PlatformPart #1 — How to connect your first device to IoT Core — Everything is getting connected. Even people who don’t really want to own connected devices are likely to have a few in their homes, because smart metering is popular and it’s hard to buy a TV that is not “smart” nowadays. Alexa is natively fitted in a number of cars and the…Google Cloud Platform12 min read
Published in RockedScience·May 6Host Private Node.JS Packages on the Google Cloud with Artifact RegistryHow to safely share and reuse your code across multiple projects — Every programmer who follows the basic principles of coding ends up with a lot of reusable code. To make the most out of it and streamline maintenance, such code needs to be distributed through a centralized source. Every programmer also uses dependency packages on a daily basis. So it’s easy to…Google Cloud Platform7 min read
Published in RockedScience·Apr 8Tracking And Analyzing Device Connections in Google Cloud IoT CoreRespond to connection events and make the data actionable — As I developed my first IoT project on the Google Cloud Platform I quickly realized that I could not find any reliable indicator of MQTT connection status of devices in Google Cloud IoT Core. The get REST Resource from the Cloud IoT Core API returns a lastHeartbeatTime timestamp from which I…Google Cloud Platform10 min read
Apr 8Importing Big Data in BigQuery with Data Transfer Service and TerraformAn uncharted path to a powerful ingestion tool for Big Data — If you deal in Big Data, Cloud migrations, application modernization and system integration projects, chances are that you need move and import huge amounts of data across different systems. The BigQuery Data Transfer Service (DTS) offered by the Google Cloud Platform facilitates the ingestion of big data from a number…Google Cloud Platform11 min read
Published in RockedScience·Apr 7Programmatically Create a Scheduled Query in BigQuery with TerraformHow to fix “Error 400: Failed to find a valid credential” and “Service Account does not exist” for Scheduled Queries — The Google Cloud Platform loves Terraform. So do I. …Terraform6 min read
Published in RockedScience·Mar 15How to use Backfill: the Time Machine for Scheduled Queries in BigQueryHow to retroactively run Big Data analytics jobs in BigQuery — I love BigQuery and I used it in a number of Big Data projects. I like its flexibility, the powerful query language (including the possibility to query external sources) and the many built-in functionalities. I am also fond of the Data Transfer Service, because it makes it so easy (and…Google Cloud Platform7 min read
Published in RockedScience·Mar 5How to Fully Automate the Deployment of Google Cloud Platform Projects with TerraformA workaround to a known Google Cloud API catch-22 issue — The folks at Google Cloud Platform seem to love Terraform. They embraced it so much to advertise it in their own documentation, providing tutorials, courses, reference modules, validation and import tools. Also, I haven’t heard a lot about their native Cloud Deployment Manager lately. …Google Cloud Platform5 min read
Published in RockedScience·Jan 26Building Sustainable Software and IoT ProductsMake Software an Asset and your Life easier as a Developer — Every seasoned developer has been there: the production system crashing during the holidays. The late-night calls. The turnover without handover. The legacy code that nobody dares to update because it’s not documented. The new privacy laws wreaking havoc on long-standing workloads. Writing good software is a huge investment and building…Software Engineering15 min read
Published in RockedScience·Jan 13Dockerizing Grav And Other PHP ApplicationsA Primer On Modern PHP In Containers — I haven’t touched PHP in a long while. Since I started focusing on IoT, Cloud architectures and Infrastructure-as-Code (kudos, HashiCorp!) some 7 years ago I dedicated my time and efforts to other languages and tools. …PHP7 min read
Published in RockedScience·Jan 13Firebase Function Update Failing?A Quick Fix — Recently I stumbled upon a curious issue with a Firebase Function. I wanted to validate a concept before spending time to write actual code, so I quickly drafted a Function to test drive the functionalities I wanted to implement and then let it rest for a long time, while I…Firebase2 min read
