Oleksandr Serhiienko sigerello

Different services I can suggest when a non-tech friend or family member asks me how they can cheaply make a website and possibly use it to sell stuff online.

Website Hosting

Railties 3.1 RC4

The new rake task assets:clean removes precompiled assets. [fxn]
Application and plugin generation run bundle install unless --skip-gemfile or --skip-bundle. [fxn]
Fixed database tasks for jdbc* adapters #jruby [Rashmi Yadav]
Template generation for jdbcpostgresql #jruby [Vishnu Atrai]

GeoPlanet data with ancestor chain cache imported in 10 minutes

Yahoo! provides its GeoPlanet data as three separate TSV files, available for download here.

That's a database with some 17 million records:

5.7 million records: locations (aka places).
2.2 million records: alternative names for each place (aka aliases).
9.6 million records: matrix of neighbourhoods per place (aka adjacencies).

How to install MongoDB 2.0 on Mac OS X (>= Leopard)

Procedure

The whole install procedure is like the following.
You would have to do 7 steps.

Download the latest tar file, and expand it.
Move it to /usr/local/, and make a symbolic link to the folder.
Add path to MongoDB binaries.
Make an user that "mongod" runs on, and group that owns the user.

	<?php

	function DB($query)
	{
	static $db = null;
	static $result = array();

	if (is_file($query) === true)
	{
	$db = new PDO('sqlite:' . $query, null, null, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));

	<!-- layout file -->
	<% if current_user %>
	Welcome <%= current_user.username %>. Not you? <%= link_to "Log out", logout_path %>
	<% else %>
	<%= link_to "Sign up", signup_path %> or <%= link_to "log in", login_path %>.
	<% end %>

	require "test/unit"

	Module.send :include, Module.new {
	def test(name, &block)
	define_method("test_#{name.gsub(/[^a-z0-9]/i, "_")}".to_sym, &block)
	end
	alias :should :test
	}

	module NumericTests

	/**
	* InputTextMask script used for mask/regexp operations.
	* Mask Individual Character Usage:
	* 9 - designates only numeric values
	* L - designates only uppercase letter values
	* l - designates only lowercase letter values
	* A - designates only alphanumeric values
	* X - denotes that a custom client script regular expression is specified</li>
	* All other characters are assumed to be "special" characters used to mask the input component.
	* Example 1:

	var movementHistory = {
	pointAndTimeHistory: [],
	set: function(point) {
	// add this point into the point and time history for velocity calculations based on time & distance
	this.pointAndTimeHistory.push({
	time: new Date().getTime(),
	x: point.x,
	y: point.y
	});

	Found this tip in comment here: http://www.tipb.com/2011/01/04/tipb-bug-home-button-working-iphone/

	1.) Open any application

	2.) Press and hold the power button until the slide to shutdown swipe bar appears.

	3.) Release Power button

	4.) Press and hold Home button Lightly
	until screen returns to icon screen