<< Previous | Home | Next >>

PostgreSQL on Windows

Download the Windows zip from EnterpriseDB site and unzip to some directory. For this demonstration, I'll assume C:\_apps\pgsql.

C:\>cd \_apps\pgsql

Initialize a new database. This location could be anywhere you like, for simplicity's sake I'll create a directory named data inside the pgsql directory.

C:\_apps\pgsql>mkdir data
C:\_apps\pgsql>bin\initdb.exe -D data

After a series of debug messages you should finally receive the following.

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.

Success. You can now start the database server using:

    "bin\postgres" -D "data"
or
    "bin\pg_ctl" -D "data" -l logfile start
Tags :
Social Bookmarks :  Add this post to Slashdot    Add this post to Digg    Add this post to Reddit    Add this post to Delicious    Add this post to Stumble it    Add this post to Google    Add this post to Technorati    Add this post to Bloglines    Add this post to Facebook    Add this post to Furl    Add this post to Windows Live    Add this post to Yahoo!

Export this post as PDF document  Export this post to PDF document

W3C Geolocation, Bing Maps and HTML 5 Canvas

This code uses the W3C's Geolocation API in conjunction with Bing Maps and HTML 5 Canvas. 

<!DOCTYPE HTML>
<html>
<head>
    <title>HTML5 page</title>
    <!--link rel="stylesheet" type="text/css" href="site.css"/-->
    <style type="text/css">
        #baseDiv {position:relative; width:80%; left:10%; border:1px solid;}
    </style>
</head>
<body>
    <div id="baseDiv">
        <canvas id="stage" width="600" height="600">Sorry, your browser does not support the canvas tag.</canvas>
    </div>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.3/jquery.js"></script>
    <script type="text/javascript">
    //<![CDATA[
        var lineHeight = 14;
        jQuery(function() {
            navigator.geolocation.getCurrentPosition(showPosition);
        });

        function showPosition(position) {
            var ctx = document.getElementById('stage').getContext('2d'),
                txt = 'This is a string of text',
                x = 10, y = lineHeight,
                maxWidth = 50,
                lat = position.coords.latitude,
                lon = position.coords.longitude;
            ctx.font = '12pt Courier New';

            ctx.fillText('latitude: ' + lat, x, y);
            y += lineHeight;
            ctx.fillText('longitude: ' + lon, x, y);
            y += lineHeight;

            var img = new Image(),
                url = 'http://dev.virtualearth.net/REST/v1/Imagery/Map/Road/' + lat + ',' + lon + '/15'
                        + '?mapSize=400,400'
                        + '&pushpin=' + lat + ',' + lon
                        + '&mapLayer=trafficFlow'
                        + '&key=XXXXXXXXXXXXXXXXXX';

            jQuery(img).bind('load', function() {
                ctx.drawImage(img, x, y);
            });

            img.src = url;
        }
    //]]>
    </script>
</body>
</html>
Social Bookmarks :  Add this post to Slashdot    Add this post to Digg    Add this post to Reddit    Add this post to Delicious    Add this post to Stumble it    Add this post to Google    Add this post to Technorati    Add this post to Bloglines    Add this post to Facebook    Add this post to Furl    Add this post to Windows Live    Add this post to Yahoo!

Export this post as PDF document  Export this post to PDF document

Python - CSV to sqllite

Nice Python CSV to sqlite conversion...

# toSqlite.py - Imports humod06.txt to sqlite.

import csv
import sqlite3

conn = sqlite3.connect('humod.sqlite')
c = conn.cursor()

c.execute('''DROP TABLE IF EXISTS skl_desc''')

c.execute('''CREATE TABLE skl_desc (
id INTEGER PRIMARY KEY AUTOINCREMENT,
parent INTEGER,
mod INTEGER,
desc TEXT,
abr TEXT,
r INTEGER)
''')

insertSql = '''
INSERT INTO skl_desc
VALUES (null, ?, ?, ?, ?, ?)
'''

reader = csv.reader(open('humod06.txt', 'rb'), delimiter='\t')
rownum = 0
for row in reader:
    if rownum == 0: pass
    else:
        parent = 0
        rValue = 0
        if row[5] == 'R':
            rValue = 1
        t = (parent,
            row[1],
            unicode(row[4].strip(), 'utf8'),
            unicode(row[2].strip(), 'utf8'),
            rValue)
        c.execute(insertSql, t)
    rownum += 1
print('rows: %s' % rownum)
conn.commit()
c.close()
Tags : ,
Social Bookmarks :  Add this post to Slashdot    Add this post to Digg    Add this post to Reddit    Add this post to Delicious    Add this post to Stumble it    Add this post to Google    Add this post to Technorati    Add this post to Bloglines    Add this post to Facebook    Add this post to Furl    Add this post to Windows Live    Add this post to Yahoo!

Export this post as PDF document  Export this post to PDF document

Python - CSV to XML

# toXml.py - Imports humod06.txt to XML.

import csv
from xml.dom.minidom import parseString

doc = parseString('<skill_descriptors lvl="0"/>')

reader = csv.reader(open('humod06.txt', 'rb'), delimiter='\t')
rownum = 0
elm = doc.documentElement
for row in reader:
    if rownum == 0:
        header = row
    else:
        sd = doc.createElement('skill_descriptor')
        colnum = 0
        for col in row:
            #print '%-8s: %s' % (header[colnum], col)
            sd.setAttribute(header[colnum].lower(), unicode(col.strip(), 'utf8'))
            colnum += 1

        while row[3] <= elm.getAttribute('lvl'):
            elm = elm.parentNode
        elm.appendChild(sd)
        elm = sd

    rownum += 1
print(doc.toxml())
print('rows: %s' % rownum)
doc.unlink()
Tags : ,
Social Bookmarks :  Add this post to Slashdot    Add this post to Digg    Add this post to Reddit    Add this post to Delicious    Add this post to Stumble it    Add this post to Google    Add this post to Technorati    Add this post to Bloglines    Add this post to Facebook    Add this post to Furl    Add this post to Windows Live    Add this post to Yahoo!

Export this post as PDF document  Export this post to PDF document