No-code to the Rescue.
Airtable used to create Security Yearbook 2022

No-code to the Rescue.

I am an engineer at heart. That means I like to build and refine things. I am also a stranger to the world of writing software and creating apps. (Even though I have been coding since I was six years old, and I have led several projects to create apps with lots of moving parts, including a gift certificate ecommerce platform in the late '90s.)

I have found over the years that software "engineering" does not follow the same rules as physical engineering.

Back in 1995-6 I attended the IPSec interoperability meetings in Andover, Massachusetts, and Richardson, Texas. My experience in automotive engineering led me to expect to see a matrix of all the products from the vendors depicting all the tests that were to be run on their VPN solutions. So, Cisco, Check Point, TimeStep, and the other dozen vendors would follow a Taguchi method. (Def.: In the Taguchi method, the objective is to determine a set of controllable factors that minimize the amount of variability caused by perturbation factors.)

No, they did nothing like that. Everyone set up their gear on the same network and started slinging packets at each other. As soon as they established a successful IPSec handshake they were done. They packed up and went home.

It was then that I realized that designing software was dramatically different than designing in the physical world. The world of computers and networks is deterministic. If a thing works it will always work.

A deterministic system has given rise to black-box thinking. If you respond to one of the dozens of Linkedin requests you get from app developers and actually engage with them you will run into this thinking right away. The proposed path is:

  1. Provide a detailed specification of what you want. Include every feature down to the buttons and search queries. Provide "wire frames" for the look and feel of the app on the web and mobile.
  2. A team with a project manager is assigned and they build an app to your specification. You pay them tens of thousands of dollars.

Compare that to the process used in the world I grew up in. Say you are given the task of designing a new latch mechanism for a trunk lid. Yes, there are specifications dealing with weight, cost, materials, cycle testing, safety, and tolerances. But you don't sit down and create finished drawings to ship off to the tool and die makers. That only comes after you have gone through multiple prototype phases.

First you make the proposed design out of cardboard and push pins. Then you model it on a computer. Then you give preliminary designs to the prototype shop to cut out of metal. Then you test the design for function, strength, durability, wear, and fatigue. You may "go back to the drawing board" a dozen times until you are comfortable that the design is ready to go to the prototype tooling stage. Then you make inexpensive tooling and order 100 parts to go through the rigorous safety tests mandated by the regulators or the OEMs.

In the real world tests you survey users of the product and garner feedback like: It's not smooth enough, It does not have a satisfying "clunk" sound. A three year old cannot release it from inside the trunk. You iterate over and over until you are ready to send the final design to production tooling which costs millions of dollars.

Isn't this how creating a new app should work? Start with a concept, build a trial version. Show it to potential users, incorporate the features they would like, build the next version, Iterate until customers agree they would pay for it. Launch a beta version, monitor how it is used, fix bugs, change the work flow to match the real world use. Then, finally perhaps, write a detailed spec for the finished app?

Someone who wants to build a software app is faced with hundreds of decisions before they can specify what to build. What framework to use? What database? What language? How can you make those decisions at the beginning?

This is why the world of no-code/low-code is taking off. If you have used WIX or Squarespace you are familiar with no-code for creating web pages. Many low-code solutions are meant to be used for personal or internal purposes. Oracle's APEX is a way to automatically create an app from a database. It takes minutes to have a working prototype and is free if you are an Oracle Cloud customer.

There are dozens of new tools that serve the world of startup SaaS solutions. Here are some that I have looked into. Most of the suggestions came from the community at /r/SaaS.

Airtable was a universal suggestion. It is a relational database that looks enough like a spreadsheet that it feels familiar. According to Builtwith.com there are over 32,000 sites using Airtable, including Gofundme.com.

Suprabase, which is an open source version of Firebase (Google’s Postgres backend) You can create a SaaS product in minutes from a database. It includes authentication, instant APIs, Realtime subscriptions and Storage.

versoly.com for creating landing pages.?

Logiak.? No code for web/mobile apps ?

pursuitofscale.com is a list of no/low code solutions including:

???https://www.appsheet.com/

???https://www.bildr.com/

Bubble was most often suggested

www.softr.io for building a web app on top of Airtable.

I was already familiar with Airtable so I decided to stick with that for the back end database for my SaaS. In a few hours I built a workable app using Softr on the front end. In the meantime my newly hired intern is moving beyond what I could create with Softr. He is using Bubble. We plan to continue in parallel until one of the platforms fails to deliver the functions we need.

No alt text provided for this image

The above is a chart built in Softr directly from the Airtable database.

No-code is the cardboard and pushpins of app development. It allows you to build the basic structure of a web application and fill in the functionality until you have a Minimum Viable Product. An MVP is something you can show people, even allow them to use it. The critical aspect of building in no-code is that you can also prototype your business model. You can test demand, pricing, and feature sets.

We will stick with no-code all the way through to production. If we hit the limits of no-code solutions we will be in a completely different position. We can write detailed specs and create complete wireframes for a software dev team to work from.

If you want updates on the IT-Harvest Dashboard for cybersecurity signup here. Or subscribe to my Substack at stiennon.substack.com











Richard Stiennon

On a mission to provide actionable insights and foster informed decision-making with complete data on the cybersecurity industry.

1 年

Wow. I wrote this in February, 2022. By March 30 we had launched dashboard.it-harvest.com and had our first subscriber by May 2, 2022. We are still nocode even though we have thousands of workflows and dozens of API endpoints. We are introducing code for data processing as we ingest it.

回复
Mike Betts

Sales Account Manager

3 年

Having worked in this space I can tell you there are some large, scalable solutions built on this tech.?Emerging requirements are also driving adoption; in December Ford published new requirements for PPAP FMEA information flow requiring FMEA software enabling continuity with Foundation FMEAs—no more disconnected spreadsheets.?No-code is a great alternative for some of these transformation efforts.

David Stiennon

Software Engineer. Prestidigitator and Omsbudsman. Cryptozoologist.

3 年

Intriguing!?I've been skeptical of no-code tools before - I see a lot of snake oil surrounding how they're marketed. You make me realize that just because their marketing over-promises, it doesn't mean they're not great tools in the right niche.?I suppose custom app dev shops are the same. You make me want to try a couple of these out.?They might be useful prototyping tools even for professional developers. I feel like we've lost something in coding tools in the last 20-ish years.?The tools for professionals have gotten much better, but we no longer have anything like Visual Basic or FoxPro, where amateurs could build useful things just by tinkering, and it was powerful enough that you could grow your tinkering project into a genuine commercial product.?I met a lot of people who taught themselves to program just by digging into FoxPro or VB. Do you think its possible that No-Code/Low code tools could fill that gap?

Saul Garcia

Founder and CEO @ Mass Data Defense Corporation | ex-Thales Pro Services | Secure Digital Foundations for All

3 年

No code is important.

要查看或添加评论,请登录

Richard Stiennon的更多文章

  • If You Are an Industry Analyst, Please Stop Doing This.

    If You Are an Industry Analyst, Please Stop Doing This.

    Every industry analyst wants to create a new three letter acronym (TLA). It’s just something you do.

    25 条评论
  • Sustainability and Data Security

    Sustainability and Data Security

    As we reach for goals, both personal and professional, it's important to remember the key values that define us along…

    5 条评论
  • A List of Cyber Attacks Against Ukraine

    A List of Cyber Attacks Against Ukraine

    Security Yearbook 2022 will publish the list of Significant Cyber Incidents tracked by CSIS.org.

    2 条评论
  • Which Cybersecurity Sector Grew the Fastest in 2021?

    Which Cybersecurity Sector Grew the Fastest in 2021?

    In 2021, Security Operations was the fastest growing sectors out of the 16 I track. Security Operations includes all…

    12 条评论
  • Cybersecurity Stocks Up 22.2% in 2021

    Cybersecurity Stocks Up 22.2% in 2021

    Every year I check in on the performance of publicly traded cybersecurity stocks. I print a recap of the data in…

  • Cybersecurity Investments Hit All Time High in 2021

    Cybersecurity Investments Hit All Time High in 2021

    Now comes my favorite part of laboring for two months to collect all the data on 2,800+ cybersecurity companies and how…

    5 条评论
  • What to Expect in Security Yearbook 2022

    What to Expect in Security Yearbook 2022

    It’s January. That means pulling together all the elements that go into my life’s work: Security Yearbook.

    6 条评论
  • Use Cases for My Dashboard App

    Use Cases for My Dashboard App

    As we build our amazing app for viewing and analyzing industry data on the cybersecurity vendors I am thinking of all…

    1 条评论
  • Creating the Analyst Dashboard

    Creating the Analyst Dashboard

    When I launched IT-Harvest in 2006 I had a vision for a data-driven analyst firm. The name was inspired by the annual…

    41 条评论
  • Short-listing Cybersecurity Vendors

    Short-listing Cybersecurity Vendors

    I am building what I call The Analyst Dashboard for cybersecurity. In January, for the third year running, I will be…

    16 条评论

社区洞察

其他会员也浏览了