#Database - Blog Tag

May 26, 2020

2 min read

SSH Tunneling: Access network restricted services from local machine

Like I always to run my database server on the loopback device or on the private network. But sometimes I feel a strong urge to have access to the staging database from the local machine, be it for...

# System Administration # Server # Database

January 07, 2016

2 min read

Ruby

How to change table for Rails models on the fly

Maybe you need your multi tenant application database to partition horizontally (shard). Probably you want to store different customers data in different tables.

# Database # Rails

June 17, 2014

2 min read

Tips & Tricks

Basic Database Design tips for Relational Database

A poorly designed database can make your life hell as a dev while optimizing an app. On the other hand, A good design can speedup your development process along with the performance of the app.

# Database