Tutorial by Examples: in

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

The basic example Open routes/web.php file and paste the following code in file: Route::get('helloworld', function () { return '<h1>Hello World</h1>'; }); here 'helloworld' will act as page name you want to access, and if you don't want to create blade file and still want to ...

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

Backreferences "Backreferences" are references in a search regex to capture groups in the same search regex. The "search regex" is the regex used in the "Find" field of the Find/Replace dialog box. Here is the most common backreference syntax: Absolute: (group one)...

Although it's not officially supported, you can use mouse input in your games: function _update60() x = stat(32) y = stat(33) if (x>0 and x<=128 and y>0 and y<=128) then -- left button if (band(stat(34),1)==1) then ball_x=x ball_y=y...

Plugins are .py files that changes the behaviour of Sublime Text 3. They are written, as you probably guessed, in Python. Because there is plenty of different sort of plugins (text manipulation, linting, formatting, preview, etc), we will not give any example to not over populate this page with a h...

Along with other more advanced text editors, Atom allows developers to open a single file or a directory. Opening Files To open files with Atom, either use File > Open File... in the menu as show below: or use the faster keyboard shortcut: Ctrl+O (For Mac OS: ⌘+O). This will open a file expl...

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

<table> <thead> <th>Name</th> <th>Index</th> </thead> <tbody> <tr *ngFor="let hero of heroes"> <td>{{hero.name}}</td> </tr> </tbody> </tabl...

The primary reason to use interfaces to achieve polymorphism and provide developers to implement on their own way in future by implementing interface's methods. Suppose we have an interface and three classes: interface Connector{ doConnect(): boolean; } This is connector interface. Now we...

Requirements Windows 10, please set your system locale to English, otherwise there may be errors Visual Studio 2013 or 2015 QtWebEngine 5.7 source code (could be downloaded from here) Qt 5.7 install version, install it and add qmake.exe folder to system path Python 2, add python.exe folder to...

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

Switch to the new opened tab. Close the current windows(In this case the new Tab). Switch back to first window. PROTRACTOR: browser.getAllWindowHandles().then(function (handles) { browser.driver.switchTo().window(handles[1]); browser.driver.close(); browser.driver.switchTo().window(...

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

GTM simplifies the whole process of managing tags.In GTM terminology We put a GTM javascript snippet on the concerned page,in portal_normal.vm in custom theme in liferay, containing the GTM id and a data layer structure(if needed) to map values from page to variables Corresponding to data layer ...

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