Simply Explaining Technology
DynamoDB is a fully managed NoSQL database service provided by Amazon Web Services (AWS). It is designed to deliver high-performance, scalable, and reliable database solutions for applications that require low-latency…
Amazon RDS (Relational Database Service) and Amazon Aurora are both managed database services provided by Amazon Web Services (AWS) that allow you to run a relational database in the cloud…
Relational databases and NoSQL databases are two different types of databases that serve different purposes and have different strengths and weaknesses. Relational databases are based on the relational data model…
The world of data storage has come a long way since the days of paper records and filing cabinets. With the advent of the internet and digital technology, storing and…
Emptying a databases involves dropping (deleting) all its tables. The easiest way to do this is to drop and recreate a database: Depending on the system you are working, the…
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…
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…
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 assigned the following values: sequentially.…
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…