.NET Framework 4.8 console application in C# accesses the established database through EF

Table of Contents 1. Create a .NET Framework 4.8 console application 2. Establish a database 1. Establish database Blogging in SSMS 2. Create a new database connection on VS 3. Install the EF package 4. Automatically generate EF models and contexts 1.Blog.cs class model 2. Model of Post.cs class 3.BloggingContext.cs database context 5. Write an […]

Database integrity – entity integrity, referential integrity, attribute constraint naming clauses, domains

Article directory Database integrity 1. Entity integrity 1. Define entity integrity 2. Entity integrity check and breach handling 2. Referential integrity 1. Define referential integrity 2. Reference integrity check and default conditions 3. Constraints on attributes 1. Definition of constraints on attributes 2. Inspection of constraints on attributes and handling of breaches 4. Integrity constraint […]

Database|Binlog troubleshooting: drainer strikes periodically

Table of Contents 1. Background 2. Fault phenomenon 3. Analysis process 4. Solution 5. Thinking 6. Summary 1. Background Recently, users have reported that the drainer of our production environment TiDB cluster frequently fails. Failures manifest as service crashes and failure to start, or data being lost during operation, which brings great trouble to our […]

Use cdc technology to synchronize data in real time (canal) – monitor local data and synchronize data to the cloud database through MQ

Use cdc technology to synchronize data in real time (canal) – monitor local data and synchronize data to the cloud database through MQ 1. Download the canal package and modify the configuration file conf -> instance.properties under example canal.instance.master.address=192.168.8.211:3306 Change the connection database path canal.instance.dbUsername=root user account to connect to the database canal.instance.dbPassword=123456 User password […]

An explanation of transaction isolation and other concurrent transactions in MySQL database

In MySQL, the transaction isolation level defines the situation in which a transaction and other concurrent transactions can see each other’s changed data. The SQL standard specifies four isolation levels, as follows: Serialization (SERIALIZABLE): Transactions are executed serially, that is, each transaction must wait for the end of the previous transaction before starting execution. This […]

Python connection to MySQL database programming

Database programming is a critical part of interacting with the database and managing data in your application. MySQL is a popular relational database management system (RDBMS), and MySQL database programming is relatively easy in Python. This article introduces how to use Python for MySQL database programming, including operations such as connecting to the database, executing […]

SpringBoot3+Vue3+Mysql+Element Plus completes the database storage of blob type images, and the front end renders the base64 type images transmitted from the back end.

Foreword If your front-end and back-end separation project uses SpringBoot3 + Vue3 + Element Plus, and without OSS (object storage), use mysql to read and write images (may not be limited to images, to be tested). It took three days and after stepping on countless minefields, this function was finally completed. Presented to you. Complete […]

Interaction between MySQL database and python code

Article directory 1. Prepare data Create database Insert data 2. Review of SQL statements Strengthening of SQL statements Create the “Product Classification” table Synchronize table data 3. Steps to operate MySQL in Python Import module Connection object Cursor object 4. Python’s addition, deletion, modification and query operations on MySQL 5. Parameterization 1. Prepare data The […]

How to deploy Entity Framework database migration

Table of Contents Migrate via app least privileged subject Migrate via build server Command line tools Idempotent SQL script Bundle?Edit command line application Certification Summarize Managing stateful data is often one of the trickier parts of a DevOps strategy. Entity Framework’s migration capabilities can greatly help with small, independently executable, PR-friendly increments. In theory, it […]