• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Which DB?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.


References: 
 >Which DB? (From: Lotsa Cabo <email@hidden>)
 >Re: Which DB? (From: Kieran Kelleher <email@hidden>)
 >Re: Which DB? (From: David Teran <email@hidden>)
 >Re: Which DB? (From: Timo Höpfner <email@hidden>)
 >Re: Which DB? (From: David Teran <email@hidden>)
 >Re: Which DB? (From: Arturo Pérez <email@hidden>)

  • Prev by Date: toggling NSlog for framework
  • Next by Date: Re: Missing WOExceptionPage
  • Previous by thread: Re: Which DB?
  • Next by thread: WOLongResponse and EO processing
  • Index(es):
    • Date
    • Thread