Tutorial by Topics: a

MySQL offers FULLTEXT searching. It searches tables with columns containing text for the best matches for words and phrases. FULLTEXT searching works strangely on tables containing small numbers of rows. So, when you're experimenting with it, you may find it helpful to obtain a medium-sized ta...

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

Pygame is the go-to library for making multimedia applications, especially games, in Python. The official website is http://www.pygame.org/. pygame.mixer.init(frequency=22050, size=-16, channels=2, buffer=4096) pygame.mixer.pre_init(frequency, size, channels, buffer) pygame.mixer.quit() pyg...

The cut command is a fast way to extract parts of lines of text files. It belongs to the oldest Unix commands. Its most popular implementations are the GNU version found on Linux and the FreeBSD version found on MacOS, but each flavor of Unix has its own. See below for differences. The input lines a...

In order to use custom tags in JSP,we used to have TLD files,along with a Java class to define the custom tags but post JSP 2.0 specs,the same can be achieved,without the need for any Source code files,making it easy to maintain and it can also be created by someone with basic knowledge of JSP tags ...

This tutorial covers all the necessary steps required to upload an iOS app to the App Store.

This topic contains information about working with columns and rows, like resizing, hiding, autofit

Pivot table is one kind of interactive table, which can be used to calculate data, such as get sum or count data. Also, users can change pivot table layout for analyzing data with different ways or reassign row/column label. Every time users change layout, data will be recalculated in pivot table. ...

This topic explains how the WinForms engine works to display forms and how you control their lifetimes.

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...

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 ...

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

Cancelling an AsyncTask

An Interface is a way to define a set of behaviors that a class will perform. The definition of an interface is a list of method signatures (name, parameters, and return type). A class having all of the methods is said to "implement" that interface. In VBA, using interfaces lets the compi...

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

There is a built in easy way to read files in binary within VBA, however it has a restriction of 2GB (2,147,483,647 bytes - max of Long data type). As technology evolves, this 2GB limit is easily breached. e.g. an ISO image of Operating System install DVD disc. Microsoft does provide a way to overco...

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.