Author: abhijit

ExtJs – Monthfield Picker

October 23, 2021 / abhijit

ExtJs, by default, doesn’t provide a month picker.

A monthfield picker allows you to choose specific months only.

The customization that was required, was to have a start date and an end date for those months, so that at the end of the operation, those specific dates could be saved.

The problem with the world is that the intelligent people are full of doubts, while the stupid ones are full of confidence.
Charles Bukowski

setup Tiddlywiki with NodeJs server

October 18, 2021 / abhijit

I’ve always been fascinated by TiddlyWiki, which is considered a personal wiki and non-linear notebook (Wikipedia).

The main reason that was holding me back from using it was that every time I make changes, I would need to save it explicitly or use some browser extension.

I then discovered a very nice Tiddlywiki server on NodeJs (link).

I also wanted this to be password protected and this server provides simple and easy ways to do all that.

Install and run Metabase

October 18, 2021 / abhijit

Metabase is a data analyzer and visualizer tool which can connect to many types of databases.

It can do some smart analysis as well as let you write proper SQL queries to create charts and graphs.

Metabase is a Java application which can be run directly. Conversely, it can also be run via Docker.

Compile fossil on Ubuntu Linux

September 25, 2021 / abhijit

Recently, I had to build fossil from source on Ubuntu because I needed to make a change to the source code.

It required a number of dependencies which is expected to be installed.

They are –
gcc (obviously!)
zlib1g and zlib1g-dev
tcl-dev
tk
libssl
libssl-dev

error while running rake task – “Don’t know how to build task”

September 5, 2021 / abhijit

The default method to pass arguments to Rake tasks is to give the parameters in square brackets –

desc 'Method #1: Use the default rake way to add two numbers and log the result'
task :add, [:num1, :num] do |t, args|
  puts args[:num1].to_i + args[:num].to_i
end

Reference: 4 ways to pass arguments to a Rake task

$ rake add[1,2]
# => 3

However, I would rather pass the arguments like this –

$ rake add 1 2
# => 3

Setup up READ_ONLY users on Postgres

August 28, 2021 / abhijit

To grant access to users for only viewing a database (i.e. no INESRTs or CREATE or UPDATE access) there are certain conditions.

First, access should be only allowed through ssh.

Second, the ssh user should not be able to get into a shell directly.

And finally, the database should restrict access to that particular user with relevant permissions.

We all strive for safety, prosperity, comfort, long life, and dullness.
Aldo Leopold

PM2 – the best process manager

June 22, 2021 / abhijit

In the past, on my server I’ve installed Fossil, Syncthing, Bitwarden, Inlets. All these require some form of Process Management. These programs / processes / services need to be always running, so they are restarted in case they get terminated. Also, on a system restart these need to start up automatically.

I’ve mostly used Systemd or Supervisor to all these things.

However, I recently came across PM2 and I was really blown out of my mind as to how simple it was to set it up.

Upgrading Wallabag from 2.3 to 2.4

June 20, 2021 / abhijit

I had upgraded PHP from 7.2 to 7.3 on my server and suddenly Wallabag stopped working!

I got some weird error like –

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted

I guessed it had something to do with the PHP upgrade. So, I decided to upgrade Wallabag as well.

That’s when the problems started!