Powershell – Extract Files from ZIP Archive

Starting with PowerShell 5, cmdlets like Expand-Archive can extract the content of ZIP files to disk. However, you can always extract only the entire archive. Luckily, there are other methods to extract, not only, from .zip archives, specified files or folders, on Windows-based systems. Read More …

Python – What is a Dataframe?

A dataframe is a two-dimensional data structure, i.e., data is aligned in a tabular fashion in rows and columns, exactly as you would see in a classic Excel spreadsheet. In other terms, Pandas DataFrame is nothing but an in-memory representation of an Excel sheet via Python programming language.
Read More …

Javascript / jQuery – Validation of file size while uploading

The following is a demonstration of client-side validation and is implemented to provide a nice user experience. In some cases, client-side validation is a much better method in comparison to the server-side method as it consumes less time. Read More …

Check mySQL and MariaDB Server Version

There are circumstances where you need to know the version of your database server, e.g., when upgrading the database or patching any known server vulnerabilities. There are a few ways to find out what the version of your MariaDB server is. Read More …