<127.0.0.1 />
the tech canopy

In this digital garden, I (Dorell James) journals everything I do - from scratching my own itch, to coding and building stuff, to basically everything I care about. This is the best place to learn more about what I am up to recently.

Brought to you by Dorell James

Tech Events Aggregator Automated Service

I have successfully completed the Event Aggregation service, which currently fetches events from Facebook based on the accounts stored in the database. While serverless functions are familiar to me, Supabase's choice of Deno as their runtime provided a valuable learning opportunity.

The service operates on a 15-minute schedule, checking for new events and saving them to the database using the pg_cron and pg_net extensions. The cron job triggers a Supabase edge function to fetch events from Facebook, and for each account, it calls the edge function to retrieve and store the events in the database.

See the reference commit here

Tech Events Calendar

I finally had the time to work on this idea of mind, an aggregation of tech events in Cebu.

There's two parts of this project:

  1. Event Aggregation: This service automates the process of fetching the events from sources, eg: Facebook, Eventbrite, Meetup, etc. It then stores the events in a database and makes them available via an API.
  2. Web App: This is a simple web app to view the events. It allows you to filter the events by category, date, and location. It's public and will allow people to see the events in Cebu as well as organizers to authorize (in Facebook's case) their apps to sync their events to the site.

View repo here

HubSpot Integration

Today I added a HubSpot integration to the site. This will allow me to keep track of people who sign up for updates. As I start in this journey, I want to be able to keep track of all the people who are interested in what I'm doing.

The beginning

I created this site to start documenting my experiences about all the stuff I'm working on. Today, I'm still not so sure about whether this is a good thing or not but hey, I'm putting it out here anyways. As a monument to getting started, you'll find above the very first screenshot of this site. Stay tuned for more updates!