[Mono-list] Re: Mono-list Digest, Vol 9, Issue 50

[Joseph Hill]

Although I primarily did the work for the Mono Live CD, seeing mojoPortal
run on the Nokia 770 was one of the big drivers for my recently adding
Sqlite support to mojoPortal.  Hopefully I'll have a chance to try it out
on the 770 soon (either by picking up my own, or perhaps I will be able to
get Paco to let me experiment on his ;-).  If someone else manages to do
it first, I definitely look forward to seeing it.

I completely understand why Joe would not want to maintain any more data
layers for mojoPortal, and, in fact, I almost didn't do the Sqlite work
because of that, except that I think there are so many good uses for an
embeddable portal, including the 770, network devices, and of course, CDs.

That being said, if you need support for another database, mojoPortal is
well suited to handle it, and all of the tools you need to do the port and
maintain it are easily accessible. If anyone decides to do so, and has any
questions, please feel free to ping me.

Also, Joe, I have to agree with you:  I think that the trade-offs versus
using an ORM were worth it.

I'll probably roll this up into a blog post this evening.

- Joseph


> Date: Fri, 27 Jan 2006 14:31:02 -0800 (PST)
> From: Joe Audette <joe_audette at yahoo.com>
> Subject: Re: [Mono-list] Mono and Nokia 770 and mojoPortal
> To: Daniel Morgan <monodanmorg at yahoo.com>,
> 	"mono-list at lists.ximian.com" <mono-list at lists.ximian.com>
> Message-ID: <20060127223102.7132.qmail at web30004.mail.mud.yahoo.com>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi Daniel,
>
> I'm happy to answer the mojoportal question, someone else will have to
> take on the others, though I'm pretty sure that SQLite can be embedded in
> a device.
>
> To support additional dbs it would require someone to implement a data
> layer and keep it up to date with new methods over time so supporting more
> is a bit of a maintenance issue. I implemented the intial MS SQL and MySQL
> dbs for mojoportal, Jospeh Hill implemented the initial pgsql version and
> the newer SQLite version but I will be maintaining them over time most
> likely. I'm not sure I want to commit to maintaining any additional ones
> myself but anyone willing is more than welcome. All the current ones have
> similar Helper classes that make it fairly easy and make the code somewhat
> similar between dbs.
>
> I could have used an OR Mapper and that would probably have made it easier
> to add more dbs but for a number of reasons I chose to implement
> independent DALs instead.  I've been working a lot with an OR mapper in my
> new job and I do like the rapid development aspect of it but I am still
> glad I chose not to do that in mojoportal for a number of reasons I won't
> ramble on about unless you're interested.
>
> If implementing a DAL for the db of your choice in mojoportal seems to big
> a task, you might want to look at the Cuyahoga project which uses
> NHibernate. I think it is a very well concieved project even if I follow a
> different approach myself. I'm not sure whether the dbs you are asking
> about are implemented but implementing an NHibernate provider for a new db
> may be less work than implementing all the methods for mojoportal.
> http://www.cuyahoga-project.org/
>
> I would think the MS SQL layer could easily be converted for Sybase but
> maybe I'm off base, I know they have a common heritage.
>
> Hope that helps,
>
> Joe
>
> joe_audette [at] yahoo dotcom
> http://www.joeaudette.com
> http://www.mojoportal.com
>
>
> ----- Original Message ----
> From: Daniel Morgan <monodanmorg at yahoo.com>
> To: "mono-list at lists.ximian.com" <mono-list at lists.ximian.com>
> Sent: Friday, January 27, 2006 3:20:37 PM
> Subject: [Mono-list] Mono and Nokia 770 and mojoPortal
>
> Please bear with me. I could have written a blog entry, but writing an
> email is so much easier.
>
>   Nice to see Paco running Peditsharp on the Nokia 770.  Now, can sqlite
> run it on too.  If yes, I would like to see a Mono application that
> retrieves data from a sqlite database and displays it in a gtk# data
> grid (treeview/liststore).  Is it possible?
>
>   I see mojoPortal has support for a lot of databases.  What would someone
> need to get it to work with other databases, such as, Oracle, Sybase,
> Firebird, or DB2?
>
> Do you Yahoo!?
>   With a free 1 GB, there's more in store with Yahoo!
> Mail._______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>