"Carl E. McMillin" <[EMAIL PROTECTED]> writes: > My name is Carl E. McMillin and I'm still establishing my balance in this > particular knowledge domain with its nomenclature and entities. > Ok, I was thinking more the name behind [EMAIL PROTECTED] ;-)
> But Postgres isn't purely a storage solution; it is not just a place to hang > your data. Aren't stored procedures, whether SQL-based or backed by native > libraries, very much essential to application-logic performance and > portability? Ok, portability may suffer, but they do help performance! > I agree. Some app logic is best performed in the backend. Especially if the logic is storage intensitive or deals with advanced storage constraints/rules. That's one of the reasons I wrote Pl/Java. In essence, I don't think we disagree on anything. The only thing I'm reacting to is the term "app-server" which I think is badly chosen. Stored procedures and functions doesn't make a database an app-server, no matter what you put in them. > One of my personal interests is "hybridizing" a strong SQL > execution-environment such as Postgres with an equally strong > process-control framework so that components which would normally be in the > "middle" tier are directly accessible by way of "extensions". For instance, > constructs such as the following would be really useful in some > bioinformatics-related consulting I'm involved in: > > SELECT * FROM get_list_of_hsp_from_blastall('ACGGATTAT', 'H_sapiens'); > > The function "get_list_of_hsp_from_blastall" takes a primer ('ACGGATTAT') > and an organism ('H_sapiens') and runs an external process called "blastall" > to locate "high-scoring pairs" where the primer "aligns well" with the > organism's nucleotide-sequence (its genome). This would be a relatively > trivial exercise if Postgres had a robust framework for process control - > maybe it does, I haven't gotten many responses indicating yea or nay. > You can write your own functions in C and thereby get all the process control you want. Or if you want to make life easier and get a more portable solution (by my standards that is) why not use Java? Kind regards, Thomas Hallgren ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]