Archive for the ‘SQL’ Category

Getting Started with Amazon's EC2 Cloud

Yesterday I did a quick review of the various cloud offerings from Amazon. Previous to that I had done a review of using S3, the Amazon storage service, with Mac OS X, primarily through the lens of using S3 as a destination for Final Cut Server archives. Today I’m going to go ahead and look [...]

Moodle Security

Moodle is a popular Course Management Solution (CMS) that is typically deployed in a less-than-secure manner. This is an issue with any system, but in a number of schools it can cause some pretty serious problems given the penchant that students have to muck with things. In the broader technology certification world it can be [...]

Posted on February 9, 2009 at 1:40 pm by admin · Permalink · Leave a comment
In: Mac OS X Server, Mac Security, SQL · Tagged with: , ,

Viral Marketing

Is it possible that a client can build a Facebook app, deploy it and not tell anyone, yet get so much traffic on the app that we have to add a second server within 6 hours?  Yes.  Is it then possible to quickly prop up an Apache cluster, forklift the data in there, throw together [...]

Posted on June 10, 2008 at 2:06 am by admin · Permalink · Leave a comment
In: SQL, Unix · Tagged with: , , ,

Mac OS X: MAMP

MAMP provides a portable LAMP-style environment for the Mac.  Easy to move stuff around, easy to use MySQL and Apache.  And can take your Apache 1.x environment in Tiger to an Apache 2.x environment.

Posted on December 27, 2007 at 5:18 pm by admin · Permalink · Leave a comment
In: Mac OS X, Mac OS X Server, Mac Security, SQL, sites · Tagged with: , , , ,

Other Uses for Boolean

So there are actually 3 possible uses for Boolean variables in many cases.  The first two are the traditional True/False aspects.  The third though is null.  So for example, rock paper and scissors.  Rock can be true, paper can be false and scissors can be null.  Could help to cut way down on lookup times [...]

Posted on October 18, 2007 at 2:59 pm by admin · Permalink · Leave a comment
In: SQL · Tagged with: ,

MySQL: Allow Incoming Access

Edit the user record in the mysql.user table, giving it access to connect to the mysql server from an external host by running the following command at the MySQL interface grant all privileges on *.* to ‘user’@’IPADDRESS’ identified by ‘password’ with GRANT OPTION; specify the user, IPADDRESS and password you’d like to use in that [...]

Posted on July 23, 2007 at 12:02 pm by admin · Permalink · Leave a comment
In: SQL · Tagged with: 

Setting up MySQL Clustering with UltraMonkey

http://www.howtoforge.com/loadbalanced_mysql_cluster_debian

Posted on February 3, 2007 at 3:59 pm by admin · Permalink · Leave a comment
In: SQL, Ubuntu, Unix · Tagged with: , , ,

Defining Web 2.0

I originally posted this at http://www.318.com/TechJournal Chances are, with all of the hubbub surrounding overnight success giants MySpace.com and Flickr, you’ve undoubtedly heard about the second coming of the internet, commonly referred to as “Web 2.0” . Bloggers are frequently commenting on “Wiki” this and “tagging” that. But what is this Web 2.0 phenomenon and [...]

Posted on February 28, 2006 at 1:42 am by admin · Permalink · Leave a comment
In: SQL, Social Networking, WordPress, sites · Tagged with: ,