Re: new beginner to postgresql. Looking at it for a church

From: "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>
To: <pamela(at)bizwaves(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: new beginner to postgresql. Looking at it for a church
Date: 2005-12-28 07:10:22
Message-ID: 71E37EF6B7DCC1499CEA0316A2568328024BBD4C@loki.wc.globexplorer.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It sounds as if reliability of the data is of some importance (usually is in financial applications), and personally, I wouldn't trust mySQL with such data -- the inability to have clean transactions, its willingness to insert data that doesn't match what the original input was with throwing an error, and a few other gotchas come to mind.

Of course, postgres may have a slightly higher learning curve -- mySQL in its native form can outperform postgres in some applications. But if the data is important I'd go with postgres.

Of course, this *is* a postgres list so such a feeling might not be reflective of everyone's results.

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org on behalf of Pamela
Sent: Tue 12/27/2005 9:33 PM
To: pgsql-general(at)postgresql(dot)org
Cc:
Subject: FW: Re[2]: [GENERAL] new beginner to postgresql. Looking at it for a church

I would prefer using linux. I have worked in a limited capacity with both
linux and windows. The front end I was looking at Ruby/PHP.

Thanks Igor

SQ- ledger.org provided by Dann Corbit has a lot of what I would be looking
for plus more. The financials would require a budgeted amount plus requires
budgeted minus actual, plus many computations and configurations so that
they could at consolidated statements for the churches and separate
financials. This would have to datamodeled properly and allow for there
particulars.

-----Original Message-----
From: go KEY952866 [mailto:go(at)ugnn(dot)ru]
Sent: Tuesday, December 27, 2005 9:25 PM
To: pamela(at)bizwaves(dot)net
Subject: Re[2]: [GENERAL] new beginner to postgresql. Looking at it for a
church

Hi Pamela,

Tell me please what front-end application are u planning for
your project? and what server(Linux or Win) are u running for
postgres?
(if it is not a top-secret, please)

Have a nice day!
Igor.

TC> Pamela wrote:
>> Hello:
>>
>>
>>
>> I was wondering if anyone has setup a point-of-sale system with
>> postgresql. Also, I will have to create a database for a church that
>> requires lots of tables and subcategories. They have 4 different
>> locations and wish to be interconnected amongst each other,

TC> Postgresql can handle such a task, and should make things a little
TC> easier for you if you use schemas to organize your tables etc.

TC> You also have the option to use replication and dblink to do cross
TC> database queries etc.

TC> Don't know about the point of sale question though.

TC> (You mentioned you where new to Postgres)

TC> If you are a windows user be sure to check out PG Lightning Admin, it's
TC> much easier to use than PG Admin III (my opinion, no flames please) and
TC> it priced very inexpensively.

TC> AM Software Design
TC> http://www.amsoftwaredesign.com
TC> Home of PG Lightning Admin for Postgresql

TC> ---------------------------(end of broadcast)---------------------------
TC> TIP 4: Have you searched our list archives?

TC> http://archives.postgresql.org

--
Ñ óâàæåíèåì,
Èãîðü mailto:go(at)ugnn(dot)ru

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

!DSPAM:43b223db207371333710190!

Browse pgsql-general by date

  From Date Subject
Next Message Robby Russell 2005-12-28 07:13:06 Re: sending mail from Postgres
Previous Message Pamela 2005-12-28 06:51:20 FW: FW: Re[2]: new beginner to postgresql. Looking at it for a church