Search Results

Amazon DynamoDB is a fully managed NoSQL database service that allows to create database tables that can store and retrieve any amount of data. It automatically manages the data traffic of tables over multiple servers and maintains performance. It also relieve...

Amazon Redshift is a fully managed data warehouse service in the cloud. Its datasets range from 100s of gigabytes to a petabyte. The initial process to create a data warehouse is to launch a set of compute resources called nodes, which are organized into group...

MySQL is the most popular Open Source Relational SQL database management system. MySQL is one of the best RDBMS being used for developing web-based software applications. This tutorial will give you quick start with MySQL and make you comfortable with MySQL p...

What is a Database? A database is a separate application that stores a collection of data. Each database has one or more distinct APIs for creating, accessing, managing, searching and replicating the data it holds. Other kinds of data stores can also be used...

All downloads for MySQL are located at MySQL Downloads. Pick the version number of MySQL Community Server which is required along with the platform you will be running it on. Installing MySQL on Linux/UNIX The recommended way to install MySQL on a Linux syst...

Running and Shutting down MySQL Server First check if your MySQL server is running or not. You can use the following command to check it − ps -ef | grep mysqld If your MySql is running, then you will see mysqld process listed out in your result. If server...

MySQL works very well in combination of various programming languages like PERL, C, C++, JAVA and PHP. Out of these languages, PHP is the most popular one because of its web application development capabilities. This tutorial focuses heavily on using MySQL in...

MySQL Connection Using MySQL Binary You can establish the MySQL database using the mysql binary at the command prompt. Example Here is a simple example to connect to the MySQL server from the command prompt − [root@host]# mysql -u root -p Enter password:*...

Create Database Using mysqladmin You would need special privileges to create or to delete a MySQL database. So assuming you have access to the root user, you can create any database using the mysql mysqladmin binary. Example Here is a simple example to crea...

Drop a Database using mysqladmin You would need special privileges to create or to delete a MySQL database. So, assuming you have access to the root user, you can create any database using the mysql mysqladmin binary. Be careful while deleting any database b...

Once you get connected with the MySQL server, it is required to select a database to work with. This is because there might be more than one database available with the MySQL Server. Selecting MySQL Database from the Command Prompt It is very simple to selec...

Properly defining the fields in a table is important to the overall optimization of your database. You should use only the type and size of field you really need to use. For example, do not define a field 10 characters wide, if you know you are only going to u...

Ubuntu 22.04 comes with PHP 8.1. This article describes how to change this and install and set as default the version 8.0 or 7.4. Install PHP Version Install the required dependencies. sudo apt install software-properties-common ca-certificates lsb-release ...

A step by step guide with an example project AWS provides more than 100 services and it’s very important to know which service you should select for your needs. Amazon Elastic Kubernetes Service (Amazon EKS) is a managed ...

Step -1  -  Plan deployment process in three stages.                           a - Developmnet .              b- Staging              c - Production.                                                     Step - 2 -  Seletct  your version control ( GitLab...

Now, open up mysite/settings.py. It’s a normal Python module with module-level variables representing Django settings. By default, the configuration uses SQLite. If you’re new to databases, or you’re just interested in trying Django, this is the easiest choic...

Now we’ll define your models – essentially, your database layout, with additional metadata. Philosophy A model is the single, definitive source of information about your data. It contains the essential fields and behaviors of the data you’re storing. Djang...

That small bit of model code gives Django a lot of information. With it, Django is able to: Create a database schema (CREATE TABLE statements) for this app. Create a Python database-access API for accessing Question and Choice objects. But first we need...

If this is your first time using Django, you’ll have to take care of some initial setup. Namely, you’ll need to auto-generate some code that establishes a Django project – a collection of settings for an instance of Django, including database configuration, Dj...

Let’s verify your Django project works. Change into the outer mysite directory, if you haven’t already, and run the following commands: $ python manage.py runserver You’ll see the following output on the command line: Performing system checks... ...