• What is connection string in MySQL

  In this article, we will learn how we can access the data from the MySQL database using the PHP language.

  [...]

  Connection string is a string that specifies the information related to database login. For understanding, we will consider an example of a PHP scripting language and will write a code to establish the connection with the database. We have a database, named “Organization”, the user name is “maadi” and password is “qwer1234”...

• What is schema in MySQL

  The data in MySQL is managed in databases in the form of tables, which further consist of rows and columns. What is Schema? Schema is different from databases as it does not have all the privileges that a database holds, it has only privileges of tables, rows, and columns which defines the structure of a database.

  In this write-up, we will explain what a schema is, how it works, and what are the differences between the schema and database.

• What is “IS NULL” query in MySQL

  The ‘IS NULL” query in the MySQL database shows the data which is either missing or is unknown to DMS. A NULL value is different as it has no value, it is neither equal to zero integer or to an empty set. Null is a state, not a value, if we compare the NULL value to any other NULL value, the result will always be NULL because it’s unknown itself. A “IS NULL” query is used when data is missing or unknown for example we make a list of phone directories, if any person’s phone number is unknown then “IS NULL” will extract it and the number can later be added to complete the directory.

  In this article, we are going to understand what the “IS NULL” query is and how it works with some examples.

• How to use the SELECT INTO TEMP table statement in MySQL

  Sometimes, we are supposed to fetch out data from different MySQL tables which we can use for some specific purpose. For our ease, we create a temporary table and place all the data there which we can later use. When the session is over, the table will vanish on its own, else it can delete it using the DROP command. Similarly, to create the clone of the table we use the statement “SELECT INTO”, which not only copies the contents of the selected table but also inserts all the content into the newly created table.

  In this write-up, we will learn how to use the statement “SELECT INTO TEMP TABLE” in MySQL and how this statement works.

• How to use mysqli_real_escape_string function

  A mysqli_real_escape_string is a built-in function of the PHP that is used to control the unwanted and dangerous characters. In this article, we will discuss with the help of an example what is the mysqli_real_escape_string function and how it can be used for the protection of the database.

• How to use MySQL Substring function

  Mysql has a variety of built-in functions for different purposes, one of them is the function of the substring. The function of substring deals with the “string” data type and it is used in database management to extract the string from the tables. Now what the string is? The string is the collective combination of the characters. For example, “Hello LinuxHint” and “KHG1234” are strings.

  In this article, we will understand what is the substring function and how it can be used in MySQL in managing the data in the databases.

• How to use MySQL COALESCE function

  MySQL is a DBMS that has a concept of Null values. In MySQL, COALESCE function is used as it returns the first non-null value from the specified series of expressions. If all values of the column are null then COALESCE will also return the null. It works similarly to “IS NULL query ”; both deals with the NULL values but the difference in both of them is of their behavior, “IS NULL” query extracts the null values from the table whereas the COALESCE function gives the first non-null value if there is any null value present in the table.

  In this write-up, we will explain what COALESCE function is in MySQL and how it can be used with the help of examples.

• Granulate Joins The Cloud Native Computing Foundation

  Granulate, a provider of autonomous real-time computing workload optimization and cost reduction solutions, today announced it is joining the Cloud Native Computing Foundation (CNCF), part of the nonprofit Linux Foundation. The announcement comes as part of Granulate's deepening connection to the cloud computing community and the Kubernetes and open-source ecosystems.

• Dual-Stack Networking in Kubernetes

  Dual-stack networking has arrived in Kubernetes. IPv4/IPv6 dual-stack support is key to the future of Kubernetes, whether powering new 5G and edge workloads or scaling beyond today’s cluster limits to meet your future needs. Let’s dive into the cross-organizational collaboration that brought us this long-awaited goal and examine how the feature evolved over time.

• GridGain Expands Ignite Summit, Adds Pre-conference Day with New Kubernetes Training

• [Old] OverOps Bolsters Big Data App Reliability with Root Cause Analysis for Apache Spark

  OverOps, the leading solution for root cause analysis at runtime, today debuted its support for Apache Spark, the popular open-source analytics engine for large-scale data processing. This support allows developers to identify and resolve critical exceptions on Spark jobs in minutes, eliminating the need for laborious and time-consuming detective work in searching logs to figure out why their Apache Spark job broke. With no code changes required, OverOps captures a full stack trace of when, where, and why exceptions occurred along with the associated variable state.

• Announcing Istio 1.10.5

  This release contains bug fixes to improve robustness. This release note describes what’s different between Istio 1.10.4 and Istio 1.10.5.

• OpenStack Xena, the 24th OpenStack release, is out

  It was out at 3pm, and I managed to finish uploading the last bits to Unstable at 9pm… Of course, that’s because all of the packaging and testing work was done before the release date. All of it is, as usual, also available through a Bullseye non-official backports repository that can be added using extrepo (ie: “extrepo enable openstack_xena”).

Despite the open source origin, Moodle still has plenty of features. A notable one is the modern interface, that is designed to be used via a web browser on a desktop or laptop, or on mobile platforms with available iOS and Android apps (see below). This interface includes a personalized dashboard that can display a list of courses, including the current ones, along with past courses, and future ones as well. Also displayed are the pending tasks.

There are plenty of advanced features as well that go beyond the basics. A good example is the text editor. This easy to use text editor is designed to work from within the web interface, and facilitates both formatting text, and also adding in images and other content. There is also file management, and allows users to drag and drop files from popular online cloud storage providers, such as DropBox and Google Drive. There is also an all-in-one calendar to track everything from group meetings and personal events.

Moodle also encourages collaboration among educators and among learners. To this end, there is support for a variety of activities, such as chat, wikis, forums, database activities and glossaries. Teachers can also encourage interaction, by including full quizzes, or even a single multiple choice question that is called ‘Choice.’

Teachers not only can grade an assignment online, but also can provide comments to guide the student’s learning. Surveys can also be created for learners to provide feedback and to guide lessons. Workshops can also be created to get a peer assessment.