[DUG] Why InterBase

[Neven MacEwan]

Richard

Couldn't the same argument apply to Prog Languages?
I myself are not keen on putting lots of logic in stored procs and 
unlike Paul I dont think SQL servers were designed to implement business 
logic, I'd stick to using constraints and triggers to implement 
referential and data integrity, it is after all a database not an 
application server

Neven


Richard Vowles wrote:
> Its funny isn't it that architecturally all evidence says "don't put
> your stuff in stored procedures" - it is hard to port and impossible to
> scale. On the other hand, every vendor wants you to do it because it
> ties you to them :-) 
> 
> SO maybe I should promote stored procedures in InterBase? Rohit.....
> ---
> Richard Vowles, Solutions Architect, Borland New Zealand
> email: richard.vowles at borland.com
> phone: +64-9-9184573
> cell: +64-21-467747
> other: MSN richard.vowles at borland.com, skype: rvowles
> blog: http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769
> 
> -----Original Message-----
> From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
> On Behalf Of Neven MacEwan
> Sent: Thursday, 1 June 2006 2:13 p.m.
> To: NZ Borland Developers Group - Delphi List
> Subject: Re: [DUG] Why InterBase
> 
> Richard
> 
> A bit self fulfilling this!
> 
> Richard Vowles wrote:
>> This is interesting - both Kylie and yourself have confirmed what I 
>> have had experience - MS SQL's superior Stored procedure language wins
> 
>> out on those who like to put a bit (or a lot) of code in the database
> engine.
>> I'm not big on stored procedures, but that is probably because I focus
> 
>> on InterBase and the stored procs are limited.
>>
>> Richard
>> ---
>> Richard Vowles, Solutions Architect, Borland New Zealand
>> email: richard.vowles at borland.com
>> phone: +64-9-9184573
>> cell: +64-21-467747
>> other: MSN richard.vowles at borland.com, skype: rvowles
>> blog: http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769
>>
>> -----Original Message-----
>> From: delphi-bounces at ns3.123.co.nz 
>> [mailto:delphi-bounces at ns3.123.co.nz]
>> On Behalf Of Jeremy Coulter
>> Sent: Thursday, 1 June 2006 12:04 a.m.
>> To: 'NZ Borland Developers Group - Delphi List'
>> Subject: RE: [DUG] Why InterBase
>>
>> I used IB for about 6-7 months after going from MSSQL 7(this is like 6
> 
>> years ago now), and HATED that IB didn't have a nice GUI interface. I 
>> didn't like this whole "Domains" thing for variables, although I did 
>> see the sense in it after a while and did use them, and REALLY hated 
>> having to use some other DLL to get any decent functions to use when 
>> doing Stored Procs.
>> When I left that job, after 6mths cos I hated the pace, and got my 
>> current role which I have had for 6years now, I went back to MSSQL, 
>> and now MSSQL
>> 2005 is out, I REALLY like it !
>> I guess it's the old story of horses for courses. We do a LOT with 
>> stored procs (well not so much me these days) and we are ready to 
>> start getting in MSSQL 2k5 soon as we can.
>>
>> _______________________________________________
>> Delphi mailing list
>> Delphi at ns3.123.co.nz
>> http://ns3.123.co.nz/mailman/listinfo/delphi
>>
>>
> 
> --
> Neven MacEwan (B.E. E&E)
> Ph. 09 620 1356 Mob. 027 4749 062
> 
> New Address Details
> ===================
> MWK Computer Systems
> 1 Taumata Rd
> Sandringham
> Auckland
> 
> Ph 620 1356
> Fx 620 1336
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> 
> 

-- 
Neven MacEwan (B.E. E&E)
Ph. 09 620 1356 Mob. 027 4749 062

New Address Details
===================
MWK Computer Systems
1 Taumata Rd
Sandringham
Auckland

Ph 620 1356
Fx 620 1336
-------------- next part --------------
A non-text attachment was scrubbed...
Name: neven.vcf
Type: text/x-vcard
Size: 164 bytes
Desc: not available
Url : http://ns3.123.co.nz/pipermail/delphi/attachments/20060601/2fffaee8/neven.vcf