Advantage Database Server support.

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
4/28/2009 4:30:35 AM
Gravatar
Total Posts 10

Advantage Database Server support.

I think I mentioned this a while ago, but how difficult would it be to add Advantage Database Server support or at least would it be possible for me to add it?

4/28/2009 5:36:18 AM
Gravatar
Total Posts 18439

Re: Advantage Database Server support.

Hi,

Yes, you did ask it before and my answer is stil the same.

http://www.mojoportal.com/Forums/Thread.aspx?thread=1788&mid=34&pageid=5&ItemID=9

Best,

Joe 

4/28/2009 5:38:22 AM
Gravatar
Total Posts 10

Re: Advantage Database Server support.

Thanks for finding the message. I has been a while.

So is it a difficult thing to do?

4/28/2009 5:48:30 AM
Gravatar
Total Posts 18439

Re: Advantage Database Server support.

Implementing support for a new database is a lot of work and maintaining it is a lot of work. If the syntax is similar to one of the other dbs you might be able to do a lot of copy/paste and find and replace to do the initial implementation assuming it has similar ADO.NET providers and helpers.

Might I ask why you are so eager to use this db, what is the big advantage?

I know of someone in the community who said he was going to try and implement support for VistaDB not sure if he has made progress or given up, I haven't heard from him in a while. It seems more compelling in terms of a file based embeddable db because it is all managed .NET code and can run in medium trust environments from what U inderstand.

Best,

Joe

4/28/2009 6:04:43 AM
Gravatar
Total Posts 10

Re: Advantage Database Server support.

It is because my company uses it as it's database.

I could possibly fall back on Firebird but I would rather my portal and desktop app sit on the same database.

It is one of the reasons that has put me off DotNetNuke.

It does seem there is an attitude in the .NET world that some developers only use Microsoft tools. The real world is somewhat different.

Only N2Cms seems to support a lot of databases due to the fact that is uses NHibernate.

 

4/28/2009 6:27:16 AM
Gravatar
Total Posts 18439

Re: Advantage Database Server support.

People often assert that  using NHibernate means you support lots of dbs but when you start actually supporting more dbs you find that the schemas are not identical across systems because data types are not always identical (ie native Guid vs char(36)) so the mapping files needed for different db platforms under NHibernate will not always be the same across db platforms.

If you like N2 and it can really support your db then you should use it. N2 as far as I see only supports MS SQL and MySql, I don't accept the premise that it supports lots of dbs just because it uses NHibernate. If I see people actually using it and it working correctly on more db platforms without platform specific bugs then I will believe it. The problem is you do run up against platform specific issues and using NHibernate you hit a brick wall until they fix it (unless you understand its deep internals and can fix it yourself) whereas using traditional non-OR Mapper approaches its easier to fix it yourself.

No project that I know of actually supports more dbs than mojoPortal. We support 5 db platforms and they really work.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.