Tutorial by Examples: omp

Example of a complex SQL with Common Table Expression

Suppose we want to query the "cheapest products" from the "top categories". Here is an example of query using Common Table Expressions -- all_sales: just a simple SELECT with all the needed JOINS WITH all_sales AS ( SELECT product.price as product_price, category.id a...

SQL • Common Table Expressions

Organizing Component Layout

Adding components one after another results in a UI that's hard to use, because the components all are somewhere. The components are ordered from top to bottom, each component in a separate "row". To remedy this and provide you as developer with a possibility to layout components easily S...

swing • Using Swing for Graphical User Interfaces

Compact a Mongo Database on an Ubuntu Box

Preallocation. Mongo sets aside disk-space in empty containers, so when the time comes to write something to disk, it doesn't have to shuffle bits out of the way first. It does so by a doubling algorithm, always doubling the amount of disk space preallocated until it reaches 2GB; and then each preal...

meteor • Mongo Database Management

Show a git branch using PROMPT_COMMAND

If you are inside a folder of a git repository it might be nice to show the current branch you are on. In ~/.bashrc or /etc/bashrc add the following (git is required for this to work): function prompt_command { # Check if we are inside a git repository if git status > /dev/null 2>&a...

Bash • Customizing PS1

Convert NSDate that is composed from hour and minute (only) to a full NSDate

There are many cases when one has created an NSDate from only an hour and minute format, i.e: 08:12 The downside for this situation is that your NSDate is almost completely "naked" and what you need to do is to create: day, month, year, second and time zone in order to this object to &quo...

Objective-C Language • NSDate

D3.js component with ReactJS

This example is based on a blog post by Nicolas Hery. It utilizes ES6 classes and ReactJS's lifecycle methods to keep the D3 component updated d3_react.html <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>Hello, d3React!</title>...

d3.js • Using D3 with other frameworks

Compiling on Ubuntu

To build vim from source on Ubuntu: Get a copy of the source code by downloading from the official Vim repository on GitHub. Get the dependencies by running $ sudo apt-get build-dep vim-gnome or similar. Go to the directory of the Vim source code: cd vim/src Run $ ./configure. You can customiz...

vim • How to Compile Vim

Comparison Operators

OperatorDescription==true if the two values are equal.!=true if the two values are not equal.<true if the value of the operand on the left is less than the value on the right.>true if the value of the operand on the left is greater than the value on the right.>=true if the value of the oper...

Ruby Language • Operators

Adding Material Design AlertDialog to your app using Appcompat

AlertDialog is a subclass of Dialog that can display one, two or three buttons. If you only want to display a String in this dialog box, use the setMessage() method. The AlertDialog from android.app package displays differently on different Android OS Versions. The Android V7 Appcompat library pro...

Android • Dialog

Sorting a list with custom comparator

List.sortWith allows you to sort lists with data of any shape - you supply it with a comparison function. compareBools : Bool -> Bool -> Order compareBools a b = case (a,b) of (False, True) -> LT (True, False) -> GT _ -> ...

Elm Language • Lists and Iteration

Standard user-defined literals for complex

C++14 Those following complex user literals are declared in the namespace std::literals::complex_literals, where both literals and complex_literals are inline namespaces. Access to these operators can be gained with using namespace std::literals, using namespace std::complex_literals, and using nam...

C++ • User-Defined Literals

With Stanford CoreNLP, from Python

You first need to run a Stanford CoreNLP server: java -mx4g -cp "*" edu.stanford.nlp.pipeline.StanfordCoreNLPServer -port 9000 -timeout 50000 Here is a code snippet showing how to pass data to the Stanford CoreNLP server, using the pycorenlp Python package. from pycorenlp import Stanf...

nlp • Sentence boundary detection in Python

Compound

db.people.createIndex({name: 1, age: -1}) This creates an index on multiple fields, in this case on the name and age fields. It will be ascending in name and descending in age. In this type of index, the sort order is relevant, because it will determine whether the index can support a sort opera...

MongoDB • Indexes

Compiling and Running the Sample Programs

The NVIDIA installation guide ends with running the sample programs to verify your installation of the CUDA Toolkit, but doesn't explicitly state how. First check all the prerequisites. Check the default CUDA directory for the sample programs. If it is not present, it can be downloaded from the offi...

cuda • Getting started with cuda

__cplusplus for using C externals in C++ code compiled with C++ - name mangling

There are times when an include file has to generate different output from the preprocessor depending on whether the compiler is a C compiler or a C++ compiler due to language differences. For example a function or other external is defined in a C source file but is used in a C++ source file. Since...

C Language • Preprocessor and Macros

Enable Compression (Apache 2.0+)

Enabling gzip compression can reduce the size of the transferred response by up to 90%, which can significantly reduce the amount of time to download the resource, reduce data usage for the client, and improve the time to first render of your pages. — PageSpeed Insights Compression can be ena...

Hypertext Access file • Speed Optimization

Simple example using web-component-tester

installing npm install web-component-tester --save-dev setting up wct.conf.js module.exports = { verbose: true, plugins: { local: { browsers: ['chrome'] } } }; running node node_modules/web-component-tester/bin/wct test/index.html <html...

polymer • Unit Testing

Computed Observables

Computed observables are functions that can "watch" or "react" to other observables on the view model. The following example shows how you would display the total number of users and the average age. Note: The example below can also make use of pureComputed() (introduced in v3....

knockout.js • Getting started with knockout.js

Logging complex messages (efficiently)

Let's look at a sample of logging which you can see in many programs: public class LoggingComplex { private static final Logger logger = Logger.getLogger(LoggingComplex.class.getName()); private int total = 50, orders = 20; private String username = "Bob";...

Java Language • Logging (java.util.logging)

Option Compare {Binary | Text | Database}

Option Compare Binary Binary comparison makes all checks for string equality within a module/class case sensitive. Technically, with this option, string comparisons are performed using sort order of the binary representations of each character. A < B < E < Z < a < b < e < z ...

VBA • VBA Option Keyword