UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> High Level 3-tier Development With Powerapps All In One Hand    
 
   
RobKoelmans
post Sep 21 2018, 03:57 AM
Post#1



Posts: 472
Joined: 25-November 14
From: Groningen, Netherlands


Here's how you create highly professional 3-tier apps with staggering database performance with PowerApps without the need of a Visual Studio Team.

(.wmv files, zipped)

Create Orders - Retrieve Orders In Powerapps

Retrieve From SQL Server Using FLow


Note that there is no layer violation whatsoever, relations are done by bookmark indexes, so not even a record-id is retrieved or submitted by PowerApps. You can load from one database and store to another. Still, you couldn't beat performance if you did violate the layers.

Kind regards,
Rob
This post has been edited by ghubbell: Sep 25 2018, 06:14 AM
Reason for edit: Files are retained locally - good to go. ;-)
Go to the top of the page
 
nvogel
post Sep 21 2018, 04:36 AM
Post#2



Posts: 891
Joined: 26-January 14
From: London, UK


I didn't click on the links. I expect many people will be very reluctant to open something on Google drive unless they know what it is.
Go to the top of the page
 
GroverParkGeorge
post Sep 21 2018, 07:21 AM
Post#3


UA Admin
Posts: 34,084
Joined: 20-June 02
From: Newcastle, WA


I know Rob. There is no problem with his work.
Unforunately, we do have guidelines against external links.

I'll work with Rob to figure out an alternative.
What Rob and his team are doing is really important work, IMO.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Visit My Blog on Facebook
Go to the top of the page
 
isladogs
post Sep 21 2018, 07:45 AM
Post#4



Posts: 774
Joined: 4-June 18
From: Somerset, UK


I did click on the links before they were taken down and had intended to return to them as they did look useful and informative.
Unfortunately I didn't save the links so will PM Rob for details.

I do completely understand the reasons for blocking external links but wonder if at time these are too strictly applied.
Would a compromise be possible whereby any external links have to first be approved by a moderator?
Go to the top of the page
 
nvogel
post Sep 21 2018, 08:17 AM
Post#5



Posts: 891
Joined: 26-January 14
From: London, UK


isladogs, I like your name. Perhaps it is a clue to your location? From my desk in Canary Wharf I can actually see the Isle of Dogs.


Go to the top of the page
 
JonSmith
post Sep 21 2018, 08:20 AM
Post#6



Posts: 3,980
Joined: 19-October 10



If I understand correctly the idea is that external links, whilst posted by a trusted member, can be compromised. UA therefore says no direct download links.
Instead you can redirect to a host page and decide to download there at your own risk.

I think its a sensible approach and completely agree that there shouldn't be exceptions, especially since that undermines the rules themselves too. Why should I follow them if others don't need to, I deserve to be trusted too right. Too much politics, keep it simple, follow the rules.
Go to the top of the page
 
isladogs
post Sep 21 2018, 08:25 AM
Post#7



Posts: 774
Joined: 4-June 18
From: Somerset, UK


I grew up in London but that was a long time ago. Now based in Somerset (Mendips)
Haven't been to Canary Wharf for many years

I have a dog called Isla named before that became popular as a girl's name again due to Game of Thrones (or similar????)
When we named her, lots of people wrongly assumed it was after the Isle of Dogs ....


Go to the top of the page
 
isladogs
post Sep 21 2018, 08:37 AM
Post#8



Posts: 774
Joined: 4-June 18
From: Somerset, UK


Jon
Let me give a practical situation which relates to example apps I've posted elsewhere.

Version 1 (zipped) fitted below the site file size limit so I uploaded it.
Versions 2 & 3 were too big so couldn't be uploaded. Instead I provided links to my website with an explanation of the reason
Version 4 - even the help file was too big to upload!
Splitting a zip file is possible but not always reliable.

One of the reasons why I've uploaded comparatively few example apps at UA as I know external links will be removed.
That's why I suggested moderator approval as a compromise for forum users.
External links for new users would I'm sure be rejected out of hand
Go to the top of the page
 
JonSmith
post Sep 21 2018, 08:40 AM
Post#9



Posts: 3,980
Joined: 19-October 10



Sure, but in your examples, none of them mitigate the risks I laid out.

You can link to your website that hosts these files, you just cannot link to a direct download. I really don't see why thats a big inconvenience really? The links to your site won't get take down unless its a direct download.
Go to the top of the page
 
isladogs
post Sep 21 2018, 08:48 AM
Post#10



Posts: 774
Joined: 4-June 18
From: Somerset, UK


If that's the case, that's absolutely fine but...
1. Someone recently posted a link to a GitHub page containing free Access addins. There was no direct download but the link was removed.
2. The links in this thread were for two video clips. Again no direct download.

Go to the top of the page
 
JonSmith
post Sep 21 2018, 08:50 AM
Post#11



Posts: 3,980
Joined: 19-October 10



Fair enough, thats how I've always seen the download policy enforced. We have plenty of examples of people here linking to their sites and its never been a problem afaik unless its a direct download.
Perhaps there is some nuance with the likes of GitHub which could be clarified and thats why it was taken down? It'd be one for Ghubbel to chime in on I think?

I will say I did report the links in this topic, a google drive link, whether to file or video is pretty much a download so I think its against the rules.
This post has been edited by JonSmith: Sep 21 2018, 08:51 AM
Go to the top of the page
 
ghubbell
post Sep 25 2018, 06:18 AM
Post#12


UA Administrator
Posts: -8,388,320
Joined: 21-April 01
From: Right here.


Rob has permitted us to warehouse the files here - thanks Rob.

They are video files, zipped up to travel. Download with confidence.

Gord thumbup.gif
Go to the top of the page
 
GroverParkGeorge
post Sep 25 2018, 02:09 PM
Post#13


UA Admin
Posts: 34,084
Joined: 20-June 02
From: Newcastle, WA


Thanks, Gord. Thanks, Rob.
Given the direction MS is leading us, this is useful information to have available.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Visit My Blog on Facebook
Go to the top of the page
 
RobKoelmans
post Sep 26 2018, 07:44 AM
Post#14



Posts: 472
Joined: 25-November 14
From: Groningen, Netherlands


We can put the videos on YouTube. Would that help for anyone?
Regards,
Rob
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    12th December 2018 - 12:52 AM