Software

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.

As some of you noted, I moved my blog into Hugo . You have to pull multiple git repositories to compile the entire project during the build process. Because begging is always challenging, it’s always trial and error, and I ended up having many sub-repositories missing. I’m now going to show the whole journey how to solve “the issue”.

Dealing with DNS changes can be annoying and frustrating. Changes are not visible straight away, you have to wait to see them. Thet are not even. Here you can find links to clear cached records in popular public DNS servers:

Flushing DNS cache

• Flush Google Public DNS Cache
• Purge Cloudflare Public DNS Cache

Checking results

You can check results here:

• IntoDNS
• Refresh OpenDNS Cache

DNSSEC Tools

• DNSViz. A DNS Visualization Tool
• DNS Check
• DNSSEC Analyzer
• SIDN DNSSEC Test

I built a simple worker to do some magic with images by using Go & VIPS . I chose VIPS because it is blazing fast compared to other Go image processing libraries. So this is the story about what went wrong.

Because my DEV setup is Apple MacBook Pro with M1 Apple Silicon, it’s always tricky to compile something to the proper architecture. Installing VIPS on my machine, it’s pretty straightforward:

brew install vips

When you start looking for a solution, you will find answers like using Cloudfront, lambda, and middleware 3rd party services. And basically, you don’t have any other choice. There is no simple solution to your problem. But – as long as you use Caddy Server solution is super easy.