Posts
All the articles I've posted.
Understanding Ajax’s async Option
This article investigates why an Ajax request returns data while the calling function returns undefined. It explains the order of callback assignment and function return in an asynchronous request, using a MiniUI example to illustrate the async setting.
Substring Searches over Large Datasets
A suggestion to use MySQL’s LOCATE function.
Handling Blank Rows When Importing Excel with Apache POI
This article explains how deleting an entire Excel row differs from clearing its contents when importing with Apache POI. It describes checking rows, cells, and cell types to exclude empty rows and prevent empty data from being written to the database.
Oracle Window Functions
A detailed introduction to Oracle window functions.