News for hackers. Stuff that matters.
Re:The No-Code Generation is arriving by Retric on Tuesday October 27, 2020 @11:25AM (#24908303)
Excel is still the biggest and most successful no-code tool. The real problem with no code, is the tools take a lot to learn well and it rarely transfers between roles at the same job.
Re:The No-Code Generation is arriving by tabtab on Tuesday October 27, 2020 @11:31AM (#24908360)
I've seen end-user-built-app Excel code enough times to have a distaste. Maintenance is 2/3 of average software cost, and that [bleep] ain't maintainable. It's good for prototyping, but shouldn't remain in production for anything of importance.

As far as general "low code" or "no code", I've seen that promise for many decades. They keep reinventing failed ideas under new names. Clickable wizards, rule lists, and drag-able flow-charts can only take you so far. The devil is in the details, and these don't handle details well. And they are hard to factor.

Your Uncle Bob may be able remodel your house for cheap, but what do you do when rain leaks in and the lights stop working? Or worse, catch on fire?

Remember: Total Cost of Ownership.

Re:The No-Code Generation is arriving by samhain on Tuesday October 27, 2020 @11:45AM (#24908523)
There was a post on here a few weeks ago that discussed code as the translation between the desire for a particular behavior from the person coding, and the machine instruction that needs to be executed. The comment section had a video of Guy Steele talking about growing computer languages, and was trying to make an argument for Computer Science Metanotation being one of them. [1]

He started of the talk describing Regex, and how it came to be, and basically showed how that functions have been/could be formally described in papers the same way that Regex is used.

In the same way regex formalized the notation for string parsing, so too will the next language regular function expression formalize. Perhaps computer meta notation is the source of true no-code solutions? Perhaps instead of reading articles about "The Unreasonable Effectiveness of Regex," in the future, we'll be reading about "The Unreasonable Effectiveness of Computer Science Metanotation."

I also understand that what no-code solutions we are typically talking about is a user interface that is graphical, drag-and drop. But who is to say we don't create a tool that does that with CSM?

[1]: https://www.youtube.com/watch?v=qNPlDnX6Mio&ab_channel=Erlan...

Re:The No-Code Generation is arriving by tabtab on Tuesday October 27, 2020 @11:49AM (#24908572)
I find declarative and functional (D/F) code is often difficult to debug. It's generally easier to break imperative code into fractal-like steps, sub-steps, sub-sub-steps etc. D/F just can't be dissected fractal-ish like that nearly as easy. It's just a magic property of imperative code that's hard to replicate in other paradigms. It's why imperative still dominates after 50+ years of D/F attempts.

Someone once said that D/F makes it easier to express what you intend, but imperative makes it easier to figure out what's actually happening. One improves writing, the other improves reading (or at least debugging).

Re:The No-Code Generation is arriving by ssivark on Tuesday October 27, 2020 @05:00PM (#24911832)
On the other hand, imperative code sometimes makes it very difficult to compare what is happening with what you want to happen (problem specification).
Re:The No-Code Generation is arriving by michaelmrose on Tuesday October 27, 2020 @04:59PM (#24911812)
One can still break a larger function into smaller ones and use a debugger to see intermediate values.
Re:The No-Code Generation is arriving by thisisnico on Tuesday October 27, 2020 @11:29AM (#24908334)
And some of the most advanced Excel spreadsheets make use of Visual Basic to automate processes. Even with no code solutions, The most advanced users will want to automate and integrate, using code.
Re:The No-Code Generation is arriving by open-source-ux on Tuesday October 27, 2020 @11:56AM (#24908669)
"Excel is still the biggest and most successful no-code tool"

What's interesting is that many users build quite complex formulas and spreadsheets, yet Excel's formula and VBA syntax is (in my opinion) harder to learn than other programming languages. For example, I'd argue a language like Ruby is simpler in many aspects than using VBA or building complex formulas.

Like Microsoft, Google Sheets also has quite an ugly, clumsy feel to its syntax.

The terrible programmable usability of these products (Excel and Sheets) could only have come from the mind of a developer (harsh I know, but true).

Re:The No-Code Generation is arriving by Retric on Tuesday October 27, 2020 @03:14PM (#24910744)
I don’t think most people have issues with programming because of syntax. It’s the lack of visual feedback that’s making things so difficult. Click on one of those cells and it’s color coding which cells make up that formula. Sum(everything in this box) is really easy to get where a foreach loop doing the exact same thing is more abstract.

People just kind of default to {do some magic} on [various things] -> (Some result that looks about like I was expecting).

What’s really interesting is Spreadsheets tend to have bugs where the result is incorrect but reasonably close to reality. Aka 38 vs 35 not Null Pointer Exception, this makes them in many ways seductively dangerous in a this looks close therefore it must be easy to fix way.

Re:The No-Code Generation is arriving by benhurmarcel on Wednesday October 28, 2020 @07:26AM (#24917525)
My company is pushing Python to mechanical engineers as an alternative to complex spreadsheets (with many sheets, complex formulas, and VBA). In practice it's already a massive pain to just get a working installation with the correct modules. Even if I make a working script, 95% of my colleagues can't run it. While Excel is just there, everywhere.
Re:The No-Code Generation is arriving by msla on Tuesday October 27, 2020 @11:28AM (#24908325)
> Excel is still the biggest and most successful no-code tool.

Yep, people sure write a lot of code in Excel.

(Well, what do you think formulas are?)

Re:The No-Code Generation is arriving by icholy on Tuesday October 27, 2020 @11:29AM (#24908345)
Even basic cell references are a type of code.
Re:The No-Code Generation is arriving by Grustaf on Tuesday October 27, 2020 @11:32AM (#24908374)
In that sense, any no code platform is also code.
Re:The No-Code Generation is arriving by waynecochran on Tuesday October 27, 2020 @11:28AM (#24908327)
With spreadsheets, particular google's flavor, I still think of it as functional / declarative programming.
Re:The No-Code Generation is arriving by mainstreem on Tuesday October 27, 2020 @03:26PM (#24910865)
Ever seen Smartsheets? I know someone I'd have described as "nontechnical" several years ago who is practically building business-specific applications complete with frontend interfaces and backed by spreadsheets and almost all of this person's code is formulas, which are very "functional programming." This person has asked to be coached in writing a "real" programming language and it's a challenge to think of how to approach the problem based upon the person's existing skillset and understanding, which is entirely backwards (FP instead of imperative) from the usual student's!
Re:The No-Code Generation is arriving by indymike on Tuesday October 27, 2020 @10:02PM (#24914223)
calling stuff like this no-code is incorrect:

=RIGHT(A5, SEARCH("FOO",A5))="BAR"

Re:The No-Code Generation is arriving by Retric on Tuesday October 27, 2020 @11:04PM (#24914626)
Every no code solution has such scripts under the hood and most let you edit them. However, drag and highlight a row of cells and click sum, min, or max and your not editing code directly which is really all there is to the ‘no code’ concept. There are plenty of ways in these tools to select a bunch of data and click make a chart, but guess what that’s just another way to write some code.
Re:The No-Code Generation is arriving by BenoitP on Tuesday October 27, 2020 @11:36AM (#24908413)
> tools take a lot to learn well and it rarely transfers between roles at the same job

So, great lock-in capabilities? I can see why money is pouring into these tools.

Re:The No-Code Generation is arriving by ebj73 on Tuesday October 27, 2020 @07:15PM (#24913165)
I wouldn't call Excel a no-code tool. A formula is sort of code, in my mind.
Re:The No-Code Generation is arriving by FartyMcFarter on Tuesday October 27, 2020 @07:31PM (#24913270)
Formulas (at least the kind people typically use) are not Turing complete, so they are not as powerful as what most people associate with the word "code".

Edit: I know there are lots of people on the Internet saying you can simulate Turing machines in excel, but they're usually manually unrolling the computation in successive rows, which doesn't really count. For one thing, this style of simulation doesn't even allow one to make an infinite loop, let alone a more complex self-contained loop.

Re:The No-Code Generation is arriving by contravariant on Tuesday October 27, 2020 @07:57PM (#24913456)
Of course by far the biggest problems with Excel sheets are caused by the code in them.

That and Microsoft's insane theory that about 50% of user input is dates.

Re:The No-Code Generation is arriving by Ma8ee on Wednesday October 28, 2020 @06:18AM (#24917136)
Or that long numbers, like Order Numbers or Customer Numbers should be considered floats.
Re:The No-Code Generation is arriving by commandlinefan on Tuesday October 27, 2020 @02:25PM (#24910271)
> the tools take a lot to learn

And eventually require VBScript if you want to really automate anything anyway.

Re:The No-Code Generation is arriving by rllearneratwork on Tuesday October 27, 2020 @11:39AM (#24908462)
it is often easier and much much more useful to invest in learning to code rather than invest in learning a proprietary "no-code" tool