Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Products › Development › Forge › Provider - Firebird® Register  |  

 

Project Avatar

 

  Team Leadership  

Sanjay Mehrotra
( Team Leader )

SanjayMehrotra.jpg

Michael Washington
( Core Team Sponsor )

MichaelWashington.jpg

 


  Team Members  

 

 


  DotNetNuke Projects  
The DotNetNuke Projects are a special category of platform extensions which are developed by volunteers to conform to the high professional standards mandated by DotNetNuke Corporation. The DotNetNuke Projects are distributed as a standard part of the DotNetNuke core application release offerings.

 


Engage Software - Training Partner for DotNetNuke
  Ads  
Active Modules -- Active Forums for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
 


DotNetNuke® Project :: Firebird® Provider

DotNetNuke can currently be run on at least two database platforms - Microsoft SQL Server and Oracle. In the 2x days of DotNetNuke, it was also possible to run DotNetNuke using Microsoft Access which was more easier/familiar to the some of the community than SQL Server or Oracle.

The Firebird® Data Provider is a new sub project under the core which will allow DotNetNuke to run using a Firebird Database.  Firebird® is a relational database which runs on Linux, Windows and other flavors of the Unix Platform. It is ANSI SQL compliant and has a very small footprint in comparision to MS SQL Server or Oracle. It can also be run in an embedded mode requiring little or no interaction from the end user.
The goal of the Firebird Data Provider is to offer yet another alternative for DotNetNuke users who do not wish to use SQL Server or Oracle.

For those interested, you can get some more information on Firebird® from here.

This project was started by various volunteers with the desire of offering another viable alternative for DotNetNuke and thereby increase the overall usage of DotNetNuke. A large portion of the provider was contributed by Sanjay Mehrotra who also is the author of the Oracle Data Provider.

 


Team Lead Blog
Jan 31

Posted by: Sanjay Mehrotra
1/31/2007

After a lot of thought and discussion with other core team members, I have decided to discontinue the development of the firebird dataprovider project (under the DNN core projects) due to the following reasons
·         Limited or no additional resources have been willing to help out to completing the last piece left before we could release this to the general public (i.e. the ability of creating the foreign key constraints in Firebird during the creation of the tables/procedures – Firebird 1x had a restriction where only a single user can be connected to the database during the creation of the foreign key constraints. Due to the connection pooling nature of web applications, it was not possible to bypass this requirement (at least as far as I know).
·         Related to the first item, I could have attempted to finish this piece off, however when we started this project, I had assumed that other volunteers will sign up with us to maintain this project moving forward. There were a few people who helped out in the early stages (and my deep thanks to them for helping out), but for one reason or another, most of them are no longer actively involved with the provider.
·         SQL Server Express has been released as a free database and one of the compelling reasons when we started off this project was to be able to run DNN (open source application) on a free database (i.e. Firebird).
·         Ability to be able to support the numerous modules that come with the core is a mighty task for just one person – I know this from personal experience managing the oracle version of DNN and I honestly don’t believe I can carry on with two dataproviders solely by myself.
·         Lack of interest in the general DNN community.
 
My thanks go to Michael Washington (especially) and other core team members for supporting me in trying to develop this project and I look forward to working with the core on other projects as well as any other tasks that come up on an ongoing basis.

Tags:

Re: Retiring the Firebird Project

Sorry we couldn't get this completed - I think with all the traveling and short resource time on this project was the down fall. The FK constraint problem appeared to not be an overcomeable hurdle. I would like to thank Michael and Sanjay for making me a part of the team and look forward to working with them again.

By gleonardo on   2/1/2007

Re: Retiring the Firebird Project

Sorry to see this be retired. If in the future we want DNN to run under mono and it does work, people will then want a DB provider that will also work under Mono. The reason for this is that most people will want to run DNN under mono so they have a totally free implementation running under Mono. Hopefully someone will will take up the torch again and get a stable DB provider for at least one of the enterprise DB out their (MySQL, Postgres, Etc).

P.S. Although you can use SQL Express for free, I personally would never use SQL Express for a production site (dev only).

By smehaffie on   2/2/2007

Re: Retiring the Firebird Project

I would still like to be able to complete this but at this point don't have a choice since I can't find any other developers that will help me in supporting it. With the amount of core modules and core functionality to maintain, it becomes a nightmare (considering also that I actively support the Oracle version too)...
Maybe in the future when I have some spare time (and I'm sure a lot of us in the IT industry have that), then I can try and at least get the core working and maybe some of the modules too...

By smehrotra on   2/2/2007

Re: Retiring the Firebird Project

Sanjay,
Would it be possible for you to forward me or "make available" the work you've already done on this project? I would like to help if possible.

Regards, RP

By APA.RPrice on   10/4/2007

Re: Retiring the Firebird Project

I beleve that the most usefull feature of FireBird for DNN is the "Enbeded" DataBase, implementing that DataProvieder could save SQL hosting expenesess

By BRomeroT@hotmail.com on   10/4/2007
 


DNNCovered.com - Your Offshore Dotnetnuke Partner
Dnncovered.com is the only Dotnetnuke offshore outsourcing center specializes in DNN skinning and module development with lowest pricing and quality service. Our staff is dedicated to websites based on DNN and our graphic designers are creative and imaginative well enough to provide customers the complete set of skinning solutions and packages
www.dnncovered.com
PointClick.Net DNN Solutions
DotNetNuke Hosting Platform for Business and personal use.
PointClick.Net Hosted Solutions
Advanced Web Portals by Infoscaler
Infoscaler is a California based company that provides advanced Web Portals, E-commerce Sites, Database Applications and Intranet Solutions on the DotNetNuke and Microsoft.NET platforms.
www.infoscaler.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP