Use of PostgreSQL_upsert function (insert_on_conflict_do)
Label
PostgreSQL , upsert , insert on conflict do
background
PostgreSQL 9.5 introduces a new feature, UPSERT(insert on conflict do), which returns directly when an insert encounters a constraint error, or performs UPDATE instead.
The syntax is as follows
Command: INSERT
Description: create new rows in a table
Syntax:
[ WITH [ RE ...
Posted by tym on Sat, 22 Dec 2018 08:51:06 -0800
Still and Video Media Capture
Still and Video Media Capture
Most of the content comes from AV Foundation Development Secret Book.
AVFoundation capture class
Capture session
AVCaptureSession captures sessions that are equivalent to a virtual "plugboard" for connecting input and output resources. Capture session management data streams from physical devices ...
Posted by jwalsh on Fri, 21 Dec 2018 15:18:05 -0800
Spring Security Builds Rest Service - 0900-rememberMe Remember Me
Spring security remembers my basic principles:
When logged in, the request is sent to the filter Username Password Authentication Filter. When the filter is authenticated successfully, the RememberMeService is called and a token is generated, which is written to the browser cookie. At the same time, there is a TokenRepository inside the Rememb ...
Posted by mcdsoftware on Fri, 21 Dec 2018 12:15:06 -0800
MyBatis Initial 3_mapper.xml Optimization (parameterType Abbreviation_NameSpace Abbreviation_sql Fragment_Special Character Processing)_Dynamic SQL
This article is a hard summary for bloggers. I hope I can understand more deeply when I come back later. I also hope it can help beginners.
Reproduced from: luogg's Blog Garden Thank you for your cooperation.
optimization
1. Aliases (generally not used, easy to write to see the origin of the class)
Previous wording:
<insert id="insert"pa ...
Posted by TanyaTR on Fri, 21 Dec 2018 00:30:05 -0800
Day20-jsp & el & jstl
EL expression
${EL expression}
EL (Express Lanuage) expressions can be embedded in jsp pages to reduce the writing of jsp scripts. The purpose of EL is to replace the writing of scripts in jsp pages.
Expression language Expressions Language, borrowing js, jquery grammar
Effect:
1) Simplify the code in jsp, mainly to replace the JSP s ...
Posted by swasheck on Thu, 20 Dec 2018 18:12:05 -0800
Keepalived+Nginx+Redis+Tomcat for High Availability web Load Balancing
I. System Environment
Operating System: CentOS 7
tomcat 8.0.47
Nginx 1.12.2
Redis 4.0.2
192.168.124.128 tomcat1+Nginx+Redis
192.168.124.130 tomcat2
Specific how to install these software, here is no longer introduced, please go online to find information.
After installation, modify the port number of tomcat 2. If th ...
Posted by roice on Thu, 20 Dec 2018 17:48:05 -0800
JavaScript/jQuery, HTML and CSS to Build Web IM Remote and Timely Chat Communication Program
The original address is: JavaScript/jQuery, HTML and CSS to Build Web IM Remote and Timely Chat Communication Program
This article is mainly for introduction. JavaScript and jQuery,HTML,CSS And using the third-party chat JavaScript (jsjac) framework to build a BS Web chat application. This program can communicate and send mes ...
Posted by Patioman on Thu, 20 Dec 2018 08:33:08 -0800
Use and configuration of HTTPS on SL/TLS (IIS8 and iOS client)
Use and configuration of HTTPS on SL/TLS (IIS8 and iOS client)
CA certificate
1. Domain Name Type SSL Certificate (DV SSL): The trust level is ordinary, only need to verify the authenticity of the website can issue certificates to protect the website; generally free.
2. Enterprise-type SSL Certificate (OV SSL): Strong trust level, ...
Posted by _theworks on Thu, 20 Dec 2018 05:48:05 -0800
iOS uses NSURLProtocol to Hook to intercept WK Webview requests and play back a pose (ti) potential (wei)
Sometimes we have to interact with WK WebView. Although WK WebView has high performance, there are still many pits.
For example, we can get the js context in UIWebview in the following way, but WKWebView is error-prone
let context = webView.valueForKeyPath("documentView.webView.mainFrame.javaScriptContext") as! JSContext
context.evaluateScrip ...
Posted by poleposters on Wed, 19 Dec 2018 20:39:05 -0800
J2EE hibernate 4 Learning Notes (XVIII) -- hibernate Advanced Configuration (log4j Configuration Log Framework)
hibernate comes with a simple logging framework. Here we introduce a powerful logging framework log4j. Baidu Encyclopedia's introduction to log4j is very good. Most of the content below is copied from Baidu Encyclopedia.
Introduction to log4j (Baidu Encyclopedia)
Log4j is Apache An open source project, using Log4j, we can control the destinat ...
Posted by xt3mp0r~ on Wed, 19 Dec 2018 17:30:04 -0800