Tutorial by Examples: g

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

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

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

A regex in Notepad++ may have as many capture groups as desired. (one)(two)(three)...(nine)(more than nine groups!)... Anonymous capture groups use the standard syntax: (group) Named capture groups may use either of following syntax formats: (?<name>group) (?'name'group) Anonymo...

It's entirely possible to use PICO-8 as an interactive shell, but you probably want to tap into the game loop. In order to do that, you must create at least one of these callback functions: _update() _update60() (after v0.1.8) _draw() A minimal "game" might simply draw something on...

If you want a title screen or an endgame screen, consider setting up a mode switching mechanism: function _init() mode = 1 end function _update() if (mode == 1) then if (btnp(5)) mode = 2 elseif (mode == 2) then if (btnp(5)) mode = 3 end end function _draw() cls() ...

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

A package is a folder that can contain anything that is listed in these examples (and other thing that can have nothing to do with Sublime Text 3, such as a gulpfile.js if you're automating some tasks). You can install any package using the create Package Control. A .sublime-package ? Maybe you'v...

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

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

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

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