sql-ledger-users

[SQL-Ledger-users] PostgreSQL triggers?

[Benjamin L. <ben...@co...>]

This is just a thought...

I was going through the code, and I was wondering to myself whether it
would robustify matters any to move the 'update_balance' code into the
database layer with triggers and then have the 'chart' table updated
by the triggers.

Using triggers would of course put MySQL in a bit of a muddle, but it
would simplify the business processes in the application layer. I was
almost confused reading the bits between old_this and new_this. ;-)

I might stuff around with this trigger idea in the not too distant
future.

Comments?

P.S. Don't flame me about MySQL. I love MySQL; and in fact, I'm more
of a newcomer to PostgreSQL. I'm just poking around and the like.

-- 
B.      http://makelinux.org/    "Always real."    http://realthought.net/

Re: [SQL-Ledger-users] PostgreSQL triggers?

[Damon T. <da...@ra...>]

I haven't looked too closely at the code but here are my thoughts...

a) letting the database manage business logic with triggers and constraints is 
a good thing for design and performance reasons
b) unfortunately, most rdbms have proprietary formats for triggers so writing a 
trigger for Postgres would either eliminate other rdbms or necessitate 
different database code for different rdbms.

Damon

Quoting Benjamin Lee <ben...@co...>:

> This is just a thought...
> 
> I was going through the code, and I was wondering to myself whether it
> would robustify matters any to move the 'update_balance' code into the
> database layer with triggers and then have the 'chart' table updated
> by the triggers.
> 
> Using triggers would of course put MySQL in a bit of a muddle, but it
> would simplify the business processes in the application layer. I was
> almost confused reading the bits between old_this and new_this. ;-)
> 
> I might stuff around with this trigger idea in the not too distant
> future.
> 
> Comments?
> 
> P.S. Don't flame me about MySQL. I love MySQL; and in fact, I'm more
> of a newcomer to PostgreSQL. I'm just poking around and the like.
> 
> -- 
> B.      http://makelinux.org/    "Always real."   
> http://realthought.net/
> 
> 



Damon Torgerson
President, Ranksix Inc.
da...@ra...
250.884.7171

Re: [SQL-Ledger-users] PostgreSQL triggers?

[<li...@li...>]

On Fri, May 04, 2001 at 09:27:37AM -0700, Damon Torgerson was heard to rema=
rk:
> a) letting the database manage business logic with triggers and constrain=
ts is=20
> a good thing for design and performance reasons
> b) unfortunately, most rdbms have proprietary formats for triggers so wri=
ting a=20
> trigger for Postgres would either eliminate other rdbms or necessitate=20
> different database code for different rdbms.

My impression was (may be very wrong) that postgress triggers and e.g.
oracle triggers are pretty similar/same.   Its stored proceedures where
all hell breaks loose.  (in postgres, you can link in arbitrary .so's.=20
Basically if you can link it into a shared library, you can turn it into
a postgress stored proceedure. SO its very very general).

--linas
--=20
Linas Vepstas -- li...@gn... -- http://www.gnumatic.com/

[SQL-Ledger-users] Boa "port"

[Andrew S. <an...@me...>]

I made the necessary mods to sql-ledger to use it with boa instead
of apache.  And *boy*, it is a lot faster.  At least faster than it
was on my pobre 200MHz powerpc 604e dual processor.  I thought I
would ask if anyone else is interested in those mods.  The version
is 1.2, I think.  Is that version still relevant?  Actually I sent
an email some time ago about this, but apparently the list processor
is quite finicky about accepting emails only when the return address
is the same as a subscriber to the list.  Since I use several
different email addresses, sometimes I send emails and fail to
notice right away that it didn't get sent to the list.  If you're
not familiar, boa is a single threaded web server that is quite fast
compared to apache, but has a very short feature list, by
comparison.

a

Re: [SQL-Ledger-users] Boa "port"

[Dieter S. <dsi...@sq...>]

Version 1.2.10 is the last stable release.

Send me a copy of your mods and I'll post it as 1.2.11.

To send emails from different accounts subsribe to the list with all the
email addresses you use and then disable delivery for the accounts you do
not want to receive emails. This way you can post with any of your email
addresses and receive a copy of the email in your favourite email box.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Fri, 4 May 2001, Andrew Sharp wrote:

> I made the necessary mods to sql-ledger to use it with boa instead
> of apache.  And *boy*, it is a lot faster.  At least faster than it
> was on my pobre 200MHz powerpc 604e dual processor.  I thought I
> would ask if anyone else is interested in those mods.  The version
> is 1.2, I think.  Is that version still relevant?  Actually I sent
> an email some time ago about this, but apparently the list processor
> is quite finicky about accepting emails only when the return address
> is the same as a subscriber to the list.  Since I use several
> different email addresses, sometimes I send emails and fail to
> notice right away that it didn't get sent to the list.  If you're
> not familiar, boa is a single threaded web server that is quite fast
> compared to apache, but has a very short feature list, by
> comparison.
> 
> a
> 
> 

Re: [SQL-Ledger-users] Boa "port"

[Andrew S. <an...@me...>]

I made a patch file and I was looking it over to make sure there
weren't too many ugly hacks in it, when it occured to me that you
might want just a tar ball or something.  Because I am using Debian,
there are various changes that are debian-isms, like the main home
httpd directory being /var/www instead of /home/httpd and like
that.  I don't know if you want all that or not.  Let me know
whether you want a tarball or just a patch file.

a

Dieter Simader wrote:
> 
> Version 1.2.10 is the last stable release.
> 
> Send me a copy of your mods and I'll post it as 1.2.11.
> 
> To send emails from different accounts subsribe to the list with all the
> email addresses you use and then disable delivery for the accounts you do
> not want to receive emails. This way you can post with any of your email
> addresses and receive a copy of the email in your favourite email box.
> 
> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> DWS Systems Inc.     Accounting Software       Fax: 478-5281
> =========== On a clear disk you can seek forever ===========
> 
> On Fri, 4 May 2001, Andrew Sharp wrote:
> 
> > I made the necessary mods to sql-ledger to use it with boa instead
> > of apache.  And *boy*, it is a lot faster.  At least faster than it
> > was on my pobre 200MHz powerpc 604e dual processor.  I thought I
> > would ask if anyone else is interested in those mods.  The version
> > is 1.2, I think.  Is that version still relevant?  Actually I sent
> > an email some time ago about this, but apparently the list processor
> > is quite finicky about accepting emails only when the return address
> > is the same as a subscriber to the list.  Since I use several
> > different email addresses, sometimes I send emails and fail to
> > notice right away that it didn't get sent to the list.  If you're
> > not familiar, boa is a single threaded web server that is quite fast
> > compared to apache, but has a very short feature list, by
> > comparison.
> >
> > a
> >
> >

Re: [SQL-Ledger-users] Boa "port"

[Metin O. <me...@tu...>]

Dear a,

Yes, it would be great to try out your work on boa server.  I was thinking
about faster response times myself for some other perl apps too.

m :)

At 06:47 PM 5/4/01 -0700, you wrote:
>I made the necessary mods to sql-ledger to use it with boa instead
>of apache.  And *boy*, it is a lot faster.  At least faster than it
>was on my pobre 200MHz powerpc 604e dual processor.  I thought I
>would ask if anyone else is interested in those mods.  The version
>is 1.2, I think.  Is that version still relevant?  Actually I sent
>an email some time ago about this, but apparently the list processor
>is quite finicky about accepting emails only when the return address
>is the same as a subscriber to the list.  Since I use several
>different email addresses, sometimes I send emails and fail to
>notice right away that it didn't get sent to the list.  If you're
>not familiar, boa is a single threaded web server that is quite fast
>compared to apache, but has a very short feature list, by
>comparison.
>
>a