Setting Up Cloudflare Tunnel: A Modern Alternative to Ngrok

Setting Up Cloudflare Tunnel: A Modern Alternative to Ngrok

Learn how to securely expose your local services using Cloudflare Tunnel

Quick and Free Way to Share Your Local Docker Service with Clients

Ever been in that situation where you’ve built something cool in Docker and want to quickly show it to your client? Yeah, me too. Recently, I was wrapping up a database admin panel project and needed a way to let my client review it before the final deployment.

My go-to solution used to be Ngrok. It works, but the free tier gives you random URLs that look like 8f4d-192-158-1-38.ngrok.io. Not very professional when sending to clients, right? Plus, these URLs change every time you restart the tunnel.

Streamline Your Web Content Extraction with Readability

Streamline Your Web Content Extraction with Readability

A powerful tool for automated web content extraction and analysis

I’d like to share Readability , a tool I’ve developed and refined over time. Its primary focus has always been straightforward: find the most prominent image on any webpage while keeping the overhead minimal.

Core Focus: Image Detection

The main strength of Readability lies in its image detection capabilities. While many similar tools try to do everything, I focused on solving one specific problem really well: finding the most prominent image on a page through dimensional analysis. The approach is simple yet effective:

How to Configure S3 Access for AWS App Runner A Complete IAM and VPC Setup Guide

Introduction

When deploying applications on AWS App Runner, you may need to access S3 buckets to store or retrieve data. However, by default, App Runner services don’t have permission to interact with S3. This guide aims to solve that problem by walking you through the process of granting your App Runner service secure access to S3 buckets.

We’ll achieve this by:

  1. Creating an IAM role with the necessary S3 permissions
  2. Configuring your App Runner service to use this role
  3. Setting up networking components (if using a VPC) to ensure connectivity

By following these steps, you’ll enable your App Runner service to securely read from and write to S3 buckets, allowing for seamless integration of S3 storage in your application.

How to trim data in column with sql

To trim newline characters from a text field in SQL database, you can use the trim() function along with the replace() function. Here’s how you can do it:

UPDATE your_table
SET your_column = trim(replace(replace(your_column, char(10), ''), char(13), ''))

This SQL statement does the following:

replace(your_column, char(10), '') removes line feeds (LF, \n)

replace(..., char(13), '') removes carriage returns (CR, \r)

trim(...) removes any leading or trailing whitespace

This approach handles both Unix-style (LF) and Windows-style (CR+LF) line endings.