MySQL Query Browser, one of the open source MySQL GUI tools from MySQL AB, is used for building MySQL database queries visually. In MySQL Query Browser, you build database queries using just your mouse—click, drag and drop!
When you’re creating a query for non-technical users and you don’t want them to see the complexity of the query, you can create a view from the query. Your users can then use the view as a table; for example, they can double-click the view, which will effectively execute its complex query behind the scene.
In MySQL Query Browser, you have two ways to create a view, which Djoni Darmawikarta will demonstrate in this article:
- From an existing query
- Writing from scratch manually
Once we have the data view firmly embedded in our page, it is a breeze to change the way the data looks and operates. In this article by Mike Poole, we will learn to apply nice formatting to data that is displayed on our page. We will learn to do this by making use of Cascading Style Sheets. We will also learn how to format our data automatically, depending on the data values (a technique known as conditional formatting). Then we will learn to filter and sort our data, use formulae to perform calculations, and how to split our data up into multiple pages.Read SharePoint: Displaying Data in full
JMeter is a 100% pure Java desktop application. JMeter is found to be very useful and convenient in support of functional testing. Although JMeter is known more as a performance testing tool, functional testing elements can be integrated within the Test Plan, which was originally designed to support load testing. Many other load-testing tools provide little or none of this feature, restricting themselves to performance-testing purposes. Besides integrating functional-testing elements along with load-testing elements in the Test Plan, you can also create a Test Plan that runs these exclusively. In other words, aside from creating a Load Test Plan, JMeter also allows you to create a Functional Test Plan. This flexibility is certainly resource-efficient for the testing project.
In this article by Emily H. Halili, we will give you a walkthrough on how to create a Test Plan as we incorporate and/or configure JMeter elements to support functional testing.Read Functional Testing with JMeter in full
The phrase "Content is King" may seem like rather an old cliché now, but it still rings true—content is king. In this article by Paul Thewlis, we will look at issues surrounding content creation, and discuss some techniques and methods to help you produce the best content you can. We will discuss some general writing tips for bloggers. Although you may be familiar with some of these already, it is to re-focus your attention on them and ensure that you are applying them as a part of your blogging routine.Read Writing Tips for Bloggers in full
Liferay Portal is one of the most mature portal frameworks in the market and offers many benefits. Liferay is backed by a comprehensive professional services network and it offers custom development, training, and support across the world.
As the world's leading open source portal platform, Liferay provides a unified web interface to data and tools scattered across many sources. Within Liferay portal, a portal interface is composed of a number of portlets—self contained interactive elements that are written to a particular standard. Since portlets are developed independently of the portal itself, and loosely coupled with the portal, they are apparently SOA (Service-Oriented Architecture).
Jonas X. Yuan will show how to set up a Liferay portal and then how to configure it.Read Setting up and Configuring a Liferay Portal in full
Knowing different languages is always an added advantage. If our website is able to communicate with people of different languages, globally the popularity of the website would go up. With Moodle, we have the option of making our site more interactive as it offers support for different languages. In this article by William Rice, we will see how to configure different languages on our Moodle website and also look at some of the available language settings.Read Languages and Language Settings in Moodle in full
As noted in Part 1, OLAP presents Business Intelligence via what is known as a CUBE. A Cube has many dimensions and it provides a faster method to access the intelligence compared to the structured querying where the overhead of 'Joins' makes it inefficient. Taking the example of a 'Sales' Cube having everything related to sales we can identify the dimensions as the Sales Outlet, The Customers , the Products and the time period over which sales are being audited or looked into. We also notice that there are certain measures that we are interested related to these 'dimensions' like 'Store Sales', 'Cost of Products, 'number of units sold' etc. The Analysis Services analyzes these intricate relationship that exist in a cube. In this part we will see the process of creating a Cube in VS 2008.Read Creating an Analysis Services Cube with Visual Studio 2008 - Part 2 in full
It is always necessary to have a Help section in our software application. When users do not find a way out from a specific problem in our application, it is the help section they turn to. Hence it is important that the help feature is well maintained and without any errors. In this article by Tim Lavers and Lindsay Peters, we will see the errors that can occur in our help section and how to test the help section.Read Testing a HELP System in a Java Application in full
The installation of Joomla! is a matter of five minutes. If you have installed it before, you can do it in two minutes. In order to be able to even start the installation, your development environment must include a web server that supports PHP and a database that is supported by Joomla!. Joomla! is one piece of the puzzle in this so-called Client-Server System. This topic is very complex, since there is an unmanageable number of providers and an even more unmanageable combination of installed Apache, PHP, and MySQL versions and Webspace administration tools such as Visas and Plesk.
In this article by Hagen Graf, we focus on the following points:
- A PHP safe mode, possibly activated in the php.ini
- Prohibited conversion of URLs with Apache because of the non-activation of the so called rewrite engine
- Directory rights in Linux that are set differently than in Windows
JBoss jBPM is a free, open-source, business process management solution. It enables users to create business processes that coordinate people, applications, and services. JBoss jBPM is an Integrated Development Environment (IDE) , which is based on another open-source tool, Eclipse, which is widely used for Java development. The JBoss jBPM IDE gives us not only our graphical process modeler, but can also generate the workflow user interface for us. In this article by Matt Cumberlidge, we will explain the concepts or the key terms in JBoss jBPM. We will also look at jBPM Process Definition Language (jPDL).Read JBoss jBPM Concepts and jBPM Process Definition Language (jPDL) in full
Most web applications have rather simple error handling strategy. When an error occurs, the script terminates and an error page is presented. The error should be logged in the error log, and the developers or maintainers should check the logs periodically. In this article by Dennis Popel, we will look through the most common sources of errors in database-driven web applications.
- Server software failure or overload such as the famous "too many connections" error
- Inappropriate configuration of the application, which may happen when we use an incorrect connection string, a rather common mistake when an application is moved from one host to another.
All web applications and web servers have security vulnerabilities and there is every chance that our website will be compromised. Most web hosts have their own backup procedures in place, but it is not uncommon for a web host to become victim to an attack, and have problems with a small percentage of its customer backups. Because of this it is very important that we keep backups of our website. In this article by Michael Peacock, we will see how to backup our website and restore it back gain from our backup.Read Backing Up and Restoring TYPO3 Websites in full
A cube in the context of Business Intelligence is a multidimensional representation of business facts that can be accessed quickly to provide specific information. (This can be accomplished by properly written queries in a relational database, but the overhead involved in processing the query, which may involve a large number of 'joins', is simply not efficient). While a relational model is more suited to OLTP, a different model is necessary for OLAP. Whereas highly normalized tables are a norm for OLTP, the model for OLAP does not require normalization. The SQL Server Analysis Services that supersedes the earlier versions is specifically meant for analyzing data in the archives or in OLTP databases to be retrieved and burnished to provide the 'Intelligence' by mining for facts hidden in the data. This two part article by Dr. Jayaram Krishnaswamy describes how a Cube is designed using Visual Studio 2008 and how it may be browsed on the Analysis Server. In Part 1, the necessary items for creating the Cube, namely the Data Source and Data Source Views are described.Read Creating an Analysis Services Cube with Visual Studio 2008 - Part 1 in full
One of the most interesting extensions to the standard mail setup is that of virtualization. In this article by Kyle Wheeler, let's see the many reasons for wanting to virtualize email services, from hosting multiple domains with different users to simply extending the ability to apply policies to different sets of email. There are three basic techniques that are used with a standard qmail system for attaining different forms of virtualization: qmail's control/virtualdomains file, user-definable address extensions, and running multiple qmail instances on the same system.Read Qmail Quickstarter: Virtualization in full
Blender is an open source, cross platform suite of tools for 3D creation, capable of modeling, rendering, and animating 3D environments. Since Blender is completely free, everyone can download and use it immediately in commercial projects. It's not a shareware with limited tools, or time constraints; you can use it freely. In the past few years, the Blender user base has grown significantly. One of the positive aspects of Blender is its size—it is only 10 MB and we can even run it directly from a portable drive. Another great aspect of Blender is that we can use various Operating Systems such as Linux, Windows, and Mac OS X, leaving us the choice of which one to use.
Packt spokesperson Meeba Abraham approached Allan Brito at the heart of this movement to understand his take on the future of Blender.Read Blender 3D: Interview with Allan Brito in full