Prakhar Shukla

Sign in

Latest — Sep 3, 2023

PostgreSQL Backups - COPY vs INSERT

I wrote some scripts to backup and restore the data of Postgres tables. And normally everything was fine initially with Inserts, but as the size of the table increases, the restore took much more longer than tolerable. For example, one local restore action of Home Assistant DB took approximately 4

More issues

Draw Things - Image to Image

One thing a lot of people asked me was to modify an existing image or enhance an existing image with Draw Things. And this one is also very easy to do. Instead of following instructions as per the previous post, we make a slight difference of importing the image first.

banIP - OpenWRT IP List Blocker

So I host a HoneyPot to test whether how many attacks I get per day and what security measures are able to block it. And I started with Snort3 in IDS mode which allowed to detect malicious activity. After I switched to IPS, I noticed that while miscellaneous attacks had

Understanding Proxmox Backup Server

I use a NAS currently as my storage for my Proxmox VE backups. And it has been really well as far as the use case goes. I've used it many times to revert the VMs and containers. However I was curious about what additional features can I gain from trying

Proxmox8 on ARM64

So Proxmox7 is widely supported on ARM64 using the now famous Pimox7 project. However recently Proxmox 8 and Debian Bookworm was released. And I wanted to explore if the same can be done for my ARM64 cluster based on 3 Raspberry Pis as well. And after some exploration, I found

Running SSH on Port 22 vs 2222

So I host a SSH server Honeypot on my public IP and I thought to myself - How big a difference is running the service on port 22 vs 2222. Is this single step a big enough hurdle to consider it better? And of course, like everything else in my

Windows on ARM64

Running Windows on ARM is not as straightforward, since Microsoft does not supply ISOs (understandably as well, since they want to limit the hardware scope at the moment). Instead we've to follow a bit of a different path. I am using M2 Max as my host with VMWare as my

Geekbench 6 Benchmark across Devices

I own multiple devices and recently I thought that since all of them are on the same CPU architecture arm64 it'll be great to compare the performance across tiers. I started from smallest device and moved on to bigger. I took care not to change my behavior for the benchmark

P2P Botnet PanChan

So in my usual pattern of being curious, I did some more analysis of old malware samples on IDA. First thing that I caught was that it contained a huge (30-25 MB) with a bit chunk of Go Code. This is a bit unusual as most of the malware that

Home Assistant for Home IoT

I generally prefer OSS / self-hosted solutions, but this one was pushed for a serious need. I've BSNL as my ISP, which works mostly fine, but having high latency while trying to turn on a bulb or an appliance is just annoying. Not to mention that "Sorry, I'm unable to do