Tutorial by Examples: on

Detailed instructions on getting kdb set up or installed.

It is possible to DELETE data from a table if it matches (or mismatches) certain data in other tables. Let's assume we want to DELETEdata from Source once its loaded into Target. DELETE FROM Source WHERE EXISTS ( SELECT 1 -- specific value in SELECT doesn't matter FROM Target ...

6 class Item { constructor(text, type) { this.text = text; this.emphasis = false; this.type = type; } toHtml() { return `<${this.type}>${this.emphasis ? '<em>' : ''}${this.text}${this.emphasis ? '</em>' : ''}</${this.type}...

In this example we will extract all the web links from a website. I am using http://stackoverflow.com/ for illustration. Here recursion is used, where each obtained link's page is parsed for presence of an anchor tag and that link is again submitted to the same function. The condition if(add &&...

SCSS syntax resembles more like a CSS syntax but SASS syntax is little bit different from SCSS but both produces exactly the same CSS code. In SASS we are not ending the style properties with semicolon(;) but in SCSS we are ending the style properties with (;). In SCSS we used paranthesis {} to ...

Pre-requisites AEM Installed on your server. Copy the path of the install (e.g: /mnt/crx) Start AEM (e.g java -jar cq-quickstart-author-p4502.jar) once. This will generate all the necessary folders, especially /mnt/crx/crx-quickstart/bin that is required by the scripts. Create a user who will h...

If we want to disable all the actions like Copy, Paste, Replace, Select, etc from UITextField then we can use following custom text field: class CustomTextField: UITextField { var enableLongPressActions = false required init(coder aDecoder: NSCoder) { super.init(coder: aDecoder)! } o...

Anonymous types provide a convenient way to encapsulate a set of read-only properties into a single object without having to explicitly define a type first. The type name is generated by the compiler and is not available at the source code level. The type of each property is inferred by the compiler...

Parameter TypesReturn TypeInterface()voidRunnable()TSupplier()booleanBooleanSupplier()intIntSupplier()longLongSupplier()doubleDoubleSupplier(T)voidConsumer<T>(T)TUnaryOperator<T>(T)RFunction<T,R>(T)booleanPredicate<T>(T)intToIntFunction<T>(T)longToLongFunction<T>(...

You can define a function to be recursive with the rec keyword, so it can call itself. # let rec fact n = match n with | 0 -> 1 | n -> n * fact (n - 1);; val fact : int -> int = <fun> # fact 0;; - : int = 1 # fact 4;; - : int = 24 You can also define mutually re...

Simple extract of index.html: <div class="sign-in"> {% if user %} [Passing the url we have the opportunity to logout the user] <a href="{{ url|safe }}">LOG OUT</a> [You can include here operations for user authenticated] ...

IMPORTANT!! Valet is a tool designed for macOS only. Prerequisites Valet utilizes your local machine's HTTP port (port 80), therefore, you will not be able to use if Apache or Nginx are installed and running on the same machine. macOS' unofficial package manager Homebrew is required to properly...

Md2Collapse : Collapse is a directive, it's allow the user to toggle visiblity of the section. Examples A collapse would have the following markup. <div [collapse]="isCollapsed"> Lorum Ipsum Content </div> Md2Accordion : Accordion it's allow the user to toggle vis...

Detailed instructions on getting avr set up or installed.

creating custom exception 'P2222': create or replace function s164() returns void as $$ begin raise exception using message = 'S 164', detail = 'D 164', hint = 'H 164', errcode = 'P2222'; end; $$ language plpgsql ; creating custom exception not assigning errm: create or replace function s...

Detailed instructions on getting greasemonkey set up or installed.

Function using promises: function myAsyncFunction() { return aFunctionThatReturnsAPromise() // doSomething is a sync function .then(result => doSomething(result)) .catch(handleError); } So here is when Async/Await enter in action in order to get clean...

Angular 2 wrapper library for Dropzone. npm install angular2-dropzone-wrapper --save-dev Load the module for your app-module import { DropzoneModule } from 'angular2-dropzone-wrapper'; import { DropzoneConfigInterface } from 'angular2-dropzone-wrapper'; const DROPZONE_CONFIG: DropzoneCon...

Intoduction Object Oriented Programming (mostly referred as OOP) is a programming paradigm for solving problems. The beauty an OO (object oriented) program, is that we think about the program as a bunch of objects communicating with each other, instead of as a sequential script following specific ...

`To calculate 1D convolution by hand, you slide your kernel over the input, calculate the element-wise multiplications and sum them up. The easiest way is for padding=0, stride=1 So if your input = [1, 0, 2, 3, 0, 1, 1] and kernel = [2, 1, 3] the result of the convolution is [8, 11, 7, 9, 4], whic...