Roadmap for future database support

Posts   
 
    
davisg avatar
davisg
User
Posts: 113
Joined: 27-Feb-2005
# Posted on: 04-Jul-2005 10:47:04   

Hi Frans,

Do you have a roadmap for future database support in LLBLGen? I think this information would be really appreciated by us all.

I know that you are flat out working on the new version of LLBLGen but I think I remember seeing a thread some months back telling us that new database drivers will not start to be developed on until June this year. Is this now scrapped for the time being?

If not I would like to add VistaDB.NET to the list. I know I have gone on about it before but I really do think that supporting as many databases as possible will give you even greater reach in the community. IMHO.

Geoff.

Ps. My own try at getting VistaDB supported before Sybase smile

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 04-Jul-2005 11:23:43   

New databases are moved to v2.0 indeed, with the exception of SqlCE coming in 1.0.2005.1. I'm completely undecided what databases to include in 2.0. The point is that, adding databases cost time and it's unclear if it will bring a lot of new customers on board because of support for these databases. Personally I thought sybase was a good addition, and the driver/dqe is relatively easy, as it's SqlServer 7-esk, though other databases are more requested, like postgresql and vistadb. What I did decide is that we won't support officially databases which can't be tested inhouse, like DB2 iSeries, as we don't have access to an AS/400 here. These drivers/DQE's will be supplied as unsupported 3rd party elements.

Frans Bouma | Lead developer LLBLGen Pro
alexg
User
Posts: 1
Joined: 02-Nov-2005
# Posted on: 02-Nov-2005 13:01:52   

In the "concepts >database drivers" section of documentation i saw: "Note: support for Oracle via the DataDirect provider is phased out. The current builds only support .NET 1.x, no .NET 2.0 builds are considered. Future versions of LLBLGen Pro will target Oracle through ODP.NET or Microsoft's Oracle provider."

We are considering using CoreLab OraDirect to connect to Oracle 8i/9i/10g, instead of ODP for performance reasons. Is there a way to generate code for that driver now or in the future ?

Regards

Alexandre

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 02-Nov-2005 15:54:18   

alexg wrote:

In the "concepts >database drivers" section of documentation i saw: "Note: support for Oracle via the DataDirect provider is phased out. The current builds only support .NET 1.x, no .NET 2.0 builds are considered. Future versions of LLBLGen Pro will target Oracle through ODP.NET or Microsoft's Oracle provider."

We are considering using CoreLab OraDirect to connect to Oracle 8i/9i/10g, instead of ODP for performance reasons. Is there a way to generate code for that driver now or in the future ?

We currently have 3 oracle providers: ODP.NET 9i, ODP.NET 10g and datadirect. For v2.0, DataDirect will be removed, and the MS Oracle Provider will be included instead of that. We won't use any other Oracle providers, and definitely not from Core Lab.

What are the performance problems you have with ODP.NET, I thought it was pretty ok?

Other databases on the list: Postgresql, vistadb, sybase. If time permits perhaps some others, but not likely.

Frans Bouma | Lead developer LLBLGen Pro
swallace
User
Posts: 648
Joined: 18-Aug-2003
# Posted on: 03-Nov-2005 16:58:23   

If you're dropping CoreLab support for Oracle in 2.0, are you keeping it for MySQL or moving to something else?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 03-Nov-2005 18:44:42   

swallace wrote:

If you're dropping CoreLab support for Oracle in 2.0, are you keeping it for MySQL or moving to something else?

I'll keep that one, as it's the only one which works and which isn't GPL-ed simple_smile

Frans Bouma | Lead developer LLBLGen Pro