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.
And yes, it does run on PG.
On Tue, 27 Dec 2005, Pamela wrote:
Show quoted text
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
churchHi 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 PostgresqlTC> ---------------------------(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