SQL Base Notebook 2 View Stored Procedure

  View CREATE/ALTER/DROP VIEW ViewName as SELECT(...) You can continue to create a view based on it, that is, you can place the previously created view as a table name in the select statement of the new view Format data using views (that is, reassemble and stitch fields) CREATE VIEW View_player_team AS SELECT CONCAT(player_name, '(' , t ...

Posted by Izzy1979 on Fri, 26 Jun 2020 09:58:46 -0700

How to recover page level in SQL Server

In today's article, I want to talk about an important topic that every DBA should know: how to perform page level restore operations in SQL Server. Suppose you have a damaged page in SQL Server. You want to restore only the page in question from the latest database backup, not the entire database. 1 ...

Posted by Cut on Fri, 26 Jun 2020 01:43:33 -0700

My first ASP.NET Project summary

My first ASP.NET Project summary Recently, I was busy at the end of the term and didn't have time to update my blog. Here's one I'll do for myself ASP.NET Project (equipment management system) to summarize, the page template is the master, which greatly reduces the amount of code. Finally, the source code and database of the project are atta ...

Posted by stanleyg on Thu, 25 Jun 2020 23:34:59 -0700

Design of universal interface for accessing c + + relational database (JSON-ORM c + +)

Re operate the old c + + business and get used to the usual database operation mode, so take the time to encapsulate a C + + version of JSON orm. Now it supports sqlit3 and mysql, and postgres is ready. Design ideas Our general ORM, the basic pattern is to want to break away from the database, almost all in the programming language level model, ...

Posted by thedarkwinter on Thu, 25 Jun 2020 22:42:57 -0700

Akka typed - cqrs read write separation mode

Event source and cluster are introduced earlier. Now it's time to discuss CQRS. CQRS is the mode of separation of reading and writing, which is composed of independent writer program and reader program. The specific principle has been introduced in previous blogs. Akka typed should naturally support ...

Posted by dustbuster on Thu, 25 Jun 2020 19:26:59 -0700

Concurrent programming -- 7. Singleton mode

The pattern is separated from the language, and the singleton pattern in the design pattern is very important in the concurrency. We should not indulge in the language and architecture, but think about the problem from the design point of view. Technology is the easiest to be replaced. Only by formin ...

Posted by justinjkiss on Thu, 25 Jun 2020 04:15:57 -0700

With keyword matching, you are a qualified algorithm engineer

During the construction of the medical Q & a system these two days, I met with interesting algorithms, and I felt that the skeleton was quite surprised, so I recorded it. The purpose of this paper is to build an actree in the medical field, and to query the pre-processing of some characters in the n ...

Posted by Arsench on Tue, 23 Jun 2020 22:37:37 -0700

mycat configuration fragment

Machine information Machine IP Installation services Exposed port 192.168.177.128 mycat service External exposure port 8066 192.168.177.131 mysql1 External exposure port 3306 192.168.177.132 mysql2 External exposure port 3306 1. Install mycat 1.1 download the installation package (it is r ...

Posted by ganesh129 on Tue, 23 Jun 2020 22:20:45 -0700

Efficient image loading

Article catalog 1 installation 2 how to load images 2.1 Structure 2.2 OpenCV 2.3 Pillow 2.4 Pillow-SIMD 2.5 TurboJpeg 2.6 LMDB 2.7 TFRecords 3 load time comparison 4 Summary Image loading plays an important role in computer vision when writing optimized code. This process can be a bottleneck for ...

Posted by like_duh44 on Tue, 23 Jun 2020 20:18:57 -0700

Using reactive relational database connection specification R2DBC to operate MySQL database

1. Introduction It was introduced in March R2DBC , which is an asynchronous, non blocking relational database connection specification. Although some NoSQL database vendors provide reactive database clients for their databases, migration to NoSQL is not an ideal choice for most projects. This promotes the birth of a general responsive relation ...

Posted by jabapyth on Tue, 23 Jun 2020 18:58:16 -0700