Update Yourself

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...

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...

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....

There is no specific field/domain (development, marketing, management, etc.) to become a leader and you don't need to wait for an opportunity for the same. Leadership can be observed in any field/domain in any small or big tasks. But there are few observations of a good leader. Observations on Leadership 1. No Single type of personality for leadership : The is not any particular type of person who is only able to lead. Anyone can become a good leader no matter what kind of personality you have. You do not need to look like or copy anyone great leader, just be yourself. 2. Three Fundamental Attributes :       -  Great leader thinks and communicate clearly : Simple and clear communication actually needs your thought process and time. Take some spare time, write down your thoughts then think about how to make them more simple and clear to communicate.       It always pays you back to communicate clearly.       -  Good Judge...

Cookie in Laravel You can use the cookie in Laravel using the Helper method ` cookie() ` or method available with Request/Response Object or `Cookie` facade. $request->cookie('name'); OR use Illuminate\Support\Facades\Cookie; Cookie::get('name'); To get more clarity on how to use the cookie in Laravel with an example to show cookie consent popup on your Laravel website and hide/remove it once you accept the policy. Cookie Policy Consent Popup in Laravel First, create and a Cookie Consent popup as notification to the footer section of your Laravel main blade template file.  <div class="cookies-block">         <h5>This website uses cookies</h5>         <p>We use cookies to improve your experience and deliver personalised content. By using this website, you agree to our <a href="javascript:void()">Cookie Policy</a>.</p>         ...

HTTP vs HTTPS HTTP (HyperText Transfer Protocol) is the most basic and known protocol (a standard set of rules) used to transfer data from a web server to a browser. It allows communication between different systems. HTTPS is HTTP with encryption i.e it uses encryption (TLS/SSL) to make HTTP requests more secure while transferring the data from a web server to a browser or vice-versa.  So there are benefits of using HTTPS for your website: 1. It makes your website more secure against data theft. 2. It also improves your SEO rank. So now let's learn how we can direct a website from HTTP to HTTPS. First, make sure you have generated and integrated SSL certificate for your website and the Rewrite module is enabled on your hosting server. so that your website can work on HTTPS without any trouble. After applying the SSL certificate our website can be accessed via HTTP or HTTPS. But per above after knowing the benefits of HTTPS we need redirect HTTP to HTTPS. ...

There are 2 ways to pass parameters to a dispatching job in Laravel. First is simply call dispatch() or dispatchNow() as per requirement on your Job class like calling a static method on a class: YourJob::dispatch(argument1, argument2, argument3); Second is simply pass arguments while creating an instance/object of Job class then pass the object to dispatch method(always available in the controller) like: $this->dispatchNow(new YourJob(argument1, argument2, argument3)); The arguments will be available in the constructor, can you assign them to class local variable properties and use anywhere in Job class. Let consider below example job: <?php namespace App\Jobs; use Illuminate\Bus\Queueable; use Illuminate\Queue\SerializesModels; use Illuminate\Queue\InteractsWithQueue; use Illuminate\Contracts\Queue\ShouldQueue; use Illuminate\Foundation\Bus\Dispatchable; class Testjob imple...

Assuming you know the basics of Database and know the definition of indexes used in DB, here are some important things about Database indexes about which every good developer must aware of: DB Indexing is used to read data faster, but it makes writing slower. Indexes use in-memory data structures. Indexes use B-Tree (Balanced Tree) data structure to store data and use Binary search for reading/searching. It always saves corresponding DB internal row-id (not table PK) with every indexed node in the B-tree It is not good to add an index to each column of a table. If you have applied index on certain column but in query use any function on an indexed column, the index will not help at all. You can create a combined index on multiple columns. Order matters as per query need. To understand the use of indexes or to know if the query is actually taking the benefit of your index on your column use Explain. Explain give you the execution plan of the query. Explain give you info abou...

When you are working on Ubuntu/Linux OS, some important command given below can help you in managing Users groups and directories. 1. Check user-groups, a user account belongs to: $ groups 2. Add new user-group $ sudo groupadd user-group-name 3. Add user-account to a user-group: $ sudo usermod -a -G examplegroup exampleusername OR $ usermod -a -G group1,group2,group3 exampleusername 4. Change user account’s primary group: $ usermod -g groupname username 5. To change ownership of a folder: $ sudo chown -R www-data:www-data /var/www/ OR $ sudo chown -R $USER:$USER /var/www/example.com/public_html $USER will take account of the current user logged in. 6. Check permissions to specific directory: $ ls -ld /directory/ 7. Link command (creating shortcut): $ sudo ln file1.txt file2.txt or we can also use ln to create symbolic links with the -s option $ sudo ln -s file1.txt file2.txt

Virtual Host is a well-known term in web development. Generally, the remote server where we keep your website code/files is called a hosting server. Similarly, when are working on local system with any installed server like Apache or Nginx, it acts as a host. So to access the website on our system with any a custom domain name like 'yourproject.com' instead of something like 'localhost/yourproject', which sometimes create a problem when accessing relative URLs to base URL of the project. So the best way to create virtual host your local system which we work as the remote website works with a domain name. To Create Virtual Hosts(vhost) for apache2 server in Linux/Ubuntu using terminal follow below steps: 1. Copy default site conf file with the name of the your-website name i.e. laravel-demo.com.conf $ sudo cp /etc/apache2/sites-available/000-default.conf /etc/apache2/sites-available/ laravel-demo .conf 2. Open new conf file into an editor with root permission: ...