Tag:Database

  • ADO.NET Transaction encapsulation

    Time:2020-8-14

    In the process of compiling database tool class, we want to avoid repeating the assignment of transaction objects of each atomic operation in the process of transaction processing. The method to be exposed is as follows public bool ExecuteTransition(Action TransitionAction, out string ExceptionStr) The external database operations are all packaged by delegation, and the internal […]

  • Record a Windows MySQL recovery

    Time:2020-8-14

    0x00 event Because of the failure of the local server hardware, the development environment of a Windows system was hung up and could not recover in a short time. The emergency plan is to use the system on the cloud to rebuild the development environment. The developers said that they needed the database data in […]

  • A series of data operations

    Time:2020-8-14

    Preface In previous articles, we learned how to use ADO.NET Access database, how to modify and add data. How to get data through dataset and DataAdapter, we will try to implement a simple ORM framework or ORM tool class in this article. Related knowledge points: Reflection (primary) ADO.NET Existing knowledge 1. ORM So, the question […]

  • Basic usage of mongodb

    Time:2020-8-14

    Basic usage of mongodb The main details are in http://www.runoob.com/mongodb… This note is the most basic use of notes My mongodb is in/usr/local/Cellar/mongodb/4.0.4_1/bin/Inside, CD into this It must be first./mongodAnd then use it again./mongoStart Mongo at the terminal If you want to turn off mongod, you can press Q to leave, or you cantopView the […]

  • Model class design and display in Django

    Time:2020-8-14

    The design of data model class in Django is based on object relation mapping of ORM, which is more convenient for data operation in database. ORM Object relation mapping The object-oriented class and database table corresponding, through the operation of class and object, logarithmic table to achieve data operation, do not need to write SQL, […]

  • Recommendation of MySQL high performance optimization specification

    Time:2020-8-14

    A good life is not static, but dynamic. It is not an end, but a direction. Database command specification All database object names must be lowercase and delimited with underscores MySQL reserved keywords are prohibited for all database object names (if keyword queries are included in table names, they need to be enclosed in single […]

  • The database connection string in the configuration file is encrypted. Do you think I can’t dig it out?

    Time:2020-8-14

    1: Background 1. Tell a story I found a bug in the terminal of IOT cabinet a few days ago app.config The database connection string in is encrypted, because I want to switch the database during debugging, I need to put the ciphertext on a special tool to decrypt. After changing the database name on […]

  • Getting started with mybatis

    Time:2020-8-14

    Mybatis usage scenarios In mybatis development, most of our efforts were focused on SQL mapping configuration files. Although mybatis requires developers to configure their own SQL statements and mybatis to implement the mapping relationship, such projects can adapt to changing project requirements. Therefore, the scenario of using mybatis is that the SQL optimization requirements are […]

  • MySQL / MariaDB master slave replication

    Time:2020-8-13

    concept What is MySQL / MariaDB master slave replication? MySQL / MariaDB master slave replication: when the master database changes, the changes will be synchronized to the slave database in real time; Similar to: Samba shared file (C / s), NFS network file share (C / s), when the server (server) changes, the client (client) […]

  • Go language series redis

    Time:2020-8-13

    Use of redis Basic introduction to redis Redis is a NoSQL database, not a traditional relational database official website https://redis.io/ And http://www.redis.cn/ Redis:REmote DIctionary Server (remote dictionary server). The performance of redis is very high. A single machine can reach 15W QPS. It is usually suitable for caching and persistence. It is a fully open […]

  • Speed up enterprise application development, release ntaub 3 rapid development platform

    Time:2020-8-13

    After so many years of enterprise management system, the main function is to add, delete and modify forms and data. The only change is “change”. The business model and process of the enterprise are more and more diversified, the development requirements change more and more frequently, but the development cycle is required to be shorter […]

  • Mysqldump backup and xtrabackup backup best practices

    Time:2020-8-13

    Write it at the front 1. Backup type (1) According to the file after backup a. Physical backup: direct backup of database files, commonly used LVM logical volume backup, or direct copy of compressed database data directoryb. Logical backup: use the backup tool to export the data in the database as database SQL script or […]