Thread: FW: Re[2]: 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
You might also try Quasar Accounting, which is GPL and has graphical client frontends for both Linux and Windows. http://www.linuxcanada.com And yes, it does run on PG. On Tue, 27 Dec 2005, Pamela wrote: > > 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 >
Pamela wrote: > >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. > > > Aside from a questionable data model (which is correctable), you could do pretty much all of this with views and separate installations with SL in different schemas for the remote locations. YOu would still have to build in some budgeted amount customizations, but this shouldn't be too hard. You could also use SL as a starting point and build a Ruby/PHP front-end for the custom functionality. Hope this helps. Chris Travers