Slashdot Mirror

That's a lot like the PL/SQL-compatible variant of Firebird, called Fyracle, which is still based on Firebird 1.5, not the current 2.1 or 2.5 series.

Phoenix basic looked interesting though not open source
http://www.janus-software.com/phoenix_features.html

of course, there is vb.net implementation by mono project... I hope they survive the new management though it is open source so theoretically it could be picked up at any point

There are alternatives to Oracle, but none that I'm aware of are FOSS. If you actually need Oracle (and a lot of people using it don't), then Firebird simply isn't an alternative

Actually there is a Firebird based project called Fryacle that was built to be compatible enough with Oracle to run Oracle Apps.

A company called Janus Software built it so that they could run something called "Compiere".

Go to their website http://www.janus-software.com/fb_fyracle.html to see more information about their "Oracle Mode Firebird" project.

The "Oracle compatability" project I suspect you're thinking of is called Fyracle, and can be found at http://www.janus-software.com/fb_fyracle.html. It takes care of many (most?) Oracle syntax oddities, and handles PL/SQL code so you don't lose investments in huge stored procedures. It sits as a front-end between you and Firebird. I don't think Fyracle is open source/free, but I believe the runtime is free and the developers kit is cheap. [No product endorsement intended here, I just am vaguely aware of the project.]

Wouldn't oracle mode firebird or maxdb or ingres be a bigger threat to oracle them mysql?

What would killing mysql accomplish when ther are a plethora of great open source databases that are fully transactional, full featured and proven in some of the largest companies in the world?

mysql could use firebird as storage/transactional/relational
engine in future ;) if oracle will cut InnoDB (who knows what will happen with it)
don't know about licences fit (mpl vs gpl)
and with it they could get oracle mode too (for free)

http://www.janus-software.com/fb_fyracle.html

IIRC mySQL AB's MaxDB has an Oracle emulation mode, and so does Firebird with Fyracle.

There are plenty of RADs. But first you need to decide on a programming language.

Ada:
Glade

BASIC:
Gambas
Phoenix
Rapid-Q

C:
Glade

C++ (why?):
Glade
Kylix
QT Designer

Pascal:
Kylix
Lazarus

Python:
python-glade

Have you seen this.

Its an oracle mode firebird. They took the firebird open source database and made it look like oracle. Same table types, same column types, same SP language.

I wonder if the same thing could be done with postgres. If I recall sapdb was also compatible with oracle 7.3 or something like that.

Have you seen oracle mode firebird?

One reason is that until very recently you needed Oracle DB to run Compiere. There is a slew of new FOOS DB's in the works for Compiere most interesting it Fyracle the Oracle Mode Firebird

Based on old Borland Interbase

A company is working on a Firebird modification called Fyracle that will allow it to integrate with Compiere.

I have to wonder if you aren't looking for the wrong solution though. Enterprise Resource Planning, for a business your size, is kind of like fishing with grenades. Sure, it will get the job done.....

Wouldn't something like GNUCash with a POS add-on and a inventory database pretty much cover everything?

Don't forget about the FireBird database which is under a renamed MPL v1.1.

Fyracle is a side project that allows FireBird to work directly with Oracle SQL extensions and I believe also their Stored Procedures. It also allows Compiere to work with an open source DB instead of Oracle. Most of the cost was in licensing Oracle in a Compiere solution so this looks very promising.

Compiere at the moment requires an Oracle database, so unless you want to shell out truckloads of $$$, you might want to take a look at Fyracle as covered by /. earlier for a way to make it work with the open-sourced Firebird SQL database.

Or you could do what I did and buy a Qt programming book from orielly and just start using kdevelop. You can also develop your application in java using eclipse. A good place to start would also be using the tk libraties for perl, tkinter for python or tcl/tk. Oreilly has books on all of these.