Interesting. When I last looked at SQL Server, it didn't have UDFs- it was
one of IB's advantages. But that was in about '97. I googled "SQL Server
UDF" and the second hit was an article that says in the very first
paragraph: "With SQL Server 2000, I can finally create user-defined
functions (UDFs)...". So I guess I'm pretty out of touch.

All my programming is in Delphi for Win32 as well. It might not be "cutting
edge", but it's efficient, effective, and a very appropriate tool for
business applications- like Firebird.

There is one thing that Firebird can do better than any other alternative-
enable the creation of true Client/Server database applications in Windows,
that can be deployed REALLY easily, for absolutely no cost. MySQL isn't
free, Postgres isn't easy to install, and MSDE limits both database size and
concurrent connections, forcing an update to the decidedly NOT free SQL
Server product when your app usage gets even moderately large.

Problem is, this isn't a subject that would result in the kind of technical
article DDJ is probably looking for.

|-----Original Message-----
|From: Nando Dessena [mailto:nandod@...]
|Sent: Tuesday, June 22, 2004 04:59pm
|To: Firebird-general@yahoogroups.com
|Subject: Re: [Firebird-general] Article
|
|
|Steve, All,
|
|s> I'd hate to see this excellent publicity opportunity wasted.
|I'm sure I'm not
|s> the most qualified of the members of this list to do a
|technical article on
|s> using Firebird, but I'd consider it if nobody else wants to. I
|don't have much
|s> experience with events, but I've done some custom UDFs. The
|ability to add user
|s> defined functions is pretty unique to Interbase/Firebird, isn't it?
|
|Mmm... I think it's pretty common, instead. At least I have seen it done in
|Oracle and MS SQL Server. I haven't seen a callback implementation as
|slick as Firebird events elsewhere, though. But I don't have anything
|very interesting to say about events either.
|
|What I have is I think pretty unique, but the problems I
|am solving don't qualify as common. I am using Firebird embedded as a
|high-performance back-end for a multithreaded server which has the
|role of collecting statistical information from the desktops of a call
|center. Hundreds of transactions per second is the likely load in
|production (I have a pool of a hundred threads and they're usually all
|running in the test environment). Embedding the server cuts access
|time to the data by about 50%, and this is the fastest server of the
|family (the others use Oracle via OCI or Oracle*Net, but don't get
|close to the speed of Fb embedded even on local connections). But,
|apart from the fact that this use case looks a bit exotic if not
|awkward, everything is implemented in Delphi for Win32 (not even .NET)
|- not exactly the kind of tool DDJ spends tons of pages upon. And,
|since it's contract work, I'm not sure how much of the code I would be
|allowed to disclose...
|
|Ciao
|--
|Nando Dessena
|mailto:nandod@...
|
|
|
|Community email addresses:
| Post message: Firebird-general@yahoogroups.com
| Subscribe: Firebird-general-subscribe@yahoogroups.com
| Unsubscribe: Firebird-general-unsubscribe@yahoogroups.com
| List owner: Firebird-general-owner@yahoogroups.com
|
|Shortcut URL to this page:
| http://www.yahoogroups.com/community/Firebird-general
|Yahoo! Groups Links
|
|
|
|
|