Tag: Google Cloud Platform

  • A Historic perspective of how SaaS has simplified software delivery

    A Historic perspective of how SaaS has simplified software delivery

    If you have read my previous article, 23360 days old and counting, you know that I have been around the software industry for a while. In my early days, I worked for Philips Telecommunication, a global IT company in the 1980s that delivered a turnkey solution from hardware, operating system to client software for their…

  • Data Project: Splitting addresses with Google Cloud Dataprep

    Data Project: Splitting addresses with Google Cloud Dataprep

    This article is part of the article I wrote about how I became an environmental data collector, and the issue I run into during the project and how I finally resolved them. After I collected the data with the wearable, portable indoor-outdoor air quality monitor Atmotube PRO.

  • Types of Cloud Deployment Models and How They Benefit Businesses

    Types of Cloud Deployment Models and How They Benefit Businesses

    The fast development of the internet brought new ways in which businesses are conducted. What was unimaginable only a few years ago, today is the norm. Businesses around the globe have seen new opportunities and decided to grab them. One such opportunity is cloud computing. 

  • Should You Move Your Business To The Cloud?

    Should You Move Your Business To The Cloud?

    In the realm of technology, the cloud is a ubiquitous presence, yet it often mystifies individuals who are not well-versed in its intricacies. It’s perfectly understandable if you find yourself pondering what the cloud truly represents. Contrary to common misconceptions, the cloud is not a singular monolithic entity. Instead, it comprises a multitude of distinct…

  • Maritime noon report with Google Cloud Dataprep

    Maritime noon report with Google Cloud Dataprep

    I recently worked on an exciting project, the use case for the project was to make the maritime noon report data available in Google BigQuery, which sounds simple enough. However, there were a lot of requirements, from collecting application data from the Greenpeace fleet in different formats leveraging Cloud Functions and API calls, landing the…

  • Securing HTTP trigger in Google Cloud Functions

    Securing HTTP trigger in Google Cloud Functions

    In this how-to article, I’m going to show how you can secure your Google Cloud Platform (GCP) Functions HTTP trigger, it has not been that straightforward to secure HTTP trigger in Cloud Functions in the past HTTP triggers in GCP were publicly available. While this might be useful in a lot of scenarios, it’s also…

  • BigQuery federated queries against WordPress Cloud SQL Database

    BigQuery federated queries against WordPress Cloud SQL Database

    BigQuery has added a new feature, in which you can connect to a Cloud SQL instance and make federated queries. In this how-to, I will explain how I made an external connection from BigQuery, then using federated queries to query my cloud SQL WordPress database and made a Top Story report in Google Data Studio.

  • Migrate your WordPress local MySQL to Cloud SQL

    Migrate your WordPress local MySQL to Cloud SQL

    Regardless of where you hosting your WordPress site, you can use Cloud SQL to be your backend database. In this How-to, I will explain the steps I took to migrate from the WordPress local MySQL to Cloud SQL.

  • Using Secret Manager in a Google Cloud Function with Python

    Using Secret Manager in a Google Cloud Function with Python

    When you write a cloud function, you need to protect an API key, account information user id and password, or other sensitive data. In the Google Cloud Platform (GCP) you can use the Secret Manager a secure and convenient storage system that provides a central place and single source of truth to manage access, and…

  • Fun Tech Projects to spend time on

    Fun Tech Projects to spend time on

    With our current situation with the Covid-19 virus affecting our lives, I can not spend so much time outside cycling as I normally do, as there are restrictions on how where to go. I do have other hobbies, one of them is doing programming and testing out new things with my Raspberry Pies, it gives…