Tutorial by Examples: t

FDW is an implimentation of dblink it is more helpful, so to use it: 1-Create an extention: CREATE EXTENSION postgres_fdw; 2-Create SERVER: CREATE SERVER name_srv FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'hostname', dbname 'bd_name', port '5432'); 3-Create user mapping for postgres...

When you try to restore database from another server you might get the following error: Error 3154: The backup set holds a backup of a database other than the existing database. In that case you should use WITH REPLACE option to replace database with the database from backup: RESTORE DATABAS...

What is retrofit? The official Retrofit page describes itself as: A type-safe REST client for Android and Java. This library makes downloading JSON or XML data from a web API fairly straightforward. Once the data is downloaded then it is parsed into a Plain Old Java Object (POJO) defined for ...

The Same Database reference allows you to split a single database into multiple projects. This is useful for cases where a project is very large or where different teams manage different parts of the database. If you consider that you have two .sqlproj SSDT database projects with the following stru...

productFlavors { // Define separate dev and prod product flavors. dev { // dev utilizes minSDKVersion = 21 to allow the Android gradle plugin // to pre-dex each module and produce an APK that can be tested on // Android Lollipop without time c...

I have previously written documentation on this site in order to describe how to make web services on Symfony I will write again a tutorial for the symfony >= 3 version. We think that we have a installed web-server on a configured version of Symfony Framework. You must have composer (php packag...

Prerequisites JDK 1.7 or later installed. You can find the Oracle JDK's here. Steps Download Payara Server Full. Unzip the Payara Server at some location on your computer. We will use C:\payara41 as INSTALL_DIR for Windows users and /payara41 for Linux/Mac users. Starting / stopping Pa...

Let's understand something. JavaEE consists of a number of specifications. When you install an Application Server (Payara for example), you install all of the specifications at once. For example there's a specification for an ORM called JPA (Java Persistence API), a specification to build Component ...

REPL stands for 'Read Evaluate Print Loop.' The REPL can be used to write and execute code one line at a time and is an alternative to writing code to a file and then compiling or interpreting the entire file before execution. To start the SMLNJ REPL from a command prompt: smluser> sml Standar...

(************************************************* * All comments in SML are block comments * Block Comments begin with '(*' * Block Comments end with '*)' * (* Block Comments can be nested *) * The additional framing asterisks at the beginning * and end of this block comment are common ...

(* The block comment syntax allows nested comments (* whether or not this is a good thing is probably a matter of personal opinion (*or coding standards*)*)*) val _ = print "Nested comment example\n" (* line ending block comment *)

The %>% operator can also be used to pipe the dplyr output into ggplot. This creates a unified exploratory data analysis (EDA) pipeline that is easily customizable. This method is faster than doing the aggregations internally in ggplot and has the added benefit of avoiding unnecessary intermediat...

All SML expressions return a value. The REPL stores the return value of the last evaluated expression. it provides the value of the last evaluated expression within the REPL. smluser> sml Standard ML of New Jersey v110.78 [built: Thu Jul 23 11:21:58 2015] - 3+4; val it = 7 : int - it; val i...

The stack is a LIFO (last-in, first-out) data-structure, i.e. the most recent (or "last in") element added to the stack will be the first element removed ("first out"). Let us consider the example of books in a box. Only one book can be added or removed from from the box at a ti...

Operators that bound tighter (higher precedence) are listed first. OperatorsPrecedence group (≥3.0)PrecedenceAssociativity.∞left?, !, ++, --, [], (), {}(postfix)!, ~, +, -, ++, --(prefix)~> (swift ≤2.3)255left<<, >>BitwiseShiftPrecedence160none*, /, %, &, &*MultiplicationPrec...

You could migrate from team foundation version control to git by using an open source tool called Git-TF. Migration will also transfer your existing history by converting tfs checkins to git commits. To put your solution into Git by using Git-TF follow these steps: Download Git-TF You can downloa...

program-one. FD important-file. 01 file-record. COPY record-layout. DATA DIVISION. 01 memory-record. COPY record-layout. PROCEDURE DIVISION. ... COPY record-move. ... COPY record-move. program-two. DATA DIVISION. 01 print-record. COPY record-lay...

Swarm Mode Node Availability: Active means that the scheduler can assign tasks to a node. Pause means the scheduler doesn’t assign new tasks to the node, but existing tasks remain running. Drain means the scheduler doesn’t assign new tasks to the node. The scheduler shuts down any existing ta...

To promote a node or set of nodes, run docker node promote from a manager node: docker node promote node-3 node-2 Node node-3 promoted to a manager in the swarm. Node node-2 promoted to a manager in the swarm. To demote a node or set of nodes, run docker node demote from a manager node: doc...

Worker Node: #Run the following on the worker node to leave the swarm. docker swarm leave Node left the swarm. If the node has the Manager role, you will get a warning about maintaining the quorum of Managers. You can use --force to leave on the manager node: #Manager Node docker swarm l...