Apache ShardingSphere is an Open Source project that consists of three independent projects JDBC, Proxy, and Sidecar (Planning). Apache ShardingSphere utilizes ANother Tool for Language Recognition (ANTLR) as a generator for the ShardingSphere parse engine. Users can utilize this independent parse engine to get the Abstract Syntax Tree (AST) of…
In this article, I’m going to explain some of the best practices in Angular application development that I’ve learnt and used in XmlToJson project.
1. Use const when the value is not going to be reassigned
When a variable is about to point to a constant reference always, we can simply put const instead of let . …
Before jumping into the development of complex CLI applications with advanced procedures and make use of other packages and libraries/tools, first, we need to understand the core concepts of making a CLI application.
After reading this article, you’ll understand the concepts of making a CLI, factory design pattern, and will…
In this article, we’ll look at how to convert a string to an array of characters in Java. I’ll also briefly explain to you what strings, characters, and arrays are.
What is a Character in Java?
Characters are primitive datatypes. A character is a single character enclosed inside single quotation marks. It can be a letter…
In this article, we’ll look at how to use join on more than two tables and aggregate the result using the function STRING_AGG() in Microsoft SQL Server.
If you don’t know about Microsoft SQL Server, I’ll briefly explain to you what it is.
😃
What is Microsoft SQL Server?
Microsoft SQL Server is a Relational…
Computer-generated random numbers are divided into two categories: true random numbers and pseudo-random numbers.
True random numbers are generated based on external factors. For example, generating randomness using surrounding noises.
But generating such true random number is a time-consuming task. …
String objects are represented as a string of characters.
If you have worked in Java Swing, it has components such as JTextField and JTextArea which we use to get our input from the GUI. It takes our input as a string.
If we want to make a simple calculator using…
In Linux, when you forget your account password, you can easily reset it using a root account. But when you forget your root account password, then you’re in a bad situation.
You can’t reset your root account password using a regular user account as a user account can’t perform such…
What is VirtualBox?
Oracle VM VirtualBox is a cross-platform virtualization application developed by the Oracle Corporation. It allows users to install operating systems on virtual hard disks such as Windows, macOS, Solaris and Linux.
As an example, you can run Windows and Linux on your Mac, run Windows server on your Linux server…
In this article, we shall consider key concepts of the relational data model and relational database constraints.
First, let us consider terms in the relational data model.
Terms in the Relational Data Model
- Relational model: a collection of relations.
- Relation: table
- Tuple: row
- Attribute: column
- Domain: a set of atomic values
- Atomic values: single values
- Degree…
