Now

What I am currently upto.

September 2024

September 21, 2024

September 14, 2024

I am currently arguing with jdbc client. I have an array of strings that I want to insert into my db as one big string seperated by commas.

idea: ['str1','str2'] -> "str1,str2"

To achieve this, I wrote:

String strs = String.join(",", list);

Should be simple enough. Java returns the list as a string as expected, but jdbc insists on entering it into my db as a String[].

UPDATE: Lucky for me using a list wasn't necessary, so I was able to change the data type in my DTO class from

List list;

String[] arr;

and it plays nice with jdbc array data type. Who would've guessed?

August 2024

August 31, 2024

I have a few different websites where I upload my photographs. Some of the images I upload are only 1mb, but I know these files can be smaller with comparible quality and resolution. I decided to start exploring compression algorithms, specifically for image compression. To start, I looked at bicubic interpolation, the slowest algorithm, but one that can yield a pretty high quality image. To compress the images, I wrote a python CLI which takes the path of an image or the path of a directory of images, opens the image file using cv2, reduces the file by a factor of x dependent on the resolution and then scales the image back up using bicubic interpolation. The CLI also gives the user an option to do a simple reduction, which uses a function available in the PIL(Python Image Library). Why Python? I chose to write it in python so that I could write it fast. I don't have a lot of experience in C or C++ and I didn't want to write it in Java. I am not a professional Python Programmer, so I don't always care about writing things in a pythonic way. I wrote this CLI and the algorithm in python because I just wanted to focus on the bicubic interpolation algorithm itself. You can check out the repo on my github. I plan to follow this up with a proper blog post eventually.

August 24, 2024

Began development on 'Simple Payroll', a web app built with Springboot to manage several business tasks for my client. I decided I wanted to do a bit of consulting on the side to supplement my income and diversify my skills. I figured it was a good way to get paid to learn new skills all while delivering software that somebody will actually use. The client wanted some software to handle many accounting related tasks. Yes, there are many products out there that already do this and more, but my client wanted something custom and something he could keep forever. No monthly subscription fees. I built an MVP, demo'd the prototype, and the client was on board immediately. Now, for the next 9 months, I will work on this app for my client, and I will get paid monthly.