Posts

4 Essential of relationships - Trust, Honesty, Loyalty, Forgiveness

This is something I experienced and observed in my life till that time. I strongly believe - Trust, Honesty, Loyalty and Forgiveness are essential 4 elements that strengthen the relationship. How? let me explain. Trust Trust is a very essential element of any relationship we build. A relationship can't go long without trust.  When you trust your partner or one you are in relation with, it makes you overlook or avoid the things that others used to say about them.  You never fall into distrust easily by listening to others. Honesty If you are honest with your partner or someone you are in a relationship with, you must always tell truth about whatever happens in the relationship. Even if something wrong happens un-intentionally and we speak upon truth honestly, most of the time front person forgives us for knowing the truth and our honesty about the relationship. Loyalty If you are loyal to your partner or someone you are in a relationship with, you must not do anything wron...

Parents - They Learnt to adopt their-self better than us

Our Parents in old age learn to adopt changes in life faster than us. Still, we thought they are rigid and old thoughts people. In modern times we are more intelligent to understand the situation and time changes. But actually, we are not. It's a kind of myth. Our old parents are more intelligent to understand the changes in life.  Most of the time I saw our parent silently accepts the change even if it doesn't suit them, because they have seen the world evolving, and new thing happenings more than we have seen in our life.  And they know either way they have to accept it (change) to keep going on with the world. On other hand, we found difficult to adopt a change most of the time and we keep ourselves to be the same as we are.

What is Papertrail? Uses and Advantages

Papertrail is basically a log management tool used for catching Heroku systems and build but not limited to. It has been useful because on Heroku we can check live logs and can't check logs for the previous requests except for logs for the deployment process. So below are some of the key features which paper trail providing us: Recording the system logs live and we can also look into the logs of the past (from n no. of days up to a year) based on the plan we choose. It allows searching past logs by date-time, string or regex. It also allows us to configure alerts (emails, Slack) for a specific type of request failure response like time-out, system error or even request taking time more than a particular limit. It allows us to set filters for logs to save or not to save. Some advantages we seek from Papertrail are: Heroku adon is available with one-click installation like other adon. Fast and easy search interface. Able to store long time period logs history (up to 1 year) Custom al...

How to Upgrade or Downgrade Heroku Postgres adon plan

Image
If you are using Heroku and Postgres adon in your project, by the time you may want to upgrade or downgrade Heroku Postgres adon plan based upon your project's database size decrease or increase with time. Although you can follow Heroku documentation for the purpose: Changing the Plan or Infrastructure of a Heroku Postgres Database But I wish to introduce you to another way to upgrade or downgrade the Heroku PostgreSQL Database adon plan. In this process we have 3 steps to follow: 1. Add additional Heroku Postgres adon with the desired plan (you want to switch) using the below command:      heroku addons:create heroku-postgresql:adon-plan --app your-appname Where `adon-plan` can be replaced with the desired plan from the plan list and `your-appname` with your application name. 2. Now copy your database from the old Postgres adon to the newly added Postgres adon.           heroku pg:copy HEROKU_POSTGRESQL_MAUVE_URL HEROKU_POSTGRESQL_PINK_URL ...

Differences between json and jsonb - JSON data type in PostgreSQL

You may have read differences between PostgreSQL datatypes JSON and JSONB. If not, let see the difference between both theoretically and practically. Although, both json and jsonb are types of PostgreSQL JSON datatypes and accepts almost same format as input values i.e. json. But still there are some difference which one must know to efficiently use or can choose from both json and jsonb.  The main different is how they actually store data; the json data type stores input value as it is but  jsonb stores value in a decomposed binary format which lead to difference in  efficiency .  Jsonb is slower as compare to json while saving the input values because of converting json values to binary format before saving. Jsonb fast in processing the data because no re-parsing needed as compare to json datatype which needs processing function to re-parsing on every execution. Few other differences between json and jsonb are: Jsonb supports indexing which is advantage over j...

Laravel Validation - Unique rule with multiple column and condition.

Today I am going to share, How we can use Laravel validation rule `unique`. If you have worked with laravel and familiar with laravel validation, you must know what does 'unique' rule checks. If not let me give here a brief about this. In simple words, It is similar to a unique key constraint applied to a column in the database table. 'Unique' rule check there is no similar value exists in the given database table column, to value matching with the provided input value. The general format of the rule is: unique:table //when input name is similar to column name OR unique:table,column OR unique:Model,attribute Examples: 'email' => 'unique:users' //here users is table name OR 'email' => 'unique:c,email_address' //can give custom column name. OR 'email' => 'unique:User,email'  //here User is a model class This is a very simple usage ...

Get Free SSL Certificate from Let’s Encrypt for your website - Linux, Apache, EC2, Heroku.

Image
To enable HTTPS on your website, you need a certificate from a Certificate Authority (CA). Let’s Encrypt is a nonprofit Certificate Authority providing Free SSL certificates to 225 million websites.  You can also get a (absolutely) free SSL certificate using Certbot. Certbot is open-source software tool recommended by Let's Encrypt to for automatically deploy SSL certificate. This certificate is as valid as a paid certificate. There are two ways to get and install certificate on your server. 1. When you have SSH access to your server. Then you have option to Generate and Deploy SSL certificate automatically by installing Certbot on your server. 2. When you are using a platform like Heroku (Paas) where you don't have SSH access to your server directly and can't install any package on it. In this case you can install Certbot at your local system (Linux) using below commands and use it only to generate certificate files. Later you can Deploy them manually. Install Certbot a...

LEAST() and GREATEST() - Postgres SQL Amazing But Rarely Known Functions .

PostgresSQL is very powerful and one of the world's most advanced open-source relational databases. It gives much more flexibility and customization on query level when you want to perform a complex operation or complex queries on the database. Postgresql provides multiple operators and functions which make even complex operations and complex queries pretty easy and simple. Similarly LEAST() and GREATEST() are functions that make your work very easy and simple. LEAST() and GREATEST() functions are very useful when you want to operate on different columns within the same row (a record) in a table. LEAST() and GREATEST() compare and find the minimum and maximum value respectively among given columns values in the same row. It's similar to finding a minimum or maximum value from an array of given values. Here are a few simple examples you can try: select LEAST(5, 3, 9, 2, 8, 1) and GREATEST(5, 3, 9, 2, 8, 1); //should give 1 and 9 respectively In-case of String or Varchar, it gi...

How to Apply SSL Certificate (non-self) on EC2 with Linux/Ubuntu having Apache Server.

Assuming you are well aware of What is an SSL certificate? Why we need it? here I am going to guide you for How you can apply an SSL certificate for your website hosted on Linux or Ubuntu Server using Apache 2 server. You can either purchase a new SSL certificate or can generate it for free on  sslforfree.com  which authorized by  Letsencrypt  the first non-profit CA. After Purchasing or getting your SSL certificate you have actually 2 SSL files, Certificate and Private Key. You can upload both SSL files (certificate.crt and private.key) on the server: Create a new folder in Directory `/home/user-name/.ssh`. Create or upload files certificate (.cert) file as certificate.crt and Private key (.key) as private.key in the folder created earlier. Now edit Virtual Host configuration for the website for which you want to apply the SSL certificate. sudo nano /etc/apache2/sites-enabled/{yourwebsitedomain.com}.conf Add the following code to website vhost config...

How to Block Inspect Element and Right Click on Your Website using Simple JavaScript

Assuming you are well aware of What is an SSL certificate? Why we need it? here I am going to guide you for How you can apply an SSL certificate for your website hosted on Linux or Ubuntu Server using Apache 2 server. You can either purchase a new SSL certificate or can generate it for free on  sslforfree.com  which authorized by  Letsencrypt  the first non-profit CA. After Purchasing or getting your SSL certificate you have actually 2 SSL files, Certificate and Private Key. You can upload both SSL files (certificate.crt and private.key) on the server: Create a new folder in Directory `/home/user-name/.ssh`. Create or upload files certificate (.cert) file as certificate.crt and Private key (.key) as private.key in the folder created earlier. Now edit Virtual Host configuration for the website for which you want to apply the SSL certificate. sudo nano /etc/apache2/sites-enabled/{yourwebsitedomain....