15 of the most common tradeoffs in System Design

1. 𝐒𝐜𝐚𝐥𝐚𝐛𝐢𝐥𝐢𝐭𝐲 𝐯𝐬. 𝐏𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞: Grow the system to handle more work vs. execute tasks faster. 2. 𝐕𝐞𝐫𝐭𝐢𝐜𝐚𝐥 𝐯𝐬. 𝐇𝐨𝐫𝐢𝐳𝐨𝐧𝐭𝐚𝐥 𝐒𝐜𝐚𝐥𝐢𝐧𝐠: Scale up with more powerful hardware vs. scale out by adding more servers. 3. 𝐋𝐚𝐭𝐞𝐧𝐜𝐲 𝐯𝐬. 𝐓𝐡𝐫𝐨𝐮𝐠𝐡𝐩𝐮𝐭: Prioritize fast responses…

18 Laravel Collection Methods with Example

18 Laravel Collection Methods with Example In this laravel collection methods tutorial, we will discuss about laravel collection methods and it’s uses with simple and easy example. We will illustrate some of the important and useful laravel collection methods. You…

Laravel Repository-Service Pattern

Laravel Repository-Service Pattern Normal Laravel application is based upon MVC (Model-View-Controller) design pattern, which derives that all the database relation are established in Model layer and Controller handles all responses from client and server and give output as per defined logic. As Software Development Industry grows…

Oracle Query tutorial for procidural and package

$sql_assinged =”select t.wo_id, user_info_class.func_wo_sub(t.wo_id) as wo_subject, –func_group_member(t.group_id) as members, nvl(user_info_class.user_info(t.action_by_id, ‘NAME’), func_group_member(t.group_id)) as waiting, to_date(t.action_date, ‘dd/mm/yy hh12:mi:ss’) as executedDate, w.value as dateOfExecution from user_path t,tblwo w where t.wo_id = w.wo_id and t.status in (‘executed’, ‘verified’) and upper(w.field) like ‘%DATE%EXECUTION%’ and…

Laravel Eloquent ORM relation with pivot table

Table sample user id – integer name – string user-role user_id – integer role_id – integer role id – integer title – string   class User extends Model { /** * The roles that belong to the user. */ public…

Complex queries using Eloquent Query in Laravel

Using Eloquent Queries are easy and helpful  but what will you do when you need to do  a complex query like “select fields from table  where (a=1 OR b=1)AND (c=1 OR d=1);” You can make use of the parameter grouping…

PHP Job Requirements 2019

Position: Senior Software Engineer(PHP) Salary Range: 100k-120k What You’ll Work On: Cutting edge technology SaaS solution hosted on AWS that enables today’s and tomorrow’s Gig economy. Frontend built with React and Redux. Backend built on PHP, MySQL and increasingly NodeJS…

Install Multiple PHP Version with Apache on Ubuntu 18.04 (Part -2)

To Install mysql follow below tutorial INSTALLING NGINX, PHP, MYSQL (LEMP) STACK ON UBUNTU 18.04 – PART -2    Install Phpmyadmin(for database) sudo apt-get install phpmyadmin Manually Installing phpMyAdmin (Ubuntu 18.04) Posted on Jan 17, 2019 in Tutorials Sometimes installing phpMyAdmin…

Install Multiple PHP Version with Apache on Ubuntu 18.04 (Part -1)

Apache Installation Install Apache web server from the official repository. Launch terminal on your system or login with ssh for remote systems. Execute the following commands to install the latest available version of Apache web server. sudo apt update sudo…

More About EPEL and REMI Repository on CentOS/RedHat 7/6

EPEL is known as “Extra Packages for Enterprise Linux” repository having lots of extra packages which is not added in official repositories. REMI is a third party repository provides latest version of packages which is already included in official repositories…

CentOS 7 Change php version from one to another

Well, after this problem I’ve stuck in a few days, then today I found the question. First thing remove php71 from system, yum remove php-common php-cli mod-php enable remi-php70 yum-config-manager –enable remi-php70 after that disabled the 7.1 yum-config-manager –disable remi-php71…

Install Apache, PHP and MySQL (LAMP) on CentOS 7

Prerequsitis The two most popular rpm repositories REMI and EPEL have most of the updated packages. They are also providing the latest packages for LAMP setup. Enable both repositories on your system using the following commands on your CentOS 7…

Fix wordpress nginx permalink 404 error

Fix wordpress details page 404 page not found error on nginx server Change below code try_files $uri $uri/ =404; to try_files $uri $uri/ /wp-default/index.php?$args;   Here is the below working code location /wp-default {   # root /usr/share/;   root…

Installing Nginx, PHP, MySQL (LEMP) Stack on Ubuntu 18.04 – Part -1 (Extended)

Configure nginx Virtual Hosting and the PHP ProcessorPermalink In this guide, the domain example.com is used as an example site. Substitute your own FQDN or IP in the configuration steps that follow. Nginx uses server directives to specify name-based virtual hosts. Nginx calls these server…