[AccessD] From a reader

Hi Shamil and Jim

Of course, as a developer, you have to be curious and look around searching to keep up and be familiar with the trends ... but aren't you two constantly beating yourself by fiddling with semi-boiled frameworks and techniques? For my part, just trying to get up to speed with Visual Studio 2010 and Silverlight and EF and (still) some Access and ... can keep me more than busy.

/gustav


>>> shamil at smsconsulting.spb.ru 10-02-2011 22:40 >>>
Hi Jim --

Thank you for your reply.

AFAIK MS is one of the leaders in this area: WCF Data Services (OData -
http://msdn.microsoft.com/en-us/data/bb931106) naturally support RESTFul web
service concept and WCF Data Services can implement full CRUD set of
operations for a given entity datamodel/database using ... yes, ADO.NET
Entity Framework (http://msdn.microsoft.com/en-us/library/bb399572.aspx) -
all that stuff can be generated within VS2010 AFAIU...

And as I have just found there already exists "New JavaScript library for
OData and beyond"
(http://www.odata.org/blog/2011/2/9/new-javascript-library-for-odata-and-bey
ond).

The part which is missing is HTML forms generator for the HTML forms to be
used together with jQuery and RESTFul Data Services (for the same entity
datamodel/database) - I guess IronSpeed (http://www.ironspeed.com/) will
make something like that soon...

Then all the raw stuff can be generated for custom applications? And here
you are with your advanced skills to customize raw stuff produced by code
generators?...

As for security - HTTPS doesn't solve this issue? I mean if a user gets
authenticated by entering their user name/password (or use LiveID or ...) to
setup an HTTPS session between browser and web server what could malicious
users do here? Why VPN is considered more secure there?


Thank you.

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: 10 ??????? 2011 ?. 23:44
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] From a reader

Hi Shamil:

That is a series of good question. I am basically unfamiliar with the
RESTful concept as, interesting enough; it only caught my eye a couple of
days ago. There are a number of people working a GNU JQuery RESTful API but
there are not finished products out there yet, that I am aware of. For
example:

http://mike-hostetler.com/representational-state-transfer-rest-client-testin 
g

JAVA and PHP programmers seem to be a little ahead in this right now. All
the major site have FEs build: Facebook, Amazon, EBay etc.

As for a full database interface with all the bells and whistles, a complete
CRUD type thing; again no complete interface. I have my own ASP.Net/JQuery
hybrids. Here is one of my sources for the initial base code but I have
removed much of the BE direct processing and replaced that connection with
JQuery AJAX calls:

http://www.dotnetfunda.com/articles/article970-aspnet-gridview--jquery-tips- 
and-tricks--part-1-.aspx

There are many other ones out there again using PHP/JAVA. For example:
(watch the wrap..)

http://www.prodevtips.com/2010/01/10/simple-jquery-and-php-crud-interface/?u 
tm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+prodevtips/LVkG+(Pro
DevTips+-+dev+related+notes+and+tutorials)
...and...
http://www.ifadey.com/2010/07/crud-using-jquery-and-codeigniter-iii/ 

Connecting to the database can always be a danger as if some outside and
unauthorized individual gets access to your UI they may find a way to hack
in. To that end most of my clients run their sites as only Intranet or
through their company VPNs. Recently, I was shown an excellent open source
GNU product at: http://openvpn.net/ (You do have to pay for multiple remote
connections as it is needed to cover the company's hardware costs but it is
really cheap.)

This functions similar to Hamachi/Logmein and allows you as the senior tech
to encompass a fixed set of users and offices anywhere in the world.

I am currently working on a JQuery POS (header/detail/footer), in my spare
time but it is turning out to be a huge time-consuming project, with many
re-writes, as I continue to learn more, with hundreds (thousands?) of lines
of code...all the heavy lifting, like the data management will be done at
the back end.

Jim