MySQL introduced cursor in its release 5. You create a cursor to define a set of rows from one or more table that you want to access row-by-row sequentially. If your need is really to access the rows one at a time then use cursor. But a lot of data processing is actually set processing, and set processing is what relational database is best for.
This article by Djoni Darmawikarta compares cursor approach and set approach using various examples.Read Comparing Cursor and Set Approaches in Processing Relational Data in full
Voice Internet Protocol (VoIP) Telephony refers to the technology used for making telephone calls over the Internet. The two major technologies used to implement VoIP telephony are Asterisk and OpenSER. This article by Flavio E. Goncalves compares Asterisk and OpenSER topic by topic and shows the differences between them.Read Comparing Asterisk and OpenSER in full
In this article by Gaurav Vaish, author of Getting Started with NoSQL, we will do a comparative study of the various products available in the market for implementing NoSQL—both open source as well as commercial.
Specifically, we compare the following products:
Amazon SimpleDB: http://aws.amazon.com/simpledb
Google Datastore: http://developers.google.com/appengine
This article is structured such that we first explore each point for comparison and then compare it across the products.Read Comparative Study of NoSQL Products in full
In this article, by Gorgi Kosev and Mite Mitreski, the authors of HTML5 Data and Services Cookbook, we're going to cover the following topics:
In this Article, we're going to cover the following topics:
- Creating an HTTP GET request to fetch JSON
- Creating a request with custom headers
- Versioning your API
- Fetching JSON data with JSONP
- Reading XML data from the server
- Using the FormData interface
- Posting a binary file to the server
- Creating an SSL connection with Node.js
- Making real-time updates with Ajax Push
- Exchanging real-time messages using WebSockets
This article deals with the communication between the client and the server. The recipes in this article describe how to use the JPA in the server side and Data Transfer Objects (DTO) in the client side. It discusses how the GWT RPC mechanism allows the server and the client to pass Java objects back and forth.
In this article by Shamsuddin Ahammad, author of Google Web Toolkit 2 Application Development Cookbook, we will cover:
- Creating DTO classes
- Mapping entity classes and DTOs
- Creating a GWT RPC service
- Defining an RPC method to persist an object
- Calling an RPC method from a client UI
One can imagine many scenarios where Dynamics CRM either publishes data to BizTalk Server or queries BizTalk-exposed service endpoints. For instance, when a customer requests a refund for a defective product, the call center agent may record this request in Dynamics CRM. After the phone call is over, Dynamics CRM should send a message to a returns processing system which handles the crediting of a customer's account. In another scenario, BizTalk Server may be the host of a data aggregation service which queries three enterprise systems that store "customer" data and aggregates the responses. Dynamics CRM may want to execute that service when a call center agent views a customer record so that they get a fuller picture of that customer's interactions with the company.
In this article by Richard Seroter, author of Microsoft BizTalk 2010: Line of Business Systems Integration, we will see how Dynamics CRM sends data to BizTalk Server.Read Communicating from Dynamics CRM to BizTalk Server in full
In the previous part of this artice by Florian Rommel, we discussed software toolkits for your DCs and administration and diagnosing AD problems. In this part, things included are monitroing your AD with two utilities: Sonar and Ultrasound.Read Common Recovery Tools in Active Directory: Part 2 in full
Some of the things we will go through in this two-part article by Florian Rommel maybe not exactly be a requirement for the recovery process, but would still be useful to know and easier to understand when referenced.
In this part, things include what specific toolkits you should have installed, or at least have ready to be installed, on your DCs. We will also look at some tools for diagnosing problems, such as DcDiag.exe and NetDiag.exe to how you can use them to try and fix small issues.
We will first start with the software toolkits.Read Common Recovery Tools in Active Directory: Part 1 in full
In this article by Amit Daliot, the author of Instant Axure RP Starter [Instant], we will learn how to prototype some commonly used UI design patterns using the key features of Axure. Axure prototyping enables you to create accurate, high fidelity mockups of applications and web services quickly and with no coding skills. By the end of this article, you will be able to work more efficiently with Axure and will be able to deliver detailed designs much faster.
Read Common design patterns and how to prototype them in full
In this article by Steve Liles, the author of Asynchronous Android, we will take a look at AsyncTask which was introduced in Android at API level 3, Cupcake, with the express purpose of helping developers to avoid blocking the main thread. The Async part of the name of this class comes from the word asynchronous, which literally means not occurring at the same time. AsyncTask is an abstract class, and as such, must be subclassed for use. At the minimum, our subclass must provide an implementation for the abstract doInBackground method, which defines the work that we want to get done off the main thread.
As with any powerful programming abstraction, AsyncTask is not entirely free from issues and compromises.Read Common AsyncTask issues in full
This article by Jonas X.Yuan, author of Liferay Portal Systems Development will introduce user management and password policy first. Then it will address authentication and authorization. LDAP and SSO integration will be introduced afterwards. Tracking and auditing services API will be addressed in detail after this. Finally, it will address scripting engine, polling, web services, WSRP, and the OSGi framework.
By the end of this article, you will have learned about the following:
- User management
- Password policy
- Authentication and authorization
- LDAP and SSO
- Tracking and auditing
- Rules engine and reporting engine
It can be difficult to combine multiple different frameworks into the same solution while working with new technologies. This article will focus on how to combine Silverlight 4, Windows Azure, and a WCF 4.0 (Windows Communication Foundation) service together.
In this article by David Burela, author of Microsoft Silverlight 5 and Azure Enterprise Integration, we will discuss the following topics:
- Combining Silverlight and Windows Azure projects
- Consuming an Azure-hosted WCF service within a Silverlight application
- Configuring the number of web roles
Panda3D is a free and open source game engine. It has been used successfully by hobbyists as well as big studios to create games ranging from quick prototypes to full-scale commercial MMOs. Panda3D makes it easy to use models, textures, and sounds to create impressive interactive experiences. With this article, you too will be able to leverage the full power of the Panda3D engine.
In this article by Christoph Lang, author of Panda3D game developer’s cookbook, we will cover:
- Using the built-in collision detection system
- Using the built-in physics system
- Using the ODE physics engine
- Using the PhysX physics engine
- Integrating the Bullet physics engine
Collaborative work is an important topic at present. Many large projects are now being developed in a collaborative way. But this was not always easy for the developer. When many developers are working together on large projects, each developer must have a well-known area of work, and each developer must make sure that he doesn't interfere with the work of the other developers.
Without tools such as SVN or Git, large projects like jQuery or Linux Mint could not be possible. The developers of all these projects are distributed all over the world and they often work in different time zones and have different ways of working, but in the end all the parts are merged into one great project in SVN or Git.
So, SVN and Git are a great enrichment for all developers and essential for the fast progress of large web projects.
In this article by Thomas Deuling the author of Aptana Studio Beginner's Guide, we will take a look at how easy it is to work with SVN and Git in Aptana Studio.Read Collaborative Work with SVN and Git in full
Alfresco Share offers a number of such features out-of-the-box. These are features that ensure effective task management. These are completely customizable if need be. The numerous technologies and tools that Alfresco supports ensures that no, or minimal, change be made to the enterprise's existing infrastructure.
Enterprises have a number of tasks that require its people to be able to effectively manage their tasks and schedules. For the purpose of managing intra- and inter-team events, a variety of collaboration tools like calendars, forums, and so on are available. More often than not, there are tools independent of each other, or they may not be compatible with existing systems that are in place.
In this article by Pallika Majmudar, co-author of Alfresco Share, we shall understand the various collaborative features like wiki, blogs, data lists, calendar, discussions, and lists features that Share has on offer.
By the end of this article, you will have learned about:
- Wiki pages and blogs in Share
- Managing data lists
- Creating events in Alfresco Share
- Effective collaboration through discussions
- Managing and creating data lists
Read Collaboration Features in Alfresco Share in full
This article deals with AJAX programming in ColdFusion. ColdFusion acts a great platform not just because of its code features, but because of its characteristics as to how the code interacts with other features. ColdFusion is a language with depth and power. Yet, as we developers know, it seems real power always requires a bit of custom code. In this article by John Farrar, we will have a look at the following topics:
- Proxy connections
- JSON features
- Spry data integration
In this article by John Farrar, author of ColdFusion 9 Developer Tutorial, we will learn to move forward from making our code work to making it interesting to write and reuse. We could call this a "power CFC". Power is doing away with the old practice of copying and pasting code again and again with some minor edits in the pasted code. Here, we will learn to reuse the CFC code to make it much simpler. CFCs are the object-packaging method used in ColdFusion. Database interaction is quite universally wrapped in CFCs. We will look at database interaction as our primary example of power CFCs in the context of working with "web forms". If you are new to development, then these concepts will make it easy for you. Here is an overview of what this article contains:
- The practice of protecting access to CFC methods
- The working of web forms
- Managing multiple products through common forms for listing, editing, and adding data
- Improving the page flow, also known as work flow
- Returning messages to the user to know things are working
- Learning the power of inheritance
- Simplifying by passing array collections, rather than manual line-by-line passing of the variable values
ColdFusion 8 is arguably one of the most significant releases of the product since ColdFusion MX (6.0) first graced our servers in 2002. The release brings with it long awaited image manipulation tags and functions. Built-in AJAX integration makes it easier to create "Web 2.0" applications. Compared to previous releases, it's also wicked fast. Given the significance of these new features, it may be easy to overlook some of the enhancements that have found their way into ColdFusion 8. In this article by Charlie Griefer, we will look into the some of the enhancements to existing features and functionality that you may have missed.Read ColdFusion 8-Enhancements You May Have Missed in full
This article by Daniel Bates, author of Instant Minecraft: Pi Edition Coding How-to, will guide you through to the point where you have Python code interacting with Minecraft: Pi Edition. We will walk through the steps required to connect to the game and post a chat message. Many more features are available once connected, some of which are covered at the end of this article.Read Coding with Minecraft in full