Article Network

Querying and Selecting Data

by Eric Pimpler | April 2013 | Cookbooks

Selecting features from a geographic layer or rows from a standalone attribute table is one of the most common GIS operations. Queries are created to enable these selections, and can be either attribute or spatial queries. Attribute queries use SQL statements to select features or rows through the use of one or more fields or columns in a dataset. An example attribute query would be "Select all land parcels with a property value greater than $500,000". Spatial queries are used to select features based on some type of spatial relationship. An example might be "Select all land parcels that intersect a 100 year floodplain" or perhaps "Select all streets that are completely within Travis County, Texas". It is also possible to combine attribute and spatial queries. An example might be "Select all land parcels that intersect the 100 year floodplain and have a property value greater than $500,000".

In this article by Eric Pimpler, author of Programming ArcGIS 10.1 with Python Cookbook, we will cover the following recipes:

  • Constructing proper attribute query syntax

  • Creating feature layers and table views

  • Selecting features and rows with the Select Layer by Attribute tool

  • Selecting features with the Select by Location tool

  • Combining spatial and attribute queries with the Select by Location tool

Read Querying and Selecting Data in full

Querying the Data Grid in Coherence 3.5: Obtaining Query Results and Using Indexes

by Aleksandar Seovic Mark Falco Patrick Peralta | April 2010 | Oracle

In a previous article we covered working with value extractors and simplifying queries in Oracle Coherence 3.5. We will take the discussion further by seeing how to obtain query results. We will also talk about indexes and the impact they have on query performance.

In this article by Aleksandar Seovic, Mark Falco and Patrick Peralta, authors of Oracle Coherence 3.5, we will cover:

  • Obtaining query results
  • Using indexes to improve query performance
  • Coherence query limitations
Read Querying the Data Grid in Coherence 3.5: Obtaining Query Results and Using Indexes in full

Questions & Answers with Inkscape's Alexandre Prokoudine

by | March 2011 | Open Source Web Development

Believe in Open Source

Alexandre Prokoudine

 

 

 

 

 

Alexandre Prokoudine - Alexandre has been involved with the Inkscape project since 2004 as a Russian translator, and later as technical support team member and website maintainer. Professionally Alexandre specializes in documentation, software localization and internationalization which he's been doing for numerous free graphic design and sound tools since early 2000s. Alexandre is currently employed by ALT Linux and works on educational projects.

 

Read Questions & Answers with Inkscape's Alexandre Prokoudine in full

Questions & Answers with MariaDB's Michael "Monty" Widenius- Founder of MySQL AB

by | April 2011 | MySQL Open Source Web Development

Believe in Open Source

 

 

 

 

Michael “Monty” Widenius

Michael “Monty” Widenius - Monty was the Main Developer of the MySQL database and the Founder of MySQL AB. Currently he is the CEO of Monty Program, a company founded by him. Monty Program is a center of engineering excellence for a database server called MariaDB, the Aria storage engine, MySQL®, and other associated technologies.

Monty is also a partner in the venture capital company Open Ocean. Monty’s experience and knowledge is highly regarded, which has resulted in many board memberships. He is currently active in the board of IT Mill Ltd, Finsor, Web of Trust by Against Intuition Inc. and several others.

 

 

 

 

Read Questions & Answers with MariaDB's Michael "Monty" Widenius- Founder of MySQL AB in full

Questions & Answers with Sencha's James Pearce

by | April 2011 | AJAX Open Source Web Development

Believe in Open Source

 

 

 

 

James Pearce

James Pearce - James is a technologist, writer, developer & practitioner who has been working with the mobile web for over a decade. He is Senior Director of Developer Relations at Sencha. Previously he was the CTO at dotMobi and has a background in mobile startups, telecoms infrastructure and management consultancy. He speaks extensively on the topic of mobile web development, and has written books for both Wiley and Wrox.

James led the development of mobiForge, DeviceAtlas and ready.mobi, and is the creator of tinySrc, the WordPress Mobile Pack, WhitherApps, modernizr-server and confess.js.





Read Questions & Answers with Sencha's James Pearce in full

Quick start

by Limoke Oscar | May 2013 | Web Development

In this article by Limoke Oscar, authors of Instant Google Map Maker Starter [Instant], we will show you how to perform one of the core tasks of Google Map Maker—mapping the places you love and know. Follow the steps to create your own map features, which will be the basis of most of your work in Google Map Maker.

Read Quick start in full

Quick start - creating your first application

by Gabriel Manricks | August 2013 | Open Source Web Development

In this article created by Gabriel Manricks, the author of Instant Meteor JavaScript Framework Starter, we will learn how to create your first application using Meteor Javascript Framework.

Read Quick start - creating your first application in full

Quick start - your first Sinatra application

by Joe Yates | August 2013 | Open Source Web Development

This article created by Joe Yates author of Instant Sinatra Starter [Instant], puts together the basics of a simple address book application and deploy it. We'll be handling requests and returning a dynamically created page.

Read Quick start - your first Sinatra application in full

Quick Start into Selenium Tests

by Unmesh Gundecha | May 2013 | Open Source

In this article by Unmesh Gundecha, author of Instant Selenium Testing Tools Starter, we will show you how to record a test using Selenium IDE. During the recording, we will add some additional commands to the test and run the recorded test.

A test is a basic building block in Selenium IDE. It contains commands for navigation, test steps, and checks for expected versus the actual state of the application. In this article we will show you how to create your first test and execute this test with Selenium IDE.

Read Quick Start into Selenium Tests in full

Quick start – creating your first grid

by Gabriel Manricks | July 2013 | Open Source Web Development

In this article by Gabriel Manricks, author of Instant jqGrid, we will learn how to customize jqGrid and set it up the way you like. There is a little bit of tweaking necessary in order to customize jqGrid and get it set up the way you like. The good news is, you can use that folder as a template and every time you want to make a new project with jqGrid you can just make a copy of that folder.

Read Quick start – creating your first grid in full

Quick start – Creating your first Java application

by Vivek Mishra | August 2013 | Open Source

In this article created by Vivek Mishra, the author of Instant Apache Cassandra for Developers Starter, we will discuss about the Cassandra storage architecture and its different components, followed by the Cassandra query language (CQL) command-line exercises.

Read Quick start – Creating your first Java application in full

Quick start – creating your first template

by Gabriel Manricks | November 2013 | Open Source Web Development

In this article by Gabriel Manricks, author of the book Instant Handlebars.js, we will learn how to create template. Let's start from the beginning. The purpose of using a templating engine such as Handlebars is to generate some kind of viewable content (usually HTML pages), dynamically. This encompasses a really broad range of uses, from e-mail newsletters, web apps, and really any other kind of output format around.

In this quick start, we will take a brief look at the process of creating a template with both placeholders and helper tags, and then how to run and output the contents to the page.

Read Quick start – creating your first template in full

Quick start – Firebug window overview and inspecting

by Chandan Luthra | March 2013 | Open Source Web Development

Firebug is not about fixing the bugs and tweaking CSS (cascade style sheet), it consists of many tools that can be of great help to a web developer and designer. Firebug is similar golf club bag. Each club (panel) in Firebug is a powerful weapon for web developers. Like a golf player, a web developer has to choose a club (panel) for different situations.

In this article by Chandan Luthra, the author of Instant Firebug Starter, we will learn

  • Console panel

  • HTML panel

  • CSS panel

  • Script panel

  • DOM panel

  • Net panel

  • Cookies panel

Read Quick start – Firebug window overview and inspecting in full

Quick start – media files and XBMC

by Charles McColm | August 2013 | Open Source

This article by Charles McColm, the author of Instant XBMC , covers the quick start of XMBC. XBMC can be set up to look up the metadata for movies, television shows, music videos, and music; but before lookups are possible, XBMC needs a way to recognize what to look up. For movies, music, and television shows XBMC uses the filename and date as a basis for the lookup. Music needs to be tagged properly with a tag editor for XBMC to be able to understand what to look up. You also need a way to get your media files from your computer to your XBMCbuntu system. We'll be sending files over a network using FileZilla, an FTP/SFTP program, and by using Samba (drag-and-drop) shares. Lastly, we'll add your copied data to your movie, TV show, or music library.

Read Quick start – media files and XBMC in full

Quick start – Monitoring hosts and services

by Michael Guthrie | June 2013 | Linux Servers Networking & Telephony Open Source

In this article by Mike Guthrie, author of Instant Nagios Starter, we will see how to monitor hosts and services. The logic of Nagios as a monitoring engine is determined by a set of object configuration files, which are located under the etc directory of the Nagios tree. For a source installation, this directory is located at /usr/local/nagios/etc. From the configuration files in this directory, Nagios knows what to monitor, when to monitor, who to notify, and how to respond to events. Interaction with these files is required in order to set up monitoring with Nagios, so understanding how to work with them is essential. This article will be an introduction to the basics of adding new hosts, services, contacts, and templates. A complete reference for all the Nagios configuration files is available in the Nagios core manual on sourceforge.net, and it is by far the best reference for a complete understanding of Nagios configuration files. It can be found at the following link:

http://nagios.sourceforge.net/docs/3_0/

Read Quick start – Monitoring hosts and services in full

Quick start – Using Burp Proxy

by Luca Carettoni | September 2013 | Open Source Web Development

In this article by Luca Carettoni, author of Instant Burp Suite Starter, we will give you a sneak peek into using Burp Proxy, Burp Proxy is a crucial component of the entire Burp Suite. This tool allows you to intercept the web traffic between the browser (client) and the target application (server). Thanks to the setup described in the previous section, we are now able to look under the hood and discover how web applications work.

Read Quick start – Using Burp Proxy in full

Quick start – using Foundation 4 components for your first website

by Carlos Azaustre Jorge Arévalo | October 2013 | Open Source Web Development

Foundation 4 provides a set of UI elements to construct our websites. In this article by Jorge Arévalo and Carlos Azaustre, the authors of the book Instant Zurb Foundation 4, we will show you how to use some of them in our websites. Specifically, we will see the following two elements:

  • The Grid
  • The navigation Bar
  • Buttons
Read Quick start – using Foundation 4 components for your first website in full

Quick start – using Haml

by Krzysztof Niksiński | September 2013 | Open Source

In this article by Krzysztof Niksinski, the author of Instant Haml, we will look into a few steps in using Haml.

Read Quick start – using Haml in full

Quick start – Using the core Puppet resource types

by Jo Rhett | May 2013 | Open Source

This article by Jo Rhett, author of Instant Puppet 3 Starter, will show you how to use the core resource types included within Puppet to reduce the amount of manual work and rework you do every day. By the end of this section, you'll have puppet maintaining some services in your system.

Read Quick start – Using the core Puppet resource types in full

Quick start – writing your first MDX query

by Nicholas Emond | September 2013 | Enterprise Articles Microsoft

In this article by Nicholas Emond, the author of the book Instant MDX Queries for SQL Server 2012, it is explained that a MDX query is coded and executed against a cube to have a result in a specific format return to the client application.

Read Quick start – writing your first MDX query in full
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software