SpringCloud+Vue Online Education Project - Integrating canal Data Synchronization

Introduction to Canal 1. Application Scenarios In the previous statistical analysis function, we have taken a service call to obtain statistics, which is highly coupled and relatively inefficient. At present, I take another way to achieve this by synchronizing the database tables in real time. For e ...

Posted by Labbat on Sat, 06 Jun 2020 19:30:27 -0700

My God? It's so simple to write the prototype of mybatis manually

preface mybaits is half of the world in ORM framework, because it is lightweight, semi-automatic loading, flexibility and extensibility. Deeply loved by the majority of companies, so our program development is inseparable from mybatis. But have we studied the mabtis source code? Or want to see but don't know how to look? In the final analysis, ...

Posted by padma on Sat, 06 Jun 2020 03:31:20 -0700

A simple way to use Mysql cursor

1, Introduction to cursors 1. Introduction to cursors Cursor is a database query stored on MySQL server. It is not a select statement, but a result set retrieved by the statement. With the cursor, the result set can be processed row by row conveniently. The design of cursors is the idea of data buffer, which is used to store the results of S ...

Posted by Selkirk on Fri, 05 Jun 2020 01:53:14 -0700

Oracle learning - PL/SQL assignment, type, exception, if, loop

summary: PL/SQL(Procedural Language/SQL) is a special application development language of Oracle database. It is a programming language formed after the process expansion of the standard SQL language. PL/SQL Oracle extends SQL procedure. PL/SQL database programming Benefits: simple, efficient, flexible and practical 1. Grammar Basic syntax: ...

Posted by cheshil on Wed, 03 Jun 2020 03:08:17 -0700

pydbclib: a general database operation tool for python

pydbclib It is a general python relational database operation toolkit. It uses a unified interface to operate various relational databases (such as oracle, mysql, postgres, hive, impala, etc.) for addition, deletion, and query. It is a connection driver package for various python databases (such as sqlalchemy, pymysql, CX_ The encapsulation of ...

Posted by timbuckthree on Tue, 02 Jun 2020 08:05:41 -0700

MySql Easy Start Series --- The first stop is to easily understand MySQL overall framework from the source point of view

One: Background 1. Storytelling Recently, looking at the major technical communities, whether they know, the Nuggets, the Blog Garden or csdn, we can hardly see any articles about sqlserver class shared by small partners. It looks like sqlserver has disappeared in recent years and no one has written it since. It is impossible to write sqlserver ...

Posted by Modernvox on Mon, 01 Jun 2020 17:54:38 -0700

Using Shell script to automatically backup MySQL database

Purpose: The 192.168.100.20 server backs up the MySQL database on the 192.168.100.10 server. 1. Configure MySQL server 1) 100.10 MySQL server log in to MYSQL to create two databases [root@centos01 ~]# mysql -uroot -ppwd@123 mysql> create database liyanxin; mysql> create database wangzhaojun; 2) liyanxin database creates tables and write ...

Posted by maliskoleather on Mon, 01 Jun 2020 08:09:44 -0700

Telegraf and Grafana monitor SQL Server on multiple platforms

problem SQL Server is deployed on multiple platforms (Windows,Linux and Container) in many enterprises. A solution that can support multiple platforms is needed to collect and display related monitoring indicators. I choose the popular monitoring display tool Grafana and monitoring indicator collection tool Telegraf to implement. This is also t ...

Posted by hermand on Mon, 01 Jun 2020 03:48:16 -0700

LINQ performance analysis

catalog Choose the appropriate flow operation mode Be careful to execute immediately Will LINQ to Objects degrade code performance Different methods What has been learned The cost of using LINQ to Objects Performance and simplicity: can't fish and bear paw have both LINQ's advantage is not to provide any new functions, but to enable us t ...

Posted by TreColl on Sun, 31 May 2020 21:06:09 -0700

type column parsing of explain

1,const Indicates that the execution step returns at most one row of data. const usually appears in the equivalent query of the primary key or unique index, such as the equivalent query of the primary key id of the t table:It can be considered that it is as fast as a rocket to locate a record by comparing the equivalence between the primary key ...

Posted by cachemony on Sun, 31 May 2020 08:54:30 -0700