Every time I need to create, modify, grant sudo access to users in Linux, I have to search for it.
This is a list of the commands I’ve used in the past.
Will keep updating this so that I don’t have to load a search page every time!
All commands below are run as root user. If I’m not the root user, I need to prefix them with sudo!
Reference: Stackoverflow
pg_hba.conf controls the authentication method. If you want to request a password, use md5 authentication. If you want to allow login with no password to anyone, use trust. If you want to require the same username in the operating system as in PostgreSQL, use peer (UNIX, only for local connections) or sspi (Windows).
If there’s a password set, but pg_hba.conf doesn’t tell PostgreSQL to ask for it, the password is ignored.
If pg_hba.conf tells PostgreSQL to ask for a password but there’s none set, then all login attempts will fail no matter what password is supplied.
A database replica is able to provide another layer of protection in case of the main database server going down.
Postgres has this capability out of the box.
In this case the requirement was to create a replica on a separate server. (It’s also possible to create it on the same server where Postgres is running).
The replica maintains an exact copy of the main database (called Primary) on a real-time basis.
Continue readingAlthough this is not recommended, there might be scenarios where there are no other options.
An example is an analysis software which doesn’t give the capability to connect via SSH. I came across this scenario when someone wanted to use QLik. Although this has a lot of capabilities, but when something like this is required, I’d rather use the open source and free Metabase.
Continue reading
Sequel is a fantastic ORM available in Ruby.
It also comes with an IRB console so it can be run directly from the command line with various options.
For example, to console into an SQLite database testdb.sqlite in the current directory –
$> sequel sqlite://testdb.sqlite
Or for Postgres –
$> sequel postgres://dbuser:dbpassword@localhost/testdb
However, I use sequel most frequently to take quick database backups or to restore them.
ExtJs does have a attribute for required by the allowBlank configuration against fields.
However, this configuration doesn’t have a setAllowBlank or a getAllowBlank method, because of which, it is not possible to bind those fields via the viewModel. So, usually, those fields have to be somehow fetched in the Controller and then that attribute.
This situation can however be remedied very easily.
Continue readingExtJs, 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.
Continue readingThe problem with the world is that the intelligent people are full of doubts, while the stupid ones are full of confidence.
Charles Bukowski
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.
Continue reading
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.
Continue readingCopyright © 2026 the möbius trip
Theme by Anders Noren — Up ↑