Re: new beginner to postgresql. Looking at it for a church - Mailing list pgsql-general

It sounds as if reliability of the data is of some importance (usually is in financial applications), and personally, I
wouldn'ttrust mySQL with such data  -- the inability to have clean transactions, its willingness to insert data that
doesn'tmatch 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
someapplications. 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@postgresql.org on behalf of Pamela
Sent:    Tue 12/27/2005 9:33 PM
To:    pgsql-general@postgresql.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@ugnn.ru]
Sent: Tuesday, December 27, 2005 9:25 PM
To: pamela@bizwaves.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@ugnn.ru


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

!DSPAM:43b223db207371333710190!