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.

I need quick and easy way to restore some of my MySQL databases from sql files. I don’t want to install MySQL on my machine, so I decided to use Docker. I created a simple bash script that will do all the work for me.

Amazon S3 storage is a popular cloud storage service that provides scalable object storage for data backup, archive, and disaster recovery. One of the storage options available on Amazon S3 is Amazon Glacier, which provides a low-cost, long-term storage solution for data archiving and backup. However, retrieving data from Amazon Glacier can be time-consuming and expensive. In this tutorial, we’ll show you how to restore files from Glacier on Amazon S3 storage using a Bash script.

It’s clear what we are trying to achieve, so let’s consider the requirements. Firstly, we need a tool to render web pages since JavaScript is commonly used nowadays. Secondly, we require an API to communicate with the headless browser. Lastly, saving the result can be challenging as browsers are designed to interact with rendered results rather than directly with the source code.

Headless browser

So we are looking for a headless browser. We are going to use Chrome’s headless-shell because it’s easy to use, and it’s based on Chromium . The most significant advantage is docker image, which we can efficiently run on our local machine or anywhere in the cloud.

For a while I was looking for an easy we to test my lambda functions written in golang locally. We have awesome tools like LocalStack but this is not what I was looking for. I wanted to test my lambda function locally, without any dependencies. Something lighter without Docker . I will show you how to do that.