<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hi,</p>
<p>In our GIS team (small team of 10, local government, province level) we use a lot of SQL in collaboration with Gradle/GRETL and Jenkins for our automated data flows and statistics. It is amazing how much analysis and data aggregation you can do with SQL only - without having to touch QGIS or ArcGIS or any other so called "business intelligence" tools (that are often quite expensive).</p>
<p>Every new employee that wants to join our team has to have SQL knowledge - that's a prerequisite - or they wouldn't get the job. Most of our employees are not programmers though.</p>
<p>I also teach PostgreSQL/Postgis training courses (2-3 days usually) - a lot of the participants are not programmers but still manage to do analysis with SQL. Typical course participants are scientists, people working at engineering companies or government.</p>
<p>So - I do think there is a significant number of people who use SQL, but aren't programmers.</p>
<p>Andreas</p>
<p id="reply-intro">On 2020-09-25 00:09, ruvenml@beamerbrooks.com wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<div id="replybody1">
<div><span style="font-family: Helvetica, Arial, sans-serif;">I doubt whether PostGIS has any direct value whatsoever for desktop application users. At a very minimum, using PostGIS directly requires a knowledge of SQL. In fact, the more knowledge of SQL a user has, the more powerful PostGIS will be. SQL is usually taught in a database course which, in many computer science curriculums, is taught in the second or third year, not to end users in another occupation.<br /><br />Business intelligence systems such as Power BI and Tableau can connect directly to PostGIS data bases and provide end user commands and operations for querying and modifying those databases. GIS systems such as ArcGIS and QGIS provide similar capabilities. End users can get nearly all of the power of PostGIS without having to learn anything outside of the business intelligence system or the GIS system. <br /><br />PostGIS is probably best reserved for people who have a programming background and whose jobs or avocations involve doing things that are difficult or impossible to do in existing business intelligence or GIS applications. There seem to be more than enough people like that to keep the PostGIS developers quite busy.<br /><br />Ruven Brooks<br /><br /><br /><br /><br /><br /><br /><br /></span><br />
<div class="v1moz-cite-prefix">On 9/24/2020 3:58 PM, Shaozhong SHI wrote:</div>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<div dir="ltr">Though we have got some good examples of serving data to wider business intelligence community, we are still interested in finding excellent, compelling examples for showing the value of PostgreSQL/PostGIS as a data service to desktop application users.
<div> </div>
<div>I just wonder whether there are excellent examples, for general users to appreciate?</div>
</div>
<br /><fieldset class="v1mimeAttachmentHeader"></fieldset>
<pre class="v1moz-quote-pre">_______________________________________________
postgis-users mailing list
<a class="v1moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org" rel="noreferrer">postgis-users@lists.osgeo.org</a>
<a class="v1moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
</div>
</div>
<br />
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">_______________________________________________<br />postgis-users mailing list<br /><a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br /><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></div>
</blockquote>
<p><br /></p>
</body></html>