support for SQL CE

This is a forum to suggest new features for mojoPortal. 

This thread is closed to new posts. You must sign in to post in the forums.
11/21/2008 8:11:33 AM
shev72
Gravatar
Total Posts 17
View Posts

support for SQL CE

It might be nice to have support for SQL CE, I might look into this myself if I have some time.  The types are very similar to SQL Server so it should not be too hard.  The main advantage of SQL CE is that it is a file DB much like SQL Lite, so operations such as DB backup and general maintenance are much easier. Unfortunately with SQL Lite we cannot take advantage of LINQ right now, also there is no support for foreign keys in in SQLite.

11/21/2008 8:21:27 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: support for SQL CE

Maintaining a data layer is a big job. If you plan to implement it and maintain it go for it, but the project will keep on changing and it will constantly need updates to keep it working. I think its a very corner case using SQL CE, a lot of work and very few people would use it.

There is some linq to db stuff in the Mono project that might work with SQLite. VistaDB support would be more desireable than SQL CE. Unlike SQLite, VistaDB can work in medium trust hosting (or so I've read). In any case its a lot of work supporting additional databases. I have no immediate plans to support additional ones myself.

Best,

Joe

11/21/2008 8:22:36 AM
Slaven Brumec
Gravatar
Total Posts 55
View Posts

Re: support for SQL CE

What stops you now from using SQL CE or Linq in your custom module that just gets plugged-in into mp? I do something similar - use Linq to SQL for my custom project.

11/21/2008 8:27:25 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: support for SQL CE

Hi Slaven,

I think the difference is it would not be in the same db as the site since the site doesn't support SQL CE.

Best,

Joe

11/21/2008 9:14:42 AM
shev72
Gravatar
Total Posts 17
View Posts

Re: support for SQL CE

Hello thanks for you rreally fast answers!

 

I hunted around a bit and it looks like that support for linq to sqllite is imrpoving, there is a project on sourceforge which looks quite mature, here is the linq in case others are interested.

 

http://sqlite-dotnet2.cvs.sourceforge.net/viewvc/sqlite-dotnet2/SQLite.NET/System.Data.SQLite.Linq/?sortby=author

 

With this, I agree that SQLCe, won't be that popular, sqlite is open source, which is always a plus.  I will definitely be testing this out with Mojo.  thanks for providing this CMS open source.

cheers,

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