Mail App communication with database

Question

Hello,

I am planning to develop a mail app which will have a communication with database... I have few questions related to database.

1) Is it possible to use database in our mail app?

2) What database is very much suited for mail app?

3) How we can deploy our mail app if it have a database?

Thanks

Answer 1

Hi SSun1979,

1) Is it possible to use database in our mail app?

I think it is possible, since it's javascript & jQuery based.

2) What database is very much suited for mail app?

It depend on your request, I suppose.

3) How we can deploy our mail app if it have a database?

You can try to create a sample first, I suppose it will be same as those which do not have related database.

Best regards,

---

John

Answer 2

Hey SS - how goes? As to database - it depends :-)

For a local database I'd use browser local storage (or, depending on your browser support matrix the Indexed Database API - this is in Win8/IE10 and IE10 will be on Win7 t some point soon)

For a remote database you need something that you can communicate with from a web page over HTTP - these days the oData protocol seems to be the most popular way to do this - see http://msdn.microsoft.com/en-us/data/gg192995.aspx for an example with SQL Server from Microsoft (and SQL Azure also supports oData access) but I'm sure other vendors will offer their own implementations.

We also have JavaScript libraries to help you connect - see: http://blogs.msdn.com/b/astoriateam/archive/2011/02/08/new-javascript-library-for-odata-and-beyond.aspx

Hope this helps...pc