Posted on April 15, 2015
Sometimes we need to construct a query inside a stored procedure. Lets say we have fields like day1, day2, day3…, and we need to fetch day1, for some other case we need to fetch for day2 and so on. Why write different procedures just write a single SP construct the query by passing the day number and […]
Posted on January 13, 2015
Recently I had a requirement where I needed to update stored procedure on the server to reflect my local changes and we had a huge number of stored procedure, so I was trying to list stored procedures which have been modified after a specific date. In this tip I am going to share that SQL query […]
When you are working on a laravel project there is some basic setup that needs to be done for each install of the project. Like Permissions for ...
In this blog, we are going to take a look into Laravel Queues. Queues allow you to defer the processing of a time-consuming task, such as sending a...
PARTIALS Let’s say we have a structure like the following : data = { students : [{ name : ‘ABC’, roll : 1 }, { name : ‘DEF&...
PHP 8 has been officially released in November 2020! This new major update brings many optimizations and powerful features to the language. This...
ProxySQL is a high-performance SQL proxy. ProxySQL runs as a daemon watched by a monitoring process. The process monitors the daemon and restarts i...
Time is important. We should not waste it doing trivial things. Automate things wherever possible.