FirebirdSQL support

Hello, dear MODx devs!

Please can you provide support for the free opensource FirebirdSQL Database system?
If you need more information about it look here: http://firebird-datenbank.de/]http://www.firebirdsql.org/[url]. Same in german:[url]http://firebird-datenbank.de/" target="_blank" rel="nofollow">. Same in german:[url]http://firebird-datenbank.de/]http://www.firebirdsql.org/[url]. Same in german:[url]http://firebird-datenbank.de/

It is much better than MySQL or MSSQL, because it is free opensource and secure. But the most important argument for FirebirdSQL support in MODx is, that it is also a great project like MODx that follows the ideals of opensource technology.
I like it very much.

FirebirdSQL features:

• A thorough reworking of indexing to ramp up performance and minimise bottlenecks in searching and matching
• Several limitations inherited from the legacy code have now gone, such as the 252-byte limit on index size and the 30 Gb limit on table size.
• A new interface for plugging in international character sets, including enhanced Unicode support, along with a number of new and corrected collations
• 64-bit platform support with released binaries available for AMD64 and Intel EM64T on Linux. Windows 64-bit builds are ready for testing and will follow in a sub-release
• An intense makeover of server security, including beefed-up password encryption and inbuilt protection for brute-force attack
• Support for SQL200x derived tables, including multi-level nesting and joining of subqueries
• EXECUTE BLOCK syntax to enable blocks of procedural SQL (PSQL) to be executed in dynamic SQL statements
• Explicit cursors in PSQL, also available inside EXECUTE BLOCK statements
• Optional WAIT lock conflict timeout, available as both a SET TRANSACTION argument and as a transaction parameter in the API
• All-new incremental backup capability
• Complete re-architecting of "serverless" local connection protocol on Windows to eliminate the inherent instability of the legacy IPServer protocol
• Fully completed implementation of the Services API on all platforms

More Details:[url=http://www.firebirdsql.org/index.php?op=devel&sub=engine&id=fb20_release]http://www.firebirdsql.org/index.php?op=devel&sub=engine&id=fb20_release

The only disadvantage of Firebird-RDBMS is that coding stored procedures or triggers is not easy and coding UDFs(User Defined Function libraries) is very difficult even for advanced programers.
But that’s all and anyway not important for the typical web-developer.

Here is a FACT sheet, ie. for your chef: http://www.firebirdsql.org/guide/FBFactsheet.html

And MySQL is not "free opensource and secure"?

MYSQL is free, but look at MYSQL’s weird licensing and it is not opensource.
And fact is that MYSQL it not free for all! I don’t understand their policy, but I know that using their dlls is prohibited to commericial customers only.

http://www.mysql.com/company/legal/licensing/
For Open Source Projects:
If you are developing and distributing open source applications under the GPL License, then you are free to use MySQL under the GPL License.
If you are developing and distributing open source applications under an OSI-Approved License, but not the GPL, MySQL provides the GPL License with a FLOSS Exception.

For Commercial OEMs, ISVs and VARs:
For OEMs, ISVs, and VARs who distribute MySQL with their products, and do not license and distribute their source code under the GPL, MySQL provides a flexible OEM Commercial License.

For Web Sites, Enterprise IT, and Government IT:
MySQL Network is the comprehensive subscription offering that provides database developers and DBAs with everything they need to successfully develop and deploy database solutions with MySQL. It includes Certified Software, updates and upgrades, proactive alerts and advisors, the online MySQL Knowledge Base, and full production-level technical support. The Certified Software (database server, connectors) is provided under the GPL License. Optionally, customers may choose a Commercial License.

If you are developing and distributing open source applications under the GPL License, then you are free to use MySQL under the GPL License.

Again, MySQL is not open source?

By definition GPL is open source.

If you want to distribute MySQL in a commercial application and thus do not want to use the GPL, you can get a different license from them.

Quote from: rthrash at Dec 02, 2006, 02:48 PM

If you are developing and distributing open source applications under the GPL License, then you are free to use MySQL under the GPL License.

Again, MySQL is not open source?

The different license is what I’m talkin about. Don’t you see that limitation? I like apps with no limitation more than apps with. so..
What if not? What, if you code commericial stuff, or need a mysqlcluster or full mysql capabilities like that MaxDB offers?
Then there is not alternative except FirebirdDB!
hihi

First of all, after reading their website, this seems slightly less agile and much less robust than SQLite. Secondly, as most people who read the forums before posting already know, the core of MODx is moving to xPDO, and xPDO’s database abstraction will make using any database you choose to use possible. As long as we seem to be on the subject of posting links to our favorite sites, let me jump on.

Manager times, helpface.url, funplace.olm, neatfeature.corn, modxneedsthis.modx, dothisforme.place, helpidontliketopayattention.co.jk

-sD-

And http://www.alienlovespredator.com/index.php

I haven’t heard ’bout xPDO for a long time now, lol I thought you just used parts of it in modx actually.
But It’s a different branch of modx right?
modx cms
modx cms xpdo core

and..
It was a wish only, if you don’t like FirebirdDB it is ok.  8)
I used some other cms before modxcms and they offered support for more RDBMS systems, that’s why I ask you to add support ie. for Firebird. That was no critics dudes

so the problem is solved and the wish is accepted =))

Quote from: sottwell at Dec 02, 2006, 02:58 PM

And http://www.alienlovespredator.com/index.php

Susan...
I need a new spleen after viewing your last link! Mine is now broken I laughed so hard.
Funny thing is it appears to be GPL, which is not open source, so I don’t know if you can link to it.

-sD-