Re: Which DB?
Re: Which DB?
- Subject: Re: Which DB?
- From: Ray Kiddy <email@hidden>
- Date: Tue, 25 May 2004 11:22:27 -0700
Lots of databases do this. In MySQL it is called a UDF (for User
Defined Function).
It is also quite common, once the basic functionality is there, to see
people wrap things up so you can do a UDF in Ruby, python, C#, java,
(other funky language popular this week), etc, etc, etc.....
Note that once yo\u start writing these things, you have to think about
what you are doing. It is incredibly easy to crash your database server
process while doing something, and then you end up leaving your
database in an interesting, and perhaps undefinable and undeterminable,
state.... Even if what you are trying to do is small, the problem you
cause in your database may be big. Make backups, and
experiment/debug/test on toy, or duplicate, data sets. Just be aware,
there be dragons.
http://dev.mysql.com/doc/mysql/en/Extending_MySQL.html
- ray
On May 25, 2004, at 9:01 AM, Arturo Pirez wrote:
On May 25, 2004, at 11:09 AM, David Teran wrote:
It supports a lot of features, ... external functions (written in
c, great to delete files in filesystem if a record in database is
deleted!) ...
Hi David,
this sounds cool. Could you give some more hints how to do that? Is
this a standard function?
No, its not standard but... you create an on-delete trigger which
calls a function and the function is an external perl or c script. I
am not a c expert but it took me 20 minutes to write a c function and
integrate it in postgres. Its very good documented.
pgSQL also lets you write your stored procedures in many different
languages as well. IIRC, it supports perl, c, tk, and something like
ten others.
----
WO in philadelphia - wanna cheesesteak with that?
Please visit webobjects.meetup.com.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.