ANTLR4 SQL parsing of sharding-jdbc
Public Number: Madad's Technical Wheel
Sharing mainly uses ANTLR4 to parse SQL. Take mysql as an example, before analyzing the source code, we can first understand the following three points:
antlr4, how to write.g4 grammar file
The mysql grammar can be referred to https://dev.mysql.com/doc/refman/8.0/en/sql-syntax-data-manipulation.html
...
Posted by trippyd on Thu, 03 Oct 2019 22:02:18 -0700
Simple Use of Sharing-sphere 3.1.0
At the beginning, I spent half a day searching for sharding-sphere on the Internet and reading the source code for half a day (trying to use the @Configuration annotation instead of writing configuration files, I think there are too many configuration files, which are dazzling), and I didn't understand why.
Later, I found a more complete answe ...
Posted by movieflick on Thu, 03 Oct 2019 21:47:23 -0700
Python automation: export zabbix data concurrent mail scripts
Zabbix has no report export function, so it exports ZABBIX data and sends mail concurrently by writing scripts. The results are as follows:
[External Chain Picture Transfer.. (img-YujWHCbu-1565876650802)]
Following is the script, which can be modified according to its own specific circumstances:
`#!/usr ...
Posted by malbera on Thu, 03 Oct 2019 04:30:26 -0700
mybatis Details - Dynamic sql_Common Label Details
IF Tags
Problems arising from the non-use of if tags
Dynamic splicing sql is realized by various tag methods provided by mybatis.
Demand: user enquiry based on gender and name
Query sql:
SELECT id, username, birthday, sex, address FROM user WHERE sex = 1 AND username LIKE'% Liu%'
<!-- Query users b ...
Posted by RamboJustRambo on Thu, 03 Oct 2019 03:45:27 -0700
ExtJs 4.2 Application: Using ExtJs Extension Component searchfield to Realize Data Search Function
Links to the original text: https://my.oschina.net/qiuzhping/blog/611700
ExtJs 4.2 Application: Extending component search field with ExtJs
Implementing Data Search Function
1. Int ...
Posted by jonathandg on Wed, 02 Oct 2019 12:37:45 -0700
Spring Data Jpa Learning-Dynamic Query
Specifications dynamic query
Sometimes when we query an entity, the given condition is not fixed, so we need to dynamically construct the corresponding query statement. In Spring Data JPA, we can query through Jpa Specification Executor interface. Compared with JPQL, its advantage is type-safe and mor ...
Posted by discosuperfly on Wed, 02 Oct 2019 11:22:27 -0700
The use of Druid in Spring and Spring Book projects
What is it?
One kind of database connection pool, manages and releases the connection of database, realizes the reuse of connection, and can compare thread pool.
Parameter configuration
What can we do?
1, Connection Pool 2, Monitoring 3, Encryption 4, Extending JDBC
How do you use it?
Adding ...
Posted by LightningSt on Wed, 02 Oct 2019 09:51:18 -0700
sharding-jdbc read-write separation
Read the official document before analyzing the source code Read / write separation Major Records Learn, Public Number: Madad's Technical Wheel
Core concept
Main library: add, update and delete data operations
Slave library: The database used to query data operations, which can support multiple slave Libraries
Multi-master and multi-slav ...
Posted by thedualmind on Wed, 02 Oct 2019 01:49:01 -0700
Database Connection Pool Druid Configuration
Druid is provided by the C3P0, and the specific operation steps are very similar to those of the C.
We will copy the downloaded Druid directly into the IDEA tool
Druid's configuration file is in the form of properties. Its configuration file can be called any name and can be placed in any directory. It ...
Posted by max101 on Wed, 02 Oct 2019 01:29:05 -0700
Photon Use Experience
The evaluation is not very pleasant, but it has to be used.
Translated Documents: Although the version is very old, it is still valuable.
https://vibrantlink.com/pun_multiplay_manual/?tdsourcetag=s_pcqq_aiomsg
Common api memo
Custom classes inherit from Photon.PunBehaviour
Join the room: Phot ...
Posted by raw100 on Tue, 01 Oct 2019 21:19:59 -0700