Skip site navigation (1) Skip section navigation (2)

Re: Using PostgreSQL As A Personal Database

From: Terry Lee Tucker <terry(at)esc1(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Using PostgreSQL As A Personal Database
Date: 2004-11-22 20:09:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

We are definitely not using it for "weblog" stuff. We're building a logistics 
software package with. I say it would be much easier to store your data in 
postgres than a flat file. Since you are a "command line guy", psql offers a 
very nice character based interface in which you can ealily retrieve your 
data in all sorts of interesting ways using sql. As for trouble, I don't see 
that as an issue. All you have to do is compile it, and configure rc.d to 
start postmaster on boot, and create a table or two. It's easy.

Hope this helps...

On Monday 22 November 2004 02:55 pm, Jeff Flowers saith:
> After a friend's house recently caught fire, I decided that it would be
> a good idea to catalog my comic collection (for insurance purposes if
> nothing else). I estimate that I have some four hundred books and my
> collection grows every month.
> Since I prefer working at the Unix command line environment, my first
> thought was to create a flat file text database and manage it with
> command line tools, like grep, but as my collection grows I can envision
> where it might be useful to maintain it in PostgreSQL.
> So my question is: how much data needs to be stored before PostgreSQL is
> worth the effort? Also, do people even use PostgreSQL at home for
> personal, non-weblog stuff?
> Thanks.
> --
> Jeff Flowers
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?

Quote: 41
"He therefore is the truest friend to the liberty of his country who
 tries most to promote its virtue, and who, so far as his power and
 influence extend, will not suffer a man to be chosen into any office
 of power and trust who is not a wise and virtuous man.... The sum of
 all is, if we would most truly enjoy this gift of Heaven, let us be-
 come a virtuous people."

 --Samuel Adams

 Work: 1-336-372-6812
 Cell: 1-336-363-4719
email: terry(at)esc1(dot)com

In response to

pgsql-novice by date

Next:From: JánosDate: 2004-11-22 20:12:10
Subject: postgis compile question
Previous:From: Jeff FlowersDate: 2004-11-22 19:55:50
Subject: Using PostgreSQL As A Personal Database

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group