Python3 with Oracle Database
Installation These instructions are for Mac OS: First install homebrew. Never use sudo for brew. Install Python3. The installation comes with pip3. Install cx_Oracle, the library that allows python3 to…
Python3 with MySQL database
If you don’t already have MySQL installed, install it with the following commands (mac only): Run the following commands to start or stop mysql. Start MySQL before proceeding: To see…
NoSQL Overview
NoSQL is not one technology. It refers to a wide variety of different database technologies that address scale and agility challenges of today’s applications. These problems include: agile development where…
Backing up MySQL databases using mysqldump
mysqldump command is used to backup up MySQL databases. mysqldump has the following format: where is the file to which the backup should be written. Backing up specific tables By…
How to list MySQL tables using PHP
The following code lists all tables in a MySQL database:
Quick introduction to MongoDB
MongoDB is document based NoSQL database. This means that: it has no schema it has no relations it is agile and scaleable stores information in nested documents of two-dimensional key/value…
Escaping string before inserting into MySQL
If a string contains a single quote, it will generate an error. mysqli->real_escape_string() escapes quotes for MySQL. See example:
Character sets, encoding, and collation in MySQL
Character: set of symbols and encodings Encoding: set of values assigned to characters Collation: set of rule for comparing a character set Suppose you have the following characters, that are…
Listing all tables and their table counts in a MySQL database
The Following SQL query will list all tables in a MySQL database and also list the row counts for each. where mydatabase is the name or your database. The output…