Author Archives: Hiren Kubavat

About Hiren Kubavat

PHP Developer

What is Agile methodology? Examples, when to use it, advantages and disadvantages

Agile software development methodology is an process for developing software (like other software development methodologies – Waterfall model, V-Model, Iterative model etc.) However, Agile methodology differs significantly from other methodologies. In English, Agile means ‘ability to move quickly and easily’ and responding swiftly to change – this is … Continue reading

Posted in PHP | Tagged , | Leave a comment

How to get table size in MB oracle ?

select segment_name,segment_type,bytes/1024/1024 MB from dba_segments where segment_type=’TABLE’ and lower(segment_name)=’your_table_name’;

Posted in oracle | Tagged | Leave a comment

SQL Optimization Techniques

Optimize access structures: Database design and normalization. Tables: heap or index-organized tables, and table or indexed clusters. Indexes. Constraints. Materialized views. Partitioning schemes. Statistics, including a comprehensive refresh strategy. Rewrite SQL statements: Exclude projections that are not required. Minimize the … Continue reading

Posted in MysQl | Tagged , , , | Leave a comment

How to identify user idle state by minutes using javascript / JQuery?

Descrption: i used with 20 minute of interval if user is in idle state from last 20 minute then it will call the timerIncrement() and then will check for 20 minutes if yes or not. Why i need this? i … Continue reading

Posted in angular-4, Javascript, jQuery | Tagged , , , , | Leave a comment

what is difference between oracle & mysql ?

Key difference: The Oracle Database is an object-relational database management system (ORDBMS). MySQL is an open source relational database management system (RDBMS). MySQL is the world’s most used RDBMS, and runs as a server providing multi-user access to a number … Continue reading

Posted in database, MysQl, oracle | Tagged , , , | Leave a comment

Rest api cakephp -3 pagination

For web we are using Paginate component & for view we used the paginator helper, what is the standard way to enable pagination i am using following technology. Cakephp-3 php MVC framework as Back-end Tech Angular-js 4 as fronted Cakephp … Continue reading

Posted in API, cakephp-3 | Tagged , | Leave a comment

How do I install Sublime Text 2/3?

Install via the Package Manager(apt-get): Simply add to your packages: For Sublime-Text-2: sudo add-apt-repository ppa:webupd8team/sublime-text-2 sudo apt-get update sudo apt-get install sublime-text For Sublime-Text-3: sudo add-apt-repository ppa:webupd8team/sublime-text-3 sudo apt-get update sudo apt-get install sublime-text-installer Run Sublime-Text on terminal subl

Posted in Ubuntu | Leave a comment