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
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
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
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
Posted by cheshil on Wed, 03 Jun 2020 03:08:17 -0700
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
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
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
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
Choose the appropriate flow operation mode
Be careful to execute immediately
Will LINQ to Objects degrade code performance
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
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