Comments for Routing Life

Comment on Debugging PHP SoapClient by Francis Kim

Francis Kim — Thu, 12 Nov 2015 23:24:01 +0000

Here I am, debugging SOAP at the end of 2015 – this came in handy, thanks 🙂

Comment on VMware ESXi vs XenServer by OGRE

OGRE — Wed, 16 Oct 2013 08:01:26 +0000

I run ESXi 5.0 at home. I tested Xenserver as well. It worked just fine, but it was a little weird when it came to the console. The graphics were pixelated, it looked like I was connecting with LogMeIn, even though I was local. Anyway I was wondering what you guys ended up going with?

Comment on Server Side Language Detection with Google Language API by Laurynas

Laurynas — Wed, 17 Oct 2012 06:46:20 +0000

Now when Google Translate API is paid service you can use altenative Detect Language API:
http://detectlanguage.com

It is compatible with Google Translate API

Comment on VMware Server Disk IO Performance by Zeque

Zeque — Tue, 03 Jul 2012 03:20:41 +0000

It works pretty good!!! thank you very much!!

Comment on Move a PostgreSQL database to a different tablespace by ilatypov

ilatypov — Mon, 18 Jun 2012 22:23:53 +0000

Err, the above failed to move pg_catalog.* tables so I added a filter before db.execute( “alter table ..” ),

if schemaName == "public":

Comment on Move a PostgreSQL database to a different tablespace by ilatypov

ilatypov — Mon, 18 Jun 2012 22:10:04 +0000

Executing statements immediately appears to work with a PostgreSQL 8.4 database using the above code as a template for the Python script below,


#! /usr/bin/python3

import postgresql

dbName = "DB"
tablespaceName = "SPACE"

db = postgresql.open("pq://USER@HOST/SERVICE")

with db:
    db.settings[ "client_min_messages" ] = "NOTICE"
    db.execute( "alter database %s set default_tablespace = %s" % ( dbName, tablespaceName ) )
    for table in db.prepare( "select * from pg_tables order by tablename" ):
        schemaName = table[ "schemaname" ]
        tableName = table[ "tablename" ]
        db.execute( "alter table %s.%s set tablespace %s" % ( schemaName, tableName, tablespaceName ) )
        for index in db.prepare( "select * from pg_indexes where schemaname = '%s' and tablename = '%s' order by indexname"
                % ( schemaName, tableName ) ):
            db.execute( "alter index %s.%s set tablespace %s" % ( schemaName, index[ "indexname" ], tablespaceName ) )

Comment on Move a PostgreSQL database to a different tablespace by how to install postgresql in ubuntu « Bilnir

how to install postgresql in ubuntu « Bilnir — Mon, 05 Mar 2012 19:27:20 +0000

[…] If you want to automate the updating of all indexes for a given schema you can do it in a few steps like this (inspired by comments in this blog article): […]

Comment on Move a PostgreSQL database to a different tablespace by Tablespaces in postgresql « Blog personal de René Romero Benavides

Tablespaces in postgresql « Blog personal de René Romero Benavides — Sun, 06 Nov 2011 05:31:58 +0000

[…] http://blog.lodeblomme.be/2008/03/15/move-a-postgresql-database-to-a-different-tablespace/ […]

Comment on Server Side Language Detection with Google Language API by john

john — Mon, 17 Oct 2011 10:16:09 +0000

Hi Samuel,
Your function is working good except few languages that it doesn’t support(ar,ru and few more)
Do you have an idea why is that?
Thanks both of you for this feature, it will help me allot.

Comment on Server Side Language Detection with Google Language API by Ajith

Ajith — Wed, 24 Aug 2011 08:12:00 +0000

Wonderful stuff 🙂