Strogn.com

Greetings!

My name is Chris King and I am a senior this at NCSU. Recently I have been working with Python, JS, more specifically Django and jQuery powered web applications for my startup, Macarist and my day job, Asymchem. I also enjoy reading a good deal and have been powering through the pragmatic bookshelf items, including: “The Pragmatic Programmer” and “Pragmatic Thinking and Learning.”

My strengths are software design, and team organization; my weaknesses are complex algorithms and using large IDEs.

My schedule:

Me:

Also all of my contact info is on the left!

-Chris

Tips

1. Always consider the context.
2. Use rules for novices, intuition for experts.
3. Know what you don’t know.
4. Learn by watching and imitating.
5. Keep practicing to remain an expert.
6. Avoid formal methods if you need creativity, intuition, or inventiveness.
7. Learn the skill of learning.
8. Capture all ideas to get more of them.
9. Learn by synthesis as well as analysis.
10. Strive for good design; it really works better.
11. Rewire your brain with belief and constant practice.
12. Add sensory experience to engage more of your brain

I’m hoping to get a chance to put some of these to use soon on Macarist.com, the startup I have been working on for the better part of 2 years

Today marks the unveiling of a new layout for the site and hopefully more frequent posts. In the coming days a few pages should be complete with rates for Web Development & PC Repair. Also lookout for links to samples of projects and more tutorials.

This tutorial illustrates how to install and configure a PostgreSQL server on Ubuntu 9.10.

Note: Use these instructions at your own risk.

Package Installation:

Enter the following commands in your shell.

First Update and upgrade all of your package repositories.

sudo apt-get update
sudo apt-get dist-upgrade

Next install the PostgreSQL package that will include both the client and server application.

sudo apt-get install postgresql

Configuration

Now we will define a password for your postgres(default) user.

sudo su postgres -c psql template1
ALTER USER postgres WITH PASSWORD 'passwordHere';
\q
sudo passwd -d postgres
sudo su postgres -c passwd

After that, create a secondary user with the permissions you would like them to have, in this example we give the ability to create more users and to create other databases.

CREATE USER userName WITH PASSWORD 'passwordHere';
ALTER USER userName CREATEUSER CREATEDB;

The following will create your first database named sample and grant rights to the user you just created.

create DATABASE sample;
GRANT ALL PRIVILEGES ON DATABASE sample to userName;
\q

Once all that is done it is time to modify the configuration files. This step will allow for your server to listen to requests from any IP Address, you should NOT use this option on a production server!

sudo gedit /etc/postgresql/8.4/main/postgresql.conf

Replace:

#listen_addresses = 'localhost'

With:

listen_addresses = '*'

In order to allow your server to listen to connections from other services like a django or rails app, you must alter your authentication methods. This change will allow for md5 authentication instead of direct user authentication which requires all users of your DB actually have a shell account on your box.

sudo gedit /etc/postgresql/8.4/main/pg_hba.conf

Replace:

local   all         all                               ident

With:

local   all         all                               md5

The only step now is to restart the server so that all of the changes take effect.

sudo /etc/init.d/postgresql-8.4 restart

That’s it, PostgreSQL has now been installed, a user has been added, and you can authenticate the user via a terminal session or via any service running on your machine.

Software upgrade complete, more content to be posted soon!