Location based DB schema in mySQL

http://dev.mysql.com/tech-resources/articles/4.1/gis-with-mysql.html

http://dev.mysql.com/doc/refman/4.1/en/spatial-extensions.html

http://howto-use-mysql-spatial-ext.blogspot.com/

http://forge.mysql.com/wiki/GIS_Functions#Introduction

http://forums.mysql.com/read.php?23,40909,43079#msg-43079

OpenInviter

• Easy access to your visitors address book in all major email providers and social networks around the world.


• Completely painless and easy way of integrating in your website. It takes virtually not more than 5 minutes to have your own OpenInviter^TM up and running on your site.


• Constant updates so that you can sit back and relax and always have access to the latest ways to get your visitor's address book.


• WGET-ready! Yes, you read right! OpenInviter^TM is the only contacts importer supporting both WGET and cURL as methods of handling requests (since version 1.2) so now you can use it on ANY server you want without the hassle of installing libcurl!


• Real time access to the service statuses so you can know if there is an email provider that is not working right with OpenInviter^TM.

http://openinviter.com/faq.php

GO: Google Launches Its Own Programming Language

GO: Google Launches Its Own Programming Language

Posted using ShareThis

Upgrading mySQL from 5.0 to 5.1.on CentOS 5

My first attempt was to use yum:

[root@linux /] yum info mysql
Loading "fastestmirror" plugin
Loading mirror speeds from cached hostfile
* base: mirror.sanctuaryhost.com
* updates: mirror.fdcservers.net
* addons: mirror.steadfast.net
* extras: mirror.trouble-free.net
Installed Packages
Name   : mysql
Arch   : i386
Version: 5.0.45
Release: 7.el5
Size   : 7.3 M
Repo   : installed
Summary: MySQL client programs and shared libraries.
Description:
MySQL is a multi-user, multi-threaded SQL database server. MySQL is a
client/server implementation consisting of a server daemon (mysqld)
and many different client programs and libraries. The base package
contains the MySQL client programs, the client shared libraries, and
generic MySQL files.


Available Packages
Name   : mysql
Arch   : i386
Version: 5.0.77
Release: 3.el5
Size   : 4.8 M
Repo   : base
Summary: MySQL client programs and shared libraries
Description:
MySQL is a multi-user, multi-threaded SQL database server. MySQL is a
client/server implementation consisting of a server daemon (mysqld)
and many different client programs and libraries. The base package
contains the MySQL client programs, the client shared libraries, and
generic MySQL files.

The version 5.0.77 is good, but it not last updated release, which is 5.1.40 up today, which contains an important mysql feature named
Pationing: Enables distributing portions of individual tables across a file system, according to rules which can be set when the table is created. In effect, different portions of a table are stored as separate tables in different locations, but from the user point of view, the partitioned table is still a single table.

Basically it won’t do an upgrade as the vendor has changed from being MySQL to Sun Microsystems, and as a result I have to do a complete uninstall and re-install manually, first backup your data, stop mysql service and uninstall the current installation( 5.0.45 in my case):

[root@16 /]service mysqld stop
[root@16 /]rpm -qa | grep -i '^mysql-'
mysql-server-5.0.45-7.el5
mysql-5.0.45-7.el5
mysql-devel-5.0.45-7.el5
[root@16 /]rpm -e mysql-server-5.0.45-7.el5
[root@16 /]rpm -e mysql-5.0.45-7.el5
[root@16 /]rpm -e mysql-devel-5.0.45-7.el5

Now download all the current MySQL packages you need and install all with rpm -i( links from mySQL site):

[root@linux /usr/local/bin] mkdir mysql_5.1.40
[root@linux /usr/local/bin] cd mysql_5.1.40
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-server-community-5.1.40-0.rhel5.i386.rpm/from/http://mirror.mirimar.net/mysql/
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-client-community-5.1.40-0.rhel5.i386.rpm/from/http://mirror.mirimar.net/mysql/
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-shared-community-5.1.40-0.rhel5.i386.rpm/from/http://mirror.mirimar.net/mysql/
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-shared-compat-5.1.40-0.rhel5.i386.rpm/from/http://mirror.mirimar.net/mysql/
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-devel-community-5.1.40-0.rhel5.i386.rpm/from/http://mirror.mirimar.net/mysql/
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-embedded-community-5.1.40-0.rhel5.i386.rpm/from/http://mirror.mirimar.net/mysql/
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-test-community-5.1.40-0.rhel5.i386.rpm/from/http://mirror.mirimar.net/mysql/
[root@linux /mysql_5.1.40] rpm -i MySQL-shared-community-5.1.40-0.rhel5
[root@linux /mysql_5.1.40] rpm -i MySQL-embedded-community-5.1.40-0.rhel5
[root@linux /mysql_5.1.40] rpm -i MySQL-server-community-5.1.40-0.rhel5
[root@linux /mysql_5.1.40] rpm -i MySQL-client-community-5.1.40-0.rhel5
[root@linux /mysql_5.1.40] rpm -i MySQL-test-community-5.1.40-0.rhel5
[root@linux /mysql_5.1.40] rpm -i MySQL-devel-community-5.1.40-0.rhel5
[root@linux /mysql_5.1.40] mysql_upgrade
[root@linux /mysql_5.1.40] service mysql start
[root@linux /mysql_5.1.40] mysqladmin -V
 mysqladmin  Ver 8.42 Distrib 5.1.40, for pc-linux-gnu on i686

The Cloud Dilemma for Developers( From Tikal Community Event)

Introduction to Cloud Computing by Yanai Franchi



Google App Engine Intro By Andrew Skiba



Amazon AWS Case Study by: Dudi Landau , “Thomson Reuters", "ClearForest CTO”

Automated Deployment with Maven - going the whole nine yards

Check out this SlideShare Presentation:

Automated Deployment with Maven - going the whole nine yards

View more documents from wakaleo.

A Watercolor Film about the Evolution of Life

A Record Of Life from Owen Gatley and Luke Jinks on Vimeo.