Tutorial by Examples: ti

To create a new empty database, run as postgres-user: createdb [yourdatabase] Connect to the database with a psql-session: psql -d [yourdatabase] In the psql-session run: CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology; to create the neccesary geospatial extensions. Once thi...

Bullet This one particularly blew my mind. The bullet gem helps you kill all the N+1 queries, as well as unnecessarily eager loaded relations. Once you install it and start visiting various routes in development, alert boxes with warnings indicating database queries that need to be optimized will p...

In this example we will set up a geospatial database, import data from 2 different sources, and view the results in an application called QGIS. This guide is explicitly written for linux-machines, if you operate on another platform, some commands or paths might not work as expected. In order to vie...

Typically we represent an anary tree (one with potentially unlimited children per node) as a binary tree, (one with exactly two children per node). The "next" child is regarded as a sibling. Note that if a tree is binary, this representation creates extra nodes. We then iterate over the s...

The settings, are, as many things on Sublime Text 3, simple JSON files. Though, the extension of the file isn't .json but .sublime-settings. As you probably understood, the settings changes how the packages affects Sublime Text 3. It is important to be aware of as much settings as possible to optimi...

In order to keep track of your projects' file structure, Atom, like many text editors and IDEs, uses a file tree model. These trees show the locations and names of your files and directory. To toggle the tree between visible and hidden, the keys Ctrl+\ may be used (⌘+\ for Mac OS). This tree also in...

TypeScript supports interfaces, but the compiler outputs JavaScript, which doesn't. Therefore, interfaces are effectively lost in the compile step. This is why type checking on interfaces relies on the shape of the object - meaning whether the object supports the fields and functions on the interfac...

const { remote } = require("electron"); // <- The Node.js require() function is // added to JavaScript by electron function setProgress(p) { // p = number from 0 to 1 const currentWindow = remote.getCurrentWindow(); currentWindow.setProgre...

const { remote } = require("electron"); // <- The Node.js require() function is // added to JavaScript by electron function fullscreen(f) { // p = false or true const currentWindow = remote.getCurrentWindow(); currentWindow.maximize(); } ...

Query to search last executed sp's in db SELECT execquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROM sys.dm_exec_query_stats AS execquery CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql ORDER BY execquery.last_execution_time DESC Query to search thro...

//Using statement for ExcelTable and TableStyles using OfficeOpenXml.Table; //Defining the tables parameters int firstRow =1; int lastRow = worksheet.Dimension.End.Row; int firstColumn = 1; int lastColumn = worksheet.Dimension.End.Column; ExcelRange rg = worksheet.Cells[firstRow, firstCol...

Asterisk is an open source framework for building communications applications. You can use it for any of the following: IP PBX systems VoIP gateways ISDN/ 3G IVVR Here is a brief instruction for step by step installation of asterisk 1.8(or you can do for latest versions) on Redhat/centos (fo...

To use standard location services while the application is in the background you need first turn on Background Modes in the Capabilities tab of the Target settings, and select Location updates. Or, add it directly to the Info.plist. <key>NSLocationAlwaysUsageDescription</key> <st...

While the basic invocation above is easy enough, the curses package provides the wrapper(func, ...) helper function. The example below contains the equivalent of above: main(scr, *args): # -- Perform an action with Screen -- scr.border(0) scr.addstr(5, 5, 'Hello from Curses!', curses...

Detailed instructions on getting ssrs-2008 set up or installed.

This installation assumes hadoop to be pre-installed under hadoop user. Prerequisites: Hue depends on these following packages gcc g++ libxml2-dev libxlst-dev libsasl2-dev libsasl2-modules-gssapi-mit libmysqlclient-dev python-dev python-setuptools libsqlite3-dev ant libkrb5-dev libt...

Detailed instructions on getting installshield set up or installed.

$FirstName = 'Bob' Export-ModuleMember -Variable FirstName To export a variable from a module, you use the Export-ModuleMember command, with the -Variable parameter. Remember, however, that if the variable is also not explicitly exported in the module manifest (.psd1) file, then the variable wil...

Create separate files for header and footer(as they are common for all the pages and it does not make sense to make them a part of a single page) Keep common elements(Like Search/Back/Next etc) in separate file(The idea is to remove any kind of duplication and keeping the segregation logical) Fo...

//Add a List validation to B column. Values should be in a list var val = worksheet.DataValidations.AddListValidation("B:B"); //Shows error message when the input doesn't match the accepted values val.ShowErrorMessage = true; //Style of warning. "information" and "warn...