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: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: Tuesday, December 27, 2005 9:25 PM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings !DSPAM:43b223db207371333710190! ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
