When I received an email, I wanted to upload the email attachment to Slack and tried to use Microsoft (Office365) Flow to perform that task. Microsoft (Office365) Flow has a Slack connector, so I thought it would be easy to create one, Unf…

I wanted to create and manage users for local use in the project and set up an LDAP server. Since this was my first time touching LDAP, I wrote down a rough explanation of LDAP, its usage, and the procedure for installing LDAP on Ubuntu 18…

For example, "In a user's event log, I want to extract the last event the user performed." Sometimes you want to retrieve the last record of data divided by groups. The window function can be used to obtain the following WITH tbl AS ( SELE…

When I usually work with Linux, I have multiple terminals up and running. I'm not particularly inconvenienced by that, but I was looking into the possibility of launching multiple shells in a single CUI terminal and switching between them …

I got into trouble when I tried to decrypt data encrypted with PHP's mcrypt using Node.js, so here is a note on the cause and solution. situation I received data that I was told was encrypted with AES256-CBC in PHP, but when I tried to dec…

It's not much, but I wrote about Slack in a rambling way. Slack or Microsoft Teams? We use Office365, so we have access to Microsoft Teams, but we use Slack as our chat tool. Teams also tried using the tool, but at a glance, it was difficu…

Since Spark is a Python program, it can be written quite freely. However, since I always have a general idea of what I need to do, and knowing various ways of writing Spark makes it harder to remember, I will summarize my personal frequent…

I have tried AWS Glue before and here are my thoughts on it. AWS Glue is made of Apache Spark, and it was interesting for me to touch Spark for the first time at that time, I was thinking that I would put together a usage guide for Glue wh…