Script(s) - technology as-is

How to query SQLite database using Python

Simplest way to query SQLite database from Python This example demonstrates how to access SQLite using Python 3.6 on Linux

Simple steps to install Community Edition MySQL on Centos 7 / RHEL 7 7 simple steps to install MySQL on

What is SQL Custom Sorting ? In SQL queries mostly there will be a need to sort data either in

Weird multiplication Error What would you do when multiplying two positive numbers resulting in a negative result ? If its

SQlite Import from commandline Sqlite is an amazingly powerful cute little database, which comes in handy when processing standalone jobs.

Data Science and developers. In today’s data science mania, here is a quick view of how data is moved from

This post is to explain different options available to export Hive Table (ORC, Parquet or Text) to CSV File. Expected

To write better MySQL queries, its important to know the parsing order of Select statement. The order is as follows.

If you encounter “curl” error when installing any packages in “R”, follow these steps Install libcurl-devel $ sudo yum install

To get public IP (not local IP) of remote linux box, use the following command. $ wget -qO- http://ipecho.net/plain |

This is a common problem when you try to install .msi files on Windows Server. There is a simple way