💧🌏 Greg Cocks<p>Data Manipulation Initial Planning Is A Crucial Aspect Of Any Project, & It's One Of My Favourite Parts!</p><p>I still prefer to do this phase 'old school', with a large piece of (portable) paper, pencil, and eraser, revisiting and adjusting as needed, often the next day as it has percolated overnight...<br />During this phase, I list constraints, data validation needs, design a broad framework, and determine interactions while trying to future-proof as much as possible. I bring in my requirements and questions from my initial JIRA ticket(s) - and then use these to develop and evolve business rules, along with a process diagram construction.<br />From there, it's all on to SQL and manual testing in PostgreSQL + PostGIS and finally prototype app construction - for the devs to then take and make it work fast and well!<br /><a href="https://techhub.social/tags/datamanipulation" class="mention hashtag" rel="tag">#<span>datamanipulation</span></a> <a href="https://techhub.social/tags/projectplanning" class="mention hashtag" rel="tag">#<span>projectplanning</span></a> <a href="https://techhub.social/tags/SQL" class="mention hashtag" rel="tag">#<span>SQL</span></a> <a href="https://techhub.social/tags/PostgreSQL" class="mention hashtag" rel="tag">#<span>PostgreSQL</span></a> <a href="https://techhub.social/tags/PostGIS" class="mention hashtag" rel="tag">#<span>PostGIS</span></a> <a href="https://techhub.social/tags/gis" class="mention hashtag" rel="tag">#<span>gis</span></a> <a href="https://techhub.social/tags/spatial" class="mention hashtag" rel="tag">#<span>spatial</span></a> <a href="https://techhub.social/tags/mapping" class="mention hashtag" rel="tag">#<span>mapping</span></a> <a href="https://techhub.social/tags/datavalidation" class="mention hashtag" rel="tag">#<span>datavalidation</span></a> <a href="https://techhub.social/tags/requirements" class="mention hashtag" rel="tag">#<span>requirements</span></a> <a href="https://techhub.social/tags/businessrules" class="mention hashtag" rel="tag">#<span>businessrules</span></a> <a href="https://techhub.social/tags/futureproofing" class="mention hashtag" rel="tag">#<span>futureproofing</span></a> <a href="https://techhub.social/tags/futureproof" class="mention hashtag" rel="tag">#<span>futureproof</span></a> <a href="https://techhub.social/tags/app" class="mention hashtag" rel="tag">#<span>app</span></a> <a href="https://techhub.social/tags/development" class="mention hashtag" rel="tag">#<span>development</span></a> <a href="https://techhub.social/tags/oldschool" class="mention hashtag" rel="tag">#<span>oldschool</span></a></p>