Backup SQLite

The Writefreely instance running the current website is using SQLite database to store the content. SQLite is an embedded relational database which primarily ships as a library with bindings for a lot of programming languages. It also ships a helper command line utility sqlite3 which can be used to interact with database file. This tool can be used to take backup by calling .backup command.
$ cat !#/bin/sh sqlite3 /path/to/writefreely.db ".backup /backup/path/backup.db" $ This is equivalent to SQL dump which can be imported in a new instance if need arises. The backup process can be configured to run everyday using cron daemon. The cron expression for taking backup at midnight 12 is 0 0 * * *. The following line can be added to cronjob to automate the process. 0 0 * * * ~/ Cron expressions for different time/frequency can be easily generated using the web-based tool called
For offsite backups, the SQL dump can be copied to a remote machine usi…


This project is a very simple webapp inspired by Google's internal “go” system. First time I came to know about this was from this Gitlab thread. Also from the same thread I came to know about an open-source implementation of it at kellegous/go.

I have been working with Golang extensively at work and otherwise for the past year but this is my first web application in Go. The application is analogous to a URL shortner with the different that you get to choose the slug. It implements the functionality of adding and deleting as well as listing all links. I also semi-implemented authentication where it assumes an external system (middleware) to do it and set a specific HTTP header. I am using Cloudflare Access for implementing this in my current setup.

I used Mux router to build the endpoints with two middlewares for logging and authentication. For logging, I used a leveled logging library by Netflix engineer called zerolog. I used Go implementation of LevelDB which is an embedded …

Interpreter Book and Compiler Book

Someone at work shared the link of Interpreter Book. It looks interesting and I want to read it. The book is about writing an interpreter for Monkey language in Go and learning through the process. The author has also written the Compiler Book. The books are available as both eBook and physical copy.

Toxic Masculinity

Why do some men think of themselves as superior to the women? Why do some men try to overpower women at times? Is it really a cultural thing? Or is it limited to certain generations? Is it something hard-coded in our nature which we learn to fight back to fix ourselves? Or is it taught to us through various institutions?

I don't have answers to these questions but I want to acknowledge that these kinds of problems do exist in the real world. It often shows up from time to time in news and media in some extreme form. However, very subtle elements can be seen everywhere.
When I see signs like “This Taxi Respects Women”, I get a feeling that we are still not trying to find the root cause of the problem and are instead trying to treat the symptoms. Of Course everyone should respect women but why are we not doing that in the first place?
A nice write-up by Paul Graham where he talks about how “studying for grades” in school is damaging.
I bought a new domain tonight for the Writefreely instance. The instance is running at now.

Federated Git

Git in itself is distributed in nature. That's why it is called distributed version control. But what I really mean by federated Git is the Git hosting services. There are some popular hosted services like Github and then there are open source selfhosted alternatives like Gitea and Gogs. But for someone to switch to something like Gitea entirely is not an option (if they want to contribute in other projects) since there is no way of creating pull requests or follow projects across the services. For someone to create a pull request, they need to have an account on existing hosting service and create it from there. This feels limiting considering the distributed nature of underlying software, Git.

One solution to this can be Federated Git, similar to Fediverse. That means anyone can host an instance and submit there changes to any other totally different service as long as both of them implement same protocol. ActivityPub is one such protocol used for federation. I do not know the…