|
Tutorial: MySQL Select statement |
 vote
 |
|
An in-depth look at the syntax of the MySQL Select statement...
The SELECT statement is without question the most complex amongst MySQL’s data manipulation statements. Not surprising when you consider that the foremost purpose of structured query language (SQL) is to retrieve information from a relational database which adheres to a given criteria. Entire books have been written about how to construct a query to fetch the data that you’re after. That’s not the purpose of this article. Our goal will be to cover the syntax of the SELECT statement and gain an understanding of its many optional clauses. We’ll start at the beginning and work our way through them. When we’re done, you’ll understand which clauses to use for different purposes. We’ll leave the twenty table joins for another day. read more... |
|
| | mail this link | permapage | score:9979 | -Ray, August 31, 2010 |
|
Bazaar: A Powerful source control system |
 vote
 |
|
| Bazaar is used to produce the Ubuntu Linux distribution, which is an enormous software project with thousands of components. If you're using a UNIX or Linux system, chances are that your distribution offers a pre-built Bazaar package. Bazaar is flexible enough to accommodate Subversion - a centralized system and Git - a decentralized system. This article introduces you to Bazaar's many appealing features. read more... |
|
| | permapage | score:9945 | -solrac, August 20, 2010 |
|
Learn FC++: The C++ functional programming library |
 vote
 |
|
| C++ is usually synonymous with object-oriented programming (OOP), and further replenished in no small measure by popular technical literature. This article tries something different—functional programming with C++ using the open source FC++ library from Yannis Smaragdakis and Brian McNamara. Learn how you can use FC++ to implement basic functional programming. read more... |
|
| | permapage | score:9895 | -solrac, August 18, 2010 |
|
Continuous integration with Buildbot |
 vote
 |
|
| The days of cowboy coding are long gone at most organizations, replaced by a renewed interest in generating quality software. Continuous integration (CI) testing is a vital component in the practice of agile programming techniques that lead to high-quality software. Learn the theory and practice of CI testing by exploring Buildbot, an open source CI system written in Python. read more... |
|
| | permapage | score:9864 | -solrac, August 2, 2010 |
|
Faster Ruby on Rails |
 vote
 |
|
| Ruby on Rails, a popular Web development framework based on the Ruby programming language, makes it easy to access your database, but it does not always do so efficiently. Learn more about common performance problems with Rails, including N+1 query, and discover how you can fix them. read more... |
|
| | permapage | score:9861 | -solrac, July 30, 2010 |
|
Python Client/Server Tutorial |
 vote
 |
|
A tiny Python tutorial...
This application can easily be coded in Python with performance levels of thousands of transactions per second on a desktop PC. Simple sample programs for the server and client sides are listed below, with discussions following read more... |
|
| | permapage | score:9844 | -Ray, June 22, 2009 |
|
Tutorial: Build a Real-Time web tool with jQuery, XMPP and PHP |
 vote
 |
|
| Real-Time apps have been popularized by social-notification tools like Twitter and Friendfeed. With a Real-Time web app you can get website information as soon as it's published. Learn techniques that allow you to create responsive, continually updated web applications that conserve server resources while providing a slick user experience using jQuery, XMPP and PHP. read more... |
|
| | permapage | score:9821 | -solrac, August 1, 2010 |
|
Tutorial: Linux Dialog Boxes |
 vote
 |
|
Dialog lets you create dialog boxes from Unix/Linux shell scripts...
'dialog' is a utility for building console-based 'front ends' in UNIX like operating systems.
In this brief tutorial I am mentioning the usage of few important basic controls available with this 'dialog' utility and later I have created a very simple front end application in UNIX bash scripting using dialog. read more... |
|
| | permapage | score:9811 | -Ray, January 1, 2010 |
|
Learn HTML5 with these quick coding examples |
 vote
 |
|
| In HTML5 Tip-1 you learn about the File API and how to drag & drop hard drive files to a webpage. In HTML5 Tip-2 you code using ContentEditable and LocalStorage to create a web sticky note. In HTML5 Tip3 you will learn how to code geolocation for the iPhone. In HTML5 Tip-4 learn how easy it is to code drag and drop. read more... |
|
| | mail this link | permapage | score:9806 | -solrac, August 4, 2010 |
|
Create a new GIMP tool |
 vote
 |
|
| The GNU Image Manipulation Program (GIMP) is a robust application for editing and manipulating digital images. In this article, you will learn how to get started with the GIMP code, how to build the project from the Git repositories, and how to find your way around the code tree. And you will build an example application that creates a whole new painting tool for the program. read more... |
|
| | permapage | score:9786 | -solrac, July 22, 2010 |
|
Create mobile Web apps with HTML5 |
 vote
 |
|
HTML 5 is a very hyped technology, but with good reason. It promises to be a technological tipping point for bringing desktop application capabilities to the browser. In this five-part series, you will take a closer look at several new technologies that are part of HTML5, that can have a huge impact on mobile Web application development.- Part 1: Combine HTML5, geolocation APIs, and Web services to create mobile mashups
- Part 2: Unlock local storage for mobile Web applications with HTML5
- Part 3: Make mobile Web applications work offline with HTML5
- Part 4: Using Web Workers to speed up your mobile Web applications
- Part 5: Develop new visual UI features in HTML 5
|
|
| | mail this link | permapage | score:9784 | -solrac, July 15, 2010 |
|
Perl tips |
 vote
 |
|
Ten perl one-liner tips and tricks...
The core of any perl one-liner is the -e switch, which lets you pass a snippet of code on the command-line:
perl -e 'print "hi\n"' prints "hi" to the console.
The second standard trick to perl one-liners are the -n and -p flags. Both of these make perl put an implicit loop around your program, running it once for each line of input, with the line in the $_ variable. -p also adds an implicit print at the end of each iteration. read more... |
|
| | mail this link | permapage | score:9783 | -Ray, June 1, 2010 |
|
Build Java apps with Apache Click |
 vote
 |
|
| Get introduced to Apache Click, a Java EE Web application framework that enables the creation of Web applications without using MVC patterns or JSP. This article provides examples of displaying a simple Web page and creating a Web form that submits data that is displayed on a different Web page. read more... |
|
| | permapage | score:9776 | -solrac, January 29, 2010 |
|
Build an Android Twitter app with XML and JavaScript Object Notation |
 vote
 |
|
| This article, explores techniques for handling two of the most common data formats used on the Internet — XML and JavaScript Object Notation (JSON)— on the Android platform. Learn the basics of XML and JSON and how to build an Android application that parses and displays a Twitter status-update in both formats. read more... |
|
| | permapage | score:9738 | -solrac, July 21, 2010 |
|
Linux core files |
 vote
 |
|
| Core dumps are often used to diagnose or debug errors in Linux or UNIX programs. Core dumps can serve as useful debugging aids for sys admins to find out why Application like Lighttpd, Apache, PHP-CGI or any other program crashed. Many vendors and open source project author requests a core file to troubleshoot a program. A core file is generated when an application program abnormally terminates due to bug, operating system security protection schema, or program simply try to write beyond the area of memory it has allocated, and so on. This article explains how to turn on core file support and track down bugs in programs. read more... |
|
| | mail this link | permapage | score:9727 | -nixcraft, June 18, 2010 |
|
Java performance profiling |
 vote
 |
|
| Blaming bad code won't help you find performance bottlenecks and improve the speed of your Java apps, and neither will guessing. This article directs your attention to tools for Java performance monitoring, Here's five tips for using Java 5's built-in profiler, JConsole, to collect and analyze performance data. read more... |
|
| | permapage | score:9724 | -solrac, July 11, 2010 |
|
Scripting: Bash Array Tutorial |
 vote
 |
|
An excellent introduction to bash arrays including 15 examples...
$ cat arraymanip.sh #! /bin/bash Unix[0]='Debian' Unix[1]='Red hat' Unix[2]='Ubuntu' Unix[3]='Suse'
echo ${Unix[1]}
$./arraymanip.sh Red hat read more... |
|
| | permapage | score:9721 | -Ray, June 7, 2010 |
|
Tutorial: Linux game programming with Ogre 3D |
 vote
 |
|
This tutorial starts at the beginning with opening a window...
This tutorial series steps you through the process of creating a 3D shoot'em'up game using the popular and powerful Ogre 3D engine. The tutorials compile on both Windows and Linux. read more... |
|
| | permapage | score:9709 | -Ray, January 1, 2010 |
|
Building a simple Ajax rating system |
 vote
 |
|
| We all love to rate stuff. I think it must be part of our DNA. My daughter and I like to go to the movies; while she used to like them all before, she's much pickier now that she's four. I've taught her to use the "thumbs up" and "thumbs down" rating system à la Ebert and Roeper. (She gave Shrek III a thumbs up.) I think this is why rating and reviewing things like products or articles on the Internet is so popular. This article shows how to use a combination of MySQL, PHP, Prototype.js, and Ajax to add simple rating and comment functionality to any site. read more... |
|
| | mail this link | permapage | score:9702 | -solrac, August 4, 2007 |
|
|