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-boun...@lists.plug.phoenix.az.us [mailto:plug-discuss-boun...@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 mo...@noon - 3PM > From: bon...@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>
--------------------------------------------------- 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
