2023

Why an IPv6 only VPS is not for me

In the world of Virtual Private Servers (VPS), there are affordable options that operate exclusively on the IPv6 protocol. This is because IPv4 addresses are becoming scarcer and more expensive. However, there are a couple of reasons why an IPv6-only VPS might not align with your preferences:

  1. IPv6 Connection Requirement for SSH Access:
    • One of the primary drawbacks of opting for an IPv6-only VPS is the necessity for an IPv6 connection to access and manage the server via SSH (Secure Shell). Unlike traditional IPv4 VPS, IPv6-only VPS requires a compatible IPv6 network infrastructure. This can be a significant hurdle for those who primarily use IPv4 connections.
  2. Docker Limitations with IPv6:
    • If you rely on Docker for your work and projects, it’s important to note that most Docker image repositories today, including Github, do not fully support IPv6 at this time. This means you may encounter challenges when trying to pull container images from repositories if you opt for an IPv6-only VPS.

In summary, while IPv6-only VPS options can be cost-effective and are in line with the trend of IPv6 adoption, they might not align with your personal preferences, especially if you prefer working with IPv4 connections and rely on Docker for your projects. It’s worth considering VPS options that support IPv4 or have dual-stack capabilities to better match your preferences and requirements

The Perfect YouTube Video Length: 10 Minutes

In the vast landscape of online content, YouTube stands as an undeniable giant. With over 2 billion logged-in monthly users, the platform offers an extensive array of videos covering everything from educational content to entertainment, vlogs to music. As creators strive to capture their audience’s attention and maximize watch time, the question of video length becomes pivotal. Is there an ideal duration that strikes the balance between engagement and viewer retention?

I would argue that Youtube videos should only be 8 to 12 minutes long,  and that the 10-minute mark might just be the sweet spot. Beyond that, I’d rather just click Next.

OneDrive is an intrusive piece of app

Leo Notemboom explains how the OneDrive can be so invasive on your computer’s document files if you’re not too careful.

I might have enabled OneDrive backup by accident in the past. I just hope I didn’t lose files by accident as well because of Microsoft’s and OneDrive’s stupidity ineptitude.

Power Query function to count number of months between two dates

Power Query has a built-in Duration.Days function. But what about Duration.Months?

Why don’t we create a custom function for that?

(Date1 as date , Date2 as date) =>
let
    Source =
        List.Generate(
            () => [x = 1, y = Date.AddMonths(Date1,x)],
            each [y] <= Date2,
            each [x = [x] + 1, y = Date.AddMonths(Date1,x)],
            each [y]
        ),
    Months = List.Count(Source)
in
    Months

Note: Date1 should be earlier than Date2.

BDO PERA Annual Contribution Limit Increase

Following the directive of the BSP, I received an email today from BDO stating that the limit for my annual contribution to my PERA account with them has increased from P100,000 to P200,000.

This is timely — with the elevated inflation rates in the past year or so, we’d better have enough come retirement age. Plus, this is an opportunity to average down faster with our PERA account subscriptions being down in the past 3 years.

Rich Dad Poor Dad – from overrated to trash

After reading the book (or rather, listening to the audiobook) of Rich Dad Poor Dad by Robert Kiyosaki, I thought it was overrated. After listening to the If Books Could Kill podcast episode about it, I realized it was a total piece of trash.

From promoting illegal investment and business activities, to selling MLM or Ponzi scheme products, people should already stop quoting passages from this book. Forget about assets and liabilities, or shaping people’s mindset about it, other than those taught in accounting classes.

Listen to Michael Hobbes & Peter Shamshiri as they break down the faults in this book:

Airtable Script to Convert Numbers into Words (Automation)

When you’re filling out bank forms, the bank documents usually require their customers spell out the amount they put in into words. This is one way for banks to make sure customers really meant the number they put in their forms, and not made a typo. This poses a problem when you’re using Airtable’s Page Designer to auto-populate the bank forms from your Airtable records. Yes, you can type it out in a separate text field, but there must be a way to automate this, right?

Let’s say, you have a field called “Amount Sold” in your base. Go to Automations, and in one of your actions, select Run Script. Add an Input Variable and name it amount_sold , then for the Value select the “Amount Sold” field from your base.

Input Variable in Airtable
Input Variable in Airtable

Now paste the following in the Code area: …

Docker app for generating PDF from Airtable Records

There are several ways to generate a PDF from Airtable records using Docker. One approach is to use a library or framework that can generate PDFs, such as wkhtmltopdf or PrinceXML, and run it within a Docker container.

Here is an example of how you might use wkhtmltopdf to generate a PDF from Airtable records:

  1. Create a new Docker image based on the official wkhtmltopdf image.
  2. In your Dockerfile, install any additional dependencies you need to access the Airtable API and retrieve records.
  3. Write a script that retrieves the records you want to include in the PDF from Airtable, and converts them to an HTML template.
  4. Use wkhtmltopdf to convert the HTML template to a PDF.
  5. Start the Docker container and run the script to generate the PDF.

You can store the pdf in the container and store it or a way to extract it outside of it, with the help of some specific command.

Another approach is to use a pre-built service such as Airtable2pdf that can be integrated with your Airtable bases and generate pdf’s of it.

Note that the above is a basic example and the actual implementation would depend on your specific requirements and use-case.

The above quote was taken directly from the answer of ChatGPT about my query which is the title of this article. Unfortunately, I don’t know how to build a docker image from source, so I didn’t really get the help I needed. Good luck to me and you who are looking for solutions like this.

Scroll to Top