Awe... Thank you Lisa, so few of the people I know would ever call me right
brained :) 
Usually I am the logical hard a** of the group who insists on real evidence
and analytical though processes.
I suppose this sabbatical is doing me some good after all :)
 
I will decently check out the GUI tools you suggest, but for now my wife is
calling me over for cake (and no the cake is not a lie ;)

  _____  

From: plug-discuss-bounces@lists.plug.phoenix.az.us
[mailto:plug-discuss-bounces@lists.plug.phoenix.az.us] On Behalf Of Lisa
Kachold
Sent: Tuesday, March 31, 2009 7:38 PM
To: plug-discuss@lists.plug.phoenix.az.us
Subject: RE: looking for db recommendation


Excellent post with good clear direction and suggestions Bishmer Sekaran! 

And very interesting descriptive literary first person subjective experience
from Boneal.

Postgres is a very schitzophrenic (and insecure) solution, but very good in
clearly defined roles.  Since you are clearly right brained Boneal, get one
of the graphic management tools, like pgmyadmin or psgsql.   

Obnosis <http://www.obnosis.com/>  | (503)754-4452
PLUG <http://http//plug.phoenix.az.us>  Linux  <http://uat.edu/> Security
Labs 2nd Saturday Each Month@Noon - 3PM

> From: boneal@cornerstonehome.com
> To: plug-discuss@lists.plug.phoenix.az.us
> Subject: RE: looking for db recommendation
> Date: Tue, 31 Mar 2009 17:25:18 -0700
> 
> Perhaps I was unduly harsh on Postgresql. 
> 
> And while the last time I messed with it was over a half decade past; it
> gave me a headache at the time. I am told my headaches would have gone
away
> if I just did XYZ (which changed depending on who you talked to) like
> setting more restrictive locks. The problem I had was that, to me, things
> like manually setting the locking mode to eliminate intermittent errors of
> old data being returned by queries after newdata was committed by other
> queries is just not intuitive. I would understand releasing these locks
and
> accepting the risk if I needed to resolve some odd conflict immediately
> while working on a real solution, but the other way around? PostgreSQL
just
> felt like a slightly schizophrenic overly needy girlfriend, I suppose if I
> understood her better I would love her but I was unwilling to put in the
> time.
> 
> Again, this was a while ago and things change, I should PostgreSQL give it
> another shot.
> 
> 
> 
> Bishmer Sekaran wrote:
> Postgres' difficulty is somewhat overstated. IMO it's easier to get
started
> with postgres than to say, learn mod_perl on Apache or configure sendmail.
> Steps for Mark to switch to postgres:
> 
> 1) Acquire and start postgres - Easy in SUSE, they even have a page for
> it: http://en.opensuse.org/Postgresql
> 
> 2) Export data from Access (Access->Excel->csv is easiest? Seems like it's
> more convoluted, ie would be faster than Access-> csv since this is M$
we're
> talking about)
> 
> 3) Create his new db - Copy the same format as previously, just in ANSI
SQL.
> Probably something like
> 
> CREATE TABLE Records (
> Artist text,
> Album text,
> Year integer,
> Genre text,
> Rating integer,
> Lastquality datatype
> );
> 
> 4) COPY Records FROM filename WITH CSV;
> See also: http://www.postgresql.org/docs/8.3/static/sql-copy.html
> 
> Bryan O'Neal wrote:
>> I don't think any one doubts postgresqls ability to run his db 
>> effectively, instead we doubt its ease of use. MS Access it is not ;)
>>
> 
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss


  _____  

Express your personality in color! Preview and select themes for HotmailR.
See how.
<http://www.windowslive-hotmail.com/LearnMore/personalize.aspx?ocid=TXT_MSGT
X_WL_HM_express_032009#colortheme>