Research on MySQL coding
preface
It was in 2002, and MySQL 4.1 began to support UTF-8 coding RFC 2279 It is stipulated that the code uses 1 ~ 6 bytes to store a single character, and MySQL developers checked it in September of the same year Source code The UTF-8 encoding is changed from the maximum 6 bytes to 3 bytes, so there is the current UTF8MB3. As we all know, U ...
Posted on Tue, 07 Dec 2021 02:36:02 -0500 by misterguru
Using Amoeba to realize mysql read-write separation
Using amoeba to separate mysql reading and writing
1. What is amoeba?
Amoeba (amoeba) project focuses on the development of distributed database proxy. Located between Client and DB Server(s). Transparent to clients. It has load balancing, high availability, sql filtering, separation of reading and writing, routing related queries to the targ ...
Posted on Mon, 06 Dec 2021 22:39:12 -0500 by ironmonk3y
JDBC (Java database connection)
JDBC (Java database connectivity)
Is a Java API for executing SQL statements, which can provide unified access to a variety of relational databases. It is composed of a group of classes and interfaces written in Java language. JDBC provides a benchmark, according to which more advanced tools and interfaces can be built, so that database develo ...
Posted on Mon, 06 Dec 2021 16:44:34 -0500 by mnewhart
Implementing redis client using java (simple jedis)
The redis server uses port 6379 by default to communicate with the outside world, so we can actually implement a simple redis client on our own. This is done in java. Implementing a redis client consists of two main parts
socket communicationEncoding and decoding of redis communication protocol
The second part is mainly the implementation of ...
Posted on Mon, 06 Dec 2021 12:49:12 -0500 by goobers
Goodbye, MybatisPlus, Ali launches new ORM framework
Using fluent mybatis, you don't have to write specific xml files. You can construct more complex business sql statements through java api to achieve the integration of code logic and sql logic. You no longer need to assemble queries or update operations in Dao, or reassemble parameters in xml and mapper. Compared with native Mybatis, Mybatis Pl ...
Posted on Sun, 05 Dec 2021 20:51:29 -0500 by scialom
Database version management: flyway
flyway is a database migration tool that supports automatic backup and execution of SQL scripts. It is very convenient for us to deploy applications to multiple environments to initialize databases or upgrade database tables.
1, Why use flyway
Let's make an analogy with the Git version control tool, which is often used now. It can well ...
Posted on Sun, 05 Dec 2021 16:53:47 -0500 by ivi
DBMS_CLOUD: installed on 19c and 21c local databases
This article describes how to install DBMS in local 19c and 21c databases_ Cloud package. The package is installed in the database on the Oracle cloud.
Related articles:
DBMS_CLOUD PackageOracle Cloud Infrastructure (OCI) : Create an Object Storage BucketOracle Cloud : Autonomous Database (ADW or ATP) - Load Data from an Object Store (DBMS ...
Posted on Sun, 05 Dec 2021 13:23:53 -0500 by slick101
Chapter 5 SQL predicate BETWEEN
Chapter 5 SQL predicate BETWEEN
outline
scalar-expression BETWEEN lowval AND highval
parameter
Scalar expression - a scalar expression (most commonly a data column) that compares its value to the range of values between low and high values, including high values.lowval - an expression that resolves to a low collation sequence value ...
Posted on Sun, 05 Dec 2021 08:23:18 -0500 by yumico23
Variables and process control statements for procedural sql learning (phase 1)
1. Procedural sql and embedded sql
1.1 embedded sql
Embedded SQL refers to including SQL statements into programming language. The embedded programming language, such as C / CPP / Java, is called the host language.
For embedded SQL, DBMS generally adopts the precompiled method, that is, the preprocessor of DBMS scans the source progra ...
Posted on Sun, 05 Dec 2021 05:57:36 -0500 by gerkintrigg
SQL query language
1, Functions of SQL language
SQL functionpredicateData definition (DDL)CREATE,DROP,ALTERData query (DQL)SELECTData manipulation (DML)INSERT,UPDATE,DELETEData control (DCL)GRANT,REVOKE,DENY
2, Data types supported by SQL
SQL data types are composed of 13 basic data types, including shaping, single precision, double precision, variable length c ...
Posted on Sun, 05 Dec 2021 03:00:44 -0500 by ineedhelp512