Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Thu Feb 10 15:40:37 CST 2011
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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil Salakhetdinov Sent: Thursday, February 10, 2011 11:01 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] From a reader Hi Jim -- Thank you for your reference on 1st JavaScript Editor. I have question on jQuery, which I'm not familiar with at all, and RESTFul web services, which I know just a bit of: - assuming I have a RESTFul webservice performing whole CRUD set of operations for a given datamodel/database - would it be possible (in principle) to develop a pure HTML + jQuery web application with paged (datasheet) forms and usual view/add/edit,delete forms - are there any jQuery samples for such solutions? 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 ?. 3:21 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] From a reader I write a lot of an application with VS but then go in and clean it up and speed it up with a healthy dose of manual intervention. :-) I love the programmers notepad as it produces nice structure, a bit of code validation and does not suck up 2GB of RAM and then there is a little JavaScript IDE called the 1st JavaScript Editor (It costs a few bucks but worth it) and finally Firefox's' Firebug. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Wednesday, February 09, 2011 10:37 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] From a reader Hi Shamil and Jim > And "Razor(CSHTML)" seems to be so much classical ASP like? Yes, but who - except for Drew - is writing code this way these days? I know you can create a complete site with Notepad only and lots of handwork but why? Don't you use Visual Studio or the like to create the in-line code? /gustav >>> shamil at smsconsulting.spb.ru 09-02-2011 12:24 >>> Hi Jim -- MS does realize the issues "bound" to classical ASP.NET view engine - they seems to have a solution: Introducing "Razor" - a new view engine for ASP.NET http://weblogs.asp.net/scottgu/archive/2010/07/02/introducing-razor.aspx It "works with any Text Editor: Razor doesn't require a specific tool and enables you to be productive in any plain old text editor (notepad works great)." :) Well, but this "Razor" view engine seems to be bound to ASP.NET MVC? No, wait.... "Razor" view engine and DNN - they say it will be part of DNN 5.6.2 http://www.dotnetnuke.com/Resources/Blogs/tabid/825/BlogID/15/Default.aspx So - ASP.NET - "Razor" View Engine - jQuery (it's supported by MS) ===================== Totals as a very advanced yet lightweight, fluid (flexible) Web development platform resulting in clean HTML "by definition"? (I'm kidding about the latter of course - one have to be very skilled in HTML and CSS to produce clean HTML IMO). And "Razor(CSHTML)" seems to be so much classical ASP like? Thank you. -- Shamil