Archive for June, 2006

Offload scripting to SQL

Wednesday, June 28th, 2006

Databases are still an intrical part of any project, be it web or desktop. But more commonly developers are using the main language of choice for sorting out simple database queries. Most databases today are SQL-based and they support SQL the language in some format. It is common practice today to use simple SQL-queries to receive large amounts of data and sort through and present results using the main-language of choice for the project. Sorting through large results of data can become very combersome and resource-wasteful. The alternative is using SQL more to sort-out the data and present more accurate results. SQL is a powerful scripting language which can handle more of the scripting that the main-language of choice. This is more commonly occurring in projects that are web-based, using languages like ASP or PHP. But even higher-up languages like Python, Perl and Ruby can receive the advantage of using more thoughtful SQL-scripted queries. For Ruby, research ‘nested :include clause’. For all others look into the basics using MySQL.

Web-API’s, free-services that help promote your business

Wednesday, June 21st, 2006

Offering web-API’s is a standard, and offering a wide-variety is becoming the new standard.

API (Application Programming Interfaces) offer a free service too any user (usually subscription-based) via web.
Examples of web-API’s:

  1. Google Maps
  2. UPS shipping
  3. FedEx shipping
  4. Flickr
  5. Yahoo! Traffic – text service

What are the advantages of these API’s? Your service can now be distrubted widely across the net with little effort on your part. Google Maps was developed so loosely that any site could use this service and customize it enough to make it work design-wise in any site (not flash sites though). Their brand “Google Maps” is now pasted on millions of sites without any effort on their part, besides developing this service. example: click here
Google Maps also quickly became the standard for mapping, replacing MapBlast and Mapquest, because their service was so prolific.
If you are interested in developing an API for a service your company could offer, or would like more information on integrating an API into your site, contact Muller Digital directly.

Is your site indexed on search-engines?

Monday, June 12th, 2006

Google sometimes has problems indexing a site correctly. Or they may not be indexing your site at all.

How do you know if your site is indexed? MarketLeap has a wicked tool to help show how many pages have been indexed by what search engines: MarketLeap.com index tool. If HotBot has 100 and Google has 30 and MSN has 1,000, then you have a problem when it comes to Google. Note: MSN usually has a very high indexing number.

If you are unsatisfied with the level Google has indexed your site, there are ways to rectify this issue. Please contact Muller Digital directly for more information.

OSX – CUPS (Common UNIX Printing System), Web-interface

Friday, June 9th, 2006

If you are on OSX… click here

Welcome to CUPS web interface. Where you can monitor your print jobs, view your printers, administer print jobs, view past print jobs and so much more.

Save on Microsoft Office Licenses, use Open Office

Thursday, June 8th, 2006

OpenOffice, is a FREE office suite that has all the main features of Microsoft Office.

Download: OpenOffice

The OpenOffice suite consists of the following applications:

  1. Writer – MS Word
  2. Impress – Powerpoint
  3. Calc – Excel
  4. Base – Access
  5. Math – No Microsoft Office equivilent
  6. Draw – No Microsoft Office equivilent

There is even a preference feature in OpenOffice which allows you to save all files in their Microsoft Office equivilent format by default. So there is no messy mix-up between formats between Microsoft Office users and OpenOffice users.

All OpenOffice applications have a very similar look and layout to their Microsoft Office counterparts. So it feels like you didn’t switch!

Microsoft Office 2007 does offer a palithera of applications for business.
Download Microsoft Office 2007 Beta for FREE
They have done an outstanding job with meeting the advanced business users needs. So for more intense, specific-need and high-end business applications, Microsoft is the only solution. BUT… for the majority of average users in an office environment, OpenOffice is a solution that will save money.