Subject | Fyracle or Firebird |
---|---|
Author | Fidel Viegas |
Post date | 2008-02-06T12:47:46Z |
Hello folks,
I have been reading about Fyracle for a while, but never really got
the chance to play with it. I have played with it this weekend, and I
really think that it handles oracle's syntax pretty well. At least, I
have tried to port an oracle application to Fyracle and it worked
without modification. Now, I was analysing why I would use Fyracle
instead of Firebird. Fyracle is nothing but Firebird with Oracle
compatibilities. It isn't more scalable, or faster than Firebird, I
suppose. So why would I use Fyracle instead of Firebird?
I guess if I am an experienced Oracle developer, than I can just start
using Fyracle, because it is cheaper and I can use the commands I am
used too. Second, if I have an application that I would like to port
to a cheaper solution with little or no modification then, I can also
use Fyracle. But, wait a minute. Why wouldn't I use Oracle XE instead?
Hum... ok Oracle XE does not allow you to write stored procedures in
Java. Well, that is a great feature for Java developers (for me it
would be nice to have), but if I am a PL/SQL developer, then that does
not make much difference to me. I can always write PL/SQL code.
Has anyone had experience with Fyracle? What are your opinions with
regards to it? If you don't have to port any database application, why
would you go for Fyracle as opposed to Firebird? I am not considering
Oracle XE, because it is not as simple to install as Firebird. That is
one of the things I have always loved about Interbase/Firebird: easy
to install, easy to maintain and has trigger and procedure language.
I look forward to hearing what you guys have to say.
All the best,
Fidel.
I have been reading about Fyracle for a while, but never really got
the chance to play with it. I have played with it this weekend, and I
really think that it handles oracle's syntax pretty well. At least, I
have tried to port an oracle application to Fyracle and it worked
without modification. Now, I was analysing why I would use Fyracle
instead of Firebird. Fyracle is nothing but Firebird with Oracle
compatibilities. It isn't more scalable, or faster than Firebird, I
suppose. So why would I use Fyracle instead of Firebird?
I guess if I am an experienced Oracle developer, than I can just start
using Fyracle, because it is cheaper and I can use the commands I am
used too. Second, if I have an application that I would like to port
to a cheaper solution with little or no modification then, I can also
use Fyracle. But, wait a minute. Why wouldn't I use Oracle XE instead?
Hum... ok Oracle XE does not allow you to write stored procedures in
Java. Well, that is a great feature for Java developers (for me it
would be nice to have), but if I am a PL/SQL developer, then that does
not make much difference to me. I can always write PL/SQL code.
Has anyone had experience with Fyracle? What are your opinions with
regards to it? If you don't have to port any database application, why
would you go for Fyracle as opposed to Firebird? I am not considering
Oracle XE, because it is not as simple to install as Firebird. That is
one of the things I have always loved about Interbase/Firebird: easy
to install, easy to maintain and has trigger and procedure language.
I look forward to hearing what you guys have to say.
All the best,
Fidel.