-
Posted: December 30th, 2011, 6:00am MST
Being by far the most popular open source RDBMS available to date, MySQL offers a wealth of engaging facilities that make it stand out from its closest competitors. A stable, reliable performance, solid support for ACID transactions and multiple storage engines, foreign keys handling and cascade operations are only a small part of the tremendous menu of features that the database server offers for free. These have, not surprisingly, contributed to extending its existing popularity even further over time. Among other features, MySQL includes a powerful privilege administration module. It lets y...
-
Posted: December 28th, 2011, 6:00am MST
Let's be honest: how many times have you found yourself writing a custom static helper class, or putting your hands eagerly on one that came bundled with a framework, from the many available out there? If you're anything like me, the answer will be at least Â
a few (remember that the first step to healing is admitting you have a problem). Static helpers seem to be a great idea at first glance, as they're reusable components that don't require any kind of expensive instantiation for doing common tasks, such as determining base URLs and paths or validating incoming data. But the sad and unavoid...
-
Posted: December 26th, 2011, 6:00am MST
The enhanced technology and functionality now shipping in smartphones, tablets, and other portable devices has allowed their popularity to skyrocket with consumers seeking solutions for productivity and entertainment on the go. App developers have noticed this demand and have responded by equipping mobile apps with a variety of functions that were typically associated with desktop environments, such as news, audio, video, gaming, and much more. While it's no surprise that developers are creating apps to coincide with the needs of consumers, the pace at which apps are entering the market is s...
-
Posted: December 23rd, 2011, 6:00am MST
Let's be honest: unless you're a multifaceted, good-at-everything web developer, with skills that go beyond the boundaries of (X)HTML, CSS, JavaScript and the server-side language of your choice, most of the time you'll be reluctant to deal with the oddities of MySQL. With lots of frameworks and libraries that will do the leg work for you and handle the interaction with the database server, you'd rarely need to spend your valuable time diving into its lower-level features. After all, that's what systems administrators are for, right? While the actual tasks you'll be performing with MySQL will ...
-
Posted: December 21st, 2011, 6:00am MST
Constructing purely static helper classes can hurt you, especially when you're trying to build applications that adhere to the principles of good object-oriented programming. As I explained extensively in the first part of this tutorial, static helpers are inflexible structures that can only be extended via Inheritance, and that don't exploit the benefits of Polymorphism or dependency injection. Naturally, the most educational way to learn why static helpers (or any other kind of static class, of course) should be replaced with instantiable classes is through some concrete, easy-to-foll...
-
Posted: December 19th, 2011, 6:00am MST
Approximately 2,800 adults over the age of 18 were surveyed by Harris Interactive on behalf of mobile ad provider Pontiflex during November. 958 of the participants identified themselves as smartphone owners, while another 257 were tablet owners. According to the online survey, only 3 percent of the participants said they frequently used an app that they had installed to receive an incentive. While it's not surprising that few participants used their incentivized apps on a frequent basis, the percentage is so low that it really calls into question the quality and worth of such apps, particu...
-
Posted: December 13th, 2011, 10:26pm MST
Cashton Coleman, SuccessBricks' President and CEO, as well as creator of ClearDB, said: We are pleased to now offer ClearDB as a powerful add-on for Heroku customers. It has been a pleasure to work with the Heroku team, and we're excited to bring our game-changing MySQL database service to Heroku customers. quot; The result of over four years of research and development by the SuccessBricks team, ClearDB allows its users to maintain a database connection in the event of sudden and widespread internet outages, which alone should attract many Heroku developers. SuccessBricks claims ClearDB is...
-
Posted: December 12th, 2011, 9:30am MST
System-Level Program Execution Truly lazy programmers know how to make the most of their entire server environment when developing applications, which includes exploiting the functionality of the operating system, file system, installed program base, and programming languages whenever necessary. In this section, you'll learn how PHP can interact with the operating system to call both OS-level programs and third-party installed applications. Done properly, it adds a whole new level of functionality to your PHP programming repertoire. Done poorly, it can be catastrophic not only to your applica...
-
Posted: December 9th, 2011, 8:37am MST
Eric Chu, director of Android's developer ecosystem, described the recent success, stating: One billion is a pretty big number by any measurement. However, when it's describing the speed at which something is growing, it's simply amazing. Perhaps the main factor behind Android's success is the fact that the platform now offers so many smartphones and tablets under its umbrella. Several big name manufacturers have stood behind the platform and are releasing Android-based products at a rapid pace. Google claims that over 200 million Android devices have been sold, while there is an average ...
-
Posted: December 8th, 2011, 9:30am MST
Let's face it: building a full-featured ORM in PHP (or in any other programming language) is a challenging and difficult process that requires careful planning. You'll need a solid background in some popular data persistence patterns, such as Active Record and Data Mapper. That's a tall order, especially since this kind of package must be able to handle all of the possible relationships between the objects that compose an application, not to mention the validation that must be performed on them. Fortunately, there's a healthy variety of ORMs available that will do the hard work for you. What's...
-
Posted: December 7th, 2011, 7:30am MST
Writing to a File This section highlights several of the functions used to output data to a file. fwrite() int fwrite (resource handle, string string [, int length]) The fwrite() function outputs the contents of string to the resource pointed to by handle. If the optional length parameter is provided, fwrite() will stop writing when length characters have been written. Otherwise, writing will stop when the end of the string is found. Consider this example: lt;?php $subscriberInfo = quot;Jason Gilmore|wj@example.com quot;; $fh = fopen( quot;/home/www/data/subscribers.txt quot;, quot;at ...
-
Posted: December 4th, 2011, 11:07pm MST
I've written extensively about Safari Books Online in the past. Six articles in total at this point, and yet somehow, as I delve deeper into the company's repertoire of goodies, I keep uncovering new things to discuss. To me, this speaks volumes not only about the depth of their product, but also about the flexibility and ingenuity of their offerings. I've covered the basic offerings: books, technical articles, and search capabilities. I've spoken to the cross-platform agility of their mobile and tablet apps. And in the last article, I took you inside their video vault, a treat for those visua...
-
Posted: December 2nd, 2011, 8:15am MST
CyanogenMod's distinction as aftermarket firmware designed for Android smartphones allows it to supply users with enhanced features. The team behind the firmware has been recently working on CyanogenMod 9, a version based on Ice Cream Sandwich's open source code which Google released during the middle of November. As of right now, owners of the Samsung Nexus S can make use of an alpha version of CyanogenMod 9, while Samsung Galaxy S owners can try out a beta version. Users and developers have given mostly positive feedback on the CyanogenMod releases thus far, with only a few MMS bugs and o...
-
Posted: December 1st, 2011, 6:00am MST
As its name would suggest, TroSQL Free 1.10 helps to boost productivity for both small businesses and large organizations at no cost. It's also a useful tool understanding and learning how databases work. The release is just another in a line of products from TROSYS that gives clients the power to maximize efficiency in the realms of MySQL database and server management, product development, debugging, resource optimization, and more. Besides its distinction as a free tool, TroSQL is highlighted by a plethora of features, beginning with compatibility. The program ships as a small EXE that i...