Category:Database

  • Tcallusdb Jun · industry news collection (July 20)

    Time:2021-8-2

    Tcallusdb has been paying close attention to the dynamics of the game industry and database industry. The following is a compilation of recent news about the game industry and database industry collected by tcallusdb Jun, which is dedicated to you.(part of this article comes from the Internet) The white paper on relational database technology and […]

  • Spring boot is combined with mybatis and druid to realize multiple data sources, which can be switched automatically

    Time:2021-8-2

    Original address: https://blog.lanweihong.com/p… Github: spring-boot-mybatis-multiple-data-source Add dependent packages editpom.xmlFile, add related dependencies: <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.4.8</version> <relativePath/> </parent> <properties> <mysql.driver.version>8.0.16</mysql.driver.version> <mybatis.spring.boot.version>1.3.2</mybatis.spring.boot.version> <druid.version>1.1.10</druid.version> <tk.mybatis.version>2.1.5</tk.mybatis.version> <lombok.version>1.16.18</lombok.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>${lombok.version}</version> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>${mybatis.spring.boot.version}</version> </dependency> <!– mysql driver –> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>${mysql.driver.version}</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>${druid.version}</version> <exclusions> <exclusion> […]

  • Exploring flowers, making friends and building distributed project

    Time:2021-8-2

    1. Maven structure (illustration) 2. Engineering construction Tana defines the required version of the parent project <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.1.0.RELEASE</version> </parent> <properties> <mysql.version>5.1.47</mysql.version> <jackson.version>2.9.9</jackson.version> <druid.version>1.0.9</druid.version> <servlet-api.version>2.5</servlet-api.version> <jsp-api.version>2.0</jsp-api.version> <joda-time.version>2.5</joda-time.version> <commons-lang3.version>3.3.2</commons-lang3.version> <commons-io.version>1.3.2</commons-io.version> <mybatis.version>3.2.8</mybatis.version> <mybatis.mybatis-plus>3.1.1</mybatis.mybatis-plus> <lombok.version>1.18.4</lombok.version> </properties> <!– Generic dependencies — ><dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </dependency> <dependency> […]

  • How to quickly set up a refined operation platform for free through Analysys Argo?

    Time:2021-8-2

    It often takes a long time to write various temporary scripts and log with business personnel. They want to use third-party tools to improve efficiency, but they spend money and pay, and the company’s approval process is particularly slow… These are the personal experience of data engineers. Analysys Argo is launched to solve everyone’s dilemma. […]

  • There is a large amount of data and paging query is very slow. What is the optimization scheme?

    Time:2021-8-2

    Read by little hub: When the number of pages is large, the query efficiency drops sharply. Is there any way to optimize it? Finish reading this article! Author: youyou I Source: cnblogs.com/youi/p/7851007.html preparation General paging query Use subquery optimization Use ID qualification optimization Use temporary table optimization ID description of data table * When there […]

  • Redis learning replication and three deployment modes

    Time:2021-8-2

    Redis learning replication and three deployment modes What is replication Single machine redis usually cannot meet the project requirements. It is generally recommended to use cluster deployment for multi machine backup and deployment of data, so as to ensure data security. At the same time, replication can also quickly repair the data when redis is […]

  • PostgreSQL high availability: a multi master replication solution

    Time:2021-8-2

    Author: ibrar Ahmed joined percona in July 2018. Prior to joining percona, ibrar worked as a senior database architect in enterprisedb for 10 years. Ibrar has 18 years of software development experience. Ibrar has written many books on PostgreSQL. Translator: Wei Bo, executive director of training and certification of China PG branch and Senior Database […]

  • Notes on node blog project development

    Time:2021-8-2

    Nodejs development personal blog project Preview address:http://baijiawei.top GitHub address:https://github.com/bjw1234/blog Modules to be installed Body parser parses post requests Cookies read / write cookies Express build server Markdown syntax parsing generator Mongoose operation mongodb database Swig template parsing engine directory structure DB database storage directory Models database model file directory Public public file directory (CSS, JS, […]

  • Introduction to mybatis principle

    Time:2021-8-2

    ORM (object / relational mapping), namely object relational mapping, completes the mapping from object-oriented programming language to relational database. The sole function of ORM tool is to convert the saving, modification, deletion and other operations of persistent objects into database operations. ORM basic mapping relationship: Data table mapping class. The row mapping object (instance) of […]

  • Ora-21561: oid generation failed

    Time:2021-8-2

    When connecting Oracle with Navicat on the Mac, you always prompt: ora-21561: oid generation failedSolving processEnter: ~ hostname on the terminallocalhostView the / etc / hosts file: ~ cat / etc / hosts127.0.0.1 localhostJust keep the hostname consistent with the name corresponding to 127.0.0.1 in the hosts file! ========================================Modify the hostname commandsudo scutil –set HostName […]

  • Lock screen interview questions – mybatis (I)

    Time:2021-8-1

    Lock screen interview questions will be brushed every day, and the interview questions will be updated every working day. The lock screen interview question app and applet are now online. The official website address is: https://www.demosoftware.cc/#… 。 It has included all the contents of the interview questions updated every day, as well as the features […]

  • Tcallusdb | great heat brings glory to all things

    Time:2021-8-1

    July 22 ushered in the hottest day of the year – heatstroke. As one of the 24 solar terms, most of you just heard about it in general. Next, let Mr. tcallusdb popularize science for you. Great heat is the last solar term in summer. Between July 22 and 23 of the Gregorian calendar, the […]