• Record a MySQL used in a product requirement


    Record a SQL used in a product requirement General demand calculation company’s total sleeping users are grouped according to the sleeping time, which is not the definition of sleeping users: they have purchase behavior and registration behavior (those who pay attention on wechat platform and register through mobile phone number).2 weeks to 1 month: 14 […]

  • [caption - dynamic programming - interview] masseuse – leetcode


    Title: masseuse   A famous masseuse will receive a steady stream of appointment requests, each appointment can choose to accept or not. There is a break between each appointment, so she can’t accept adjacent appointments. Given an appointment request sequence, find the optimal appointment set for the masseuse (the total appointment time is the longest), […]

  • Etcd routine (6) operating etcd in golang


    Previously, we talked about the operation of etcd in the command line mode. Today, let’s talk about how to operate etcd in the Champions League in golang. It’s still impossible to summarize that sentence. It just plays a role of bringing in. If you encounter it, you can make an in-depth study. At least you […]

  • Oracle automatic collection task statistics, SQL tuning


    –View auto collection task status SELECT CLIENT_NAME,STATUS FROM DBA_AUTOTASK_CLIENT; SELECT CLIENT_NAME, STATUS FROM DBA_AUTOTASK_CLIENT WHERE CLIENT_NAME = ‘auto optimizer stats collection’; –Turn off auto optimizer stats collection BEGIN DBMS_AUTO_TASK_ADMIN.DISABLE(CLIENT_NAME => ‘auto optimizer stats collection’, OPERATION => NULL, WINDOW_NAME => NULL); END; / –Shut down SQL optimizer SQL Tuning Advisor (STA) BEGIN DBMS_AUTO_TASK_ADMIN.DISABLE(CLIENT_NAME => ‘sql tuning […]

  • Exploration and visualization of shared bicycle data set


    Analysis background Analysis purpose This paper analyzes the impact of the relevant data of mobike order on the riding time, which is used as the reference and basis for business operation optimization (because there is no order amount data in the original data set, and because mobike takes the riding time as the charging standard, […]

  • Chinese string traversal


    Chinese string traversal problem I believe many people have encountered the situation of Chinese string traversal garbled.Generally, there are two ways to traverse a string: subscript traversal and for… Range. If the character contains Chinese, garbled code will appear when using subscript traversal. resolvent Convert the string to the type of [] run, and then […]

  • HTML5 video popular plug in video.js


    Video.js It is a general JS library embedded with video player on Web page, Video.js Automatically detect the browser’s support for HTML5. If HTML5 is not supported, flash player will be used automatically. (to support ie low version, please download version 5.4.3) Click to enter the official website   Download address: http://www.jq22.com/jquery-info404 CDN can also […]

  • Shen Jian uses three hours of video to tell you about high availability


    This is the video of Shen Jian’s speech at mpd2016 Beijing station. Comprehensively analyze the availability architecture and optimization of single point system, accessibility architecture of message system and consistency architecture and optimization of optimization / transaction system. 1. Availability architecture and optimization of Internet single point systemClick here to watch the video. The duration […]

  • Taro (react + TS) encapsulates a basic audio component (subsequent update of uni app (Vue)) based on inneraudiocontext


    Why package an audio component It’s mainly because wechat app is officialaudioNo maintenance, and in many casesiOSThere are also some problems on the real machine, such as click can’t play, the total time is not displayed and so on Requirements and limitations of audio components Click play or pause Display playback progress and total duration […]

  • Alibaba cloud server Guide


    Alibaba cloud server Guide Due novel coronavirus pneumonia, the school postponed the school. Don’t waste your time at home. It’s a good opportunity to improve your skills. Alibaba cloud elastic computing cooperates with the developer community to launch the “practice at home” program in Colleges and universities. Students in Colleges and universities across the country […]

  • Linux Shell FFmpeg


    Common codes ffmpeg -i input.mov -s 800×450 -b 1M -vcodec h264 -acodec aac output.mp4 Cutting screen #Width: width #Height: height #Left: left margin #Top: top margin ffmpeg -i input.mp4 -vf crop=[width]:[height]:[left]:[top] -b 1M -vcodec h264 output.mp4 #Keep the bottom left quarter # iw: input width # ih: input height # ———– # | | | […]

  • Slide in and slide out effect at the bottom of the applet


    You can use it by copying it directly wxml Click here wxss /*Modal box*/ .modal{position:fixed; top:0; right:0; bottom:0; left:0; z-index:1000;} .modal-cancel{position:absolute; z-index:2000; top:0; right:0; bottom: 0; left:0; background:rgba(0,0,0,0.3);} .bottom-dialog-body{width:100%; position:absolute; z-index:3000; bottom:0; left:0;background:#dfdede;} /*Initial position before animation*/ .bottom-positon{-webkit-transform:translateY(100%);transform:translateY(100%);} /*Bottom pop up*/ .bottom-positon{ text-align: center; } .huakuai{ margin-bottom: 20rpx; height:574rpx; width:100%; padding-top:50rpx; background:#fff; } wx.js data: […]