Tutorial by Topics: o

Currently, reading all elements in JSON array is not possible in Redshift. For e.g. if you want to read Manufacturer and model as columns from following JSON dim_idnumberinfomanufacturermodel 2001Nissan~Sentra^Nissan~Maxima^Ford~Taurus^Ford~Escort^NissanSentra 2002Nissan~Sentra^Nissan~Ma...

Regular non-capturing groups allow the engine to re-enter the group and attempt to match something different (such as a different alternation, or match fewer characters when a quantifier is used). Atomic groups differ from regular non-capturing groups in that backtracking is forbidden. Once the gro...

The Qt Resource system is a way to embed files within your project. Each resource file can have one or more prefixes and each prefix can have files in it. Each file in the resources is a link to a file on the file system. When the executable is built, the files are bundled into the executable, so t...

You can use hierarchical queries to retrieve data based on a natural hierarchical relationship between rows in a table

Example of how to copy existing table structure with/without data CREATE TABLE schemaName.table AS (SELECT columns FROM schemaName.table) WITH DATA

This section provides an overview of what android-asynctask is, and why a developer might want to use it. It should also mention any large subjects within android-asynctask, and link out to the related topics. Since the Documentation for android-asynctask is new, you may need to create initial ...

Using SSIS to extract data from a CSV file and insert into a SQL Server table

This topic is going to focus on the A* Pathfinding algorithm, how it's used, and why it works. Note to future contributors: I have added an example for A* Pathfinding without any obstacles, on a 4x4 grid. An example with obstacles is still needed.

A field formatter specifies the way a field is rendered in Drupal templates. The formatter used by each field can be configured in the Manage display tab associated with the entity type that you are configuring. Fields can have different formatters depending on the view mode that is being displayed...

This section provides an overview of what corona is, and why a developer might want to use it. It should also mention any large subjects within corona, and link out to the related topics. Since the Documentation for corona is new, you may need to create initial versions of those related topics....

A UIStoryboard object encapsulates the view controller graph stored in an Interface Builder storyboard resource file. This view controller graph represents the view controllers for all or part of your application’s user interface.

Internationalization (i18n) and Localization (L10n) are used to adapt software according to differences in languages, regional differences and target audience. Internationalization : the process of planning for future localization i.e. making the software design flexible to an extent that it can ad...

Sometimes your SSH session stops responding. You can easily get out of that session using the following trick.

Recording test scenarios is one of the most convenient ways to create test scripts. This is because test recordings let you mimic realistic user workflows, instead of having to manually create a test script. The recordings capture all browser requests to the web application, and then automatically c...

Pharo provides an excellent way to combat complexity in software development. With its fast feedback with instantaneous compilation of the currently edited method, its objects all the way from compiler to the run-time stack, and tools designed to be customizable by the individual developer, it s...

Interface can't be implemented with pointer receivers because *User is not User

This section provides an overview of what mocha is, and why a developer might want to use it. It should also mention any large subjects within mocha, and link out to the related topics. Since the Documentation for mocha is new, you may need to create initial versions of those related topics. ...

Fitting a line (or other function) to a set of data points.

You use analytic functions to determine values based on groups of values. For example, you can use this type of function to determine running totals, percentages, or the top result within a group. FIRST_VALUE ( scalar_expression ) OVER ( [ partition_by_clause ] order_by_clause [ rows_range_cl...