Tutorial by Examples: p

In InnoDB, having a long PRIMARY KEY (either a single column with a lengthy value, or several columns that form a long composite value) wastes a lot of disk space. The primary key value for a row is duplicated in all the secondary index records that point to the same row. Create an AUTO_INCREME...

To automatically reload vimrc upon save, add the following to your vimrc: if has('autocmd') " ignore this section if your vim does not support autocommands augroup reload_vimrc autocmd! autocmd! BufWritePost $MYVIMRC,$MYGVIMRC nested source % augroup END endif a...

To integrate Siri capabilities in your app, you should add an extensions as you would do while creating an iOS 10 Widget (old Today View Extension) or a custom keyboard. Adding capability 1- In the project settings, select your iOS app target and go to Capabilities tab 2- Enable the Siri capabili...

Method 1: proc sql; create table foo like sashelp.class; quit; Method 2: proc sql; create table bar as select * from sashelp.class (obs=0); quit; Method 1 should be the preferred option

Modern versions of Jenkins (version 2.x) come with a "Build Pipeline Plugin" that can be used to orchestrate complex CI tasks without creating a multitude of interconnected jobs, and allow you to easily version-control your build / test configuration. You may install this manually in a &q...

Here is an example of a pipeline script that builds a Docker container, then runs the tests inside of it. The entrypoint is assumed to be either manage.py or invoke/fabric with a runtests command available. #!/usr/bin/groovy node { stage 'Checkout' checkout scm sh 'git submodule update ...

To receive push notifications we are supposed to tell the plugin to listen to incoming push notifications. This step is done after initialization & registration import { Push, NotificationEventResponse} from "ionic-native"; //the push element is created in the initial...

The Maven Surefire plugin runs during the test phase of the Maven build process or when test is specified as a Maven goal. The following directory structure and minimum pom.xml file will configure Maven to run a test. Directory structure inside the project's root directory: ─ project_root ├─ p...

Most of linux distros stores its version info in the /etc/lsb-release (debian) or /etc/redhat-release (RPM based) file. Using below generic command should get you past most of the Debian and RPM derivatives as Linux Mint and Cent-Os. Example on Ubuntu Machine: cat /etc/*release DISTRIB_ID=Ubuntu ...

val allowedUsers = users.filter { it.age > MINIMUM_AGE }

val isOfAllowedAge = { user: User -> user.age > MINIMUM_AGE } val allowedUsers = users.filter(isOfAllowedAge)

This example will explore how to see the layout of a video track and how to extract the individual pictures within it. The sample content used here is Tears of Steel, by Blender Foundation. Specifically, we will use the download titled "HD 720p (~365MB, mov, 2.0)". This is a single file t...

DASH is the most widely deployed adaptive streaming technology in modern solutions, used to deliver video in a wide variety of scenarios. The best way to understand DASH presentations is to observe the network activity that takes place during playback. This example uses Fiddler to capture and analy...

Mongoose connect has 3 parameters, uri, options, and the callback function. To use them see sample below. var mongoose = require('mongoose'); var uri = 'mongodb://localhost:27017/DBNAME'; var options = { user: 'user1', pass: 'pass' } mongoose.connect(uri, options, function(err){...

I.Overview A significant difference between MongoDB & RDBMS is MongoDB has many kinds of operators. One of them is update operator, which is used in update statements. II.What happen if we don't use update operators? Suppose we have a student collection to store student information(Table view...

There exist cases in which it is necessary to put data of different types together. In Azure ML for example, it is necessary to pass informations from a R script module to another one exclusively throught dataframes. Suppose we have a dataframe and a number: > df name height team...

Three things are needed to use async-await: The Task object: This object is returned by a method which is executed asynchronously. It allows you to control the execution of the method. The await keyword: "Awaits" a Task. Put this keyword before the Task to asynchronously wait for it to...

Log on to the Azure classic portal. In the left navigation pane of the portal, click Service Bus. In the lower pane of the portal, click Create. In the Add a new namespace dialog, enter a namespace name. The system immediately checks to see if the name is available. After...

Log on to the Azure classic portal. In the left navigation pane of the portal, click Service Bus. Select the namespace that you would like to create the queue in. In this case, it is “mytestns1.” Select Queues. Select New in the bottom left corner, then select Quick Creat...

The simple use-case is to refer to a single icon in its normal size: <i class="fa fa-camera-retro"></i> (View result in this fiddle.) Create an empty tag (it is recommended to use <i> used for that) and assign class "fa" and the class corresponding to the desi...