Click here to Skip to main content
15,867,568 members

The Insider News

   

The Insider News is for breaking IT and Software development news. Post your news, your alerts and your inside scoops. This is an IT news-only forum - all off-topic, non-news posts will be removed. If you wish to ask a programming question please post it here.

Get The Daily Insider direct to your mailbox every day. Subscribe now!

 
NewsGoogle: 60% of the internet is duplicate Pin
Kent Sharkey27-Nov-22 10:16
staffKent Sharkey27-Nov-22 10:16 
GeneralRe: Google: 60% of the internet is duplicate Pin
Nelek28-Nov-22 11:48
protectorNelek28-Nov-22 11:48 
NewsThe Internet Archive just put 565 Palm Pilot apps in your web browser Pin
Kent Sharkey27-Nov-22 10:16
staffKent Sharkey27-Nov-22 10:16 
GeneralRe: The Internet Archive just put 565 Palm Pilot apps in your web browser Pin
David O'Neil27-Nov-22 11:36
professionalDavid O'Neil27-Nov-22 11:36 
NewsGitHub Blocks Pin
Kent Sharkey27-Nov-22 10:01
staffKent Sharkey27-Nov-22 10:01 
NewsElimination of programmers Pin
Kent Sharkey27-Nov-22 10:01
staffKent Sharkey27-Nov-22 10:01 
GeneralRe: Elimination of programmers Pin
Richard Andrew x6427-Nov-22 13:51
professionalRichard Andrew x6427-Nov-22 13:51 
GeneralRe: Elimination of programmers Pin
Sander Rossel27-Nov-22 21:51
professionalSander Rossel27-Nov-22 21:51 
I currently work for a client who uses a no-code platform.
Their idea is that a business analist can change the program too.
The tool mainly calls database (SQL) stored procedures or executes SQL queries or calls web APIs.
You'd expect a flow like this:
Timer trigger -> exec SP -> call service -> exec query

Unfortunately, it's like this:
Timer trigger -> exec SP -> record set to XML -> call service -> XML to record set -> exec query

Now you think, still not too bad.
Unfortunately, looping and if-else branches are done in stored procedures, something a database isn't really meant to do.
It gets worse.
Processing large data sets is almost impossible using this tool (very slow).
So, what they do, XML files are stored on disk, an SP is executed which reads the XML and then processes it using OPEN XML FOR or something like that.
I don't know about you, but working with XML in a query is not something most of us do on a daily basis, so it greatly complicates things.
Now, with procedures calling procedures, views and functions, which are in turn called by some step of some task in a no-code platform, with no ability to search or debug, this thing is a nightmare to developer and maintain.
The database has thousands of objects, with tables that do nothing except store a result to be used in another task or step.
Basically, each function you'd have in code is now a stored procedure.
Despite having various services, all databases (three major ones) are linked and used for querying in the other databases.
There's a ASP.NET Visual Basic WebForms project for the front-end, which does little more than create and read records from/to the database and start a task in the no-code tool.

I'm a skilled developer with years of experience and I really struggle to maintain and develop this.
The person who built the bulk of this is around to tell me where I need to look.
Just last week we couldn't find where some table was updated, not even the person who built it could remember where it was.
We still haven't found it.
The main "programmer" is certain this is the way to go and that a business analist could build on this.
Their customer is satisfied, I'm horrified Dead | X|

GeneralRe: Elimination of programmers Pin
raddevus28-Nov-22 3:06
mvaraddevus28-Nov-22 3:06 
GeneralRe: Elimination of programmers Pin
Sander Rossel28-Nov-22 3:37
professionalSander Rossel28-Nov-22 3:37 
GeneralRe: Elimination of programmers Pin
Nelek28-Nov-22 11:46
protectorNelek28-Nov-22 11:46 
GeneralRe: Elimination of programmers Pin
raddevus28-Nov-22 11:53
mvaraddevus28-Nov-22 11:53 
GeneralRe: Elimination of programmers Pin
den2k8828-Nov-22 3:31
professionalden2k8828-Nov-22 3:31 
GeneralRe: Elimination of programmers Pin
Daniel Pfeffer28-Nov-22 5:28
professionalDaniel Pfeffer28-Nov-22 5:28 
GeneralRe: Elimination of programmers Pin
den2k8828-Nov-22 6:30
professionalden2k8828-Nov-22 6:30 
NewsWindows 11 is getting a VPN status indicator in the taskbar Pin
Kent Sharkey27-Nov-22 10:01
staffKent Sharkey27-Nov-22 10:01 
GeneralRe: Windows 11 is getting a VPN status indicator in the taskbar Pin
David O'Neil27-Nov-22 11:39
professionalDavid O'Neil27-Nov-22 11:39 
NewsSmartphone addiction linked with lower cognitive abilities, less self-control, and worse psychological well-being Pin
Kent Sharkey27-Nov-22 10:01
staffKent Sharkey27-Nov-22 10:01 
GeneralRe: Smartphone addiction linked with lower cognitive abilities, less self-control, and worse psychological well-being Pin
David O'Neil27-Nov-22 11:42
professionalDavid O'Neil27-Nov-22 11:42 
GeneralRe: Smartphone addiction linked with lower cognitive abilities, less self-control, and worse psychological well-being Pin
obermd29-Nov-22 6:05
obermd29-Nov-22 6:05 
NewsAnother .NET (C#) repl Pin
raddevus27-Nov-22 7:40
mvaraddevus27-Nov-22 7:40 
NewsDr. Frederick P. Brooks Pin
Gjeltema25-Nov-22 9:55
Gjeltema25-Nov-22 9:55 
NewsSan Francisco police consider letting robots use ‘deadly force’ Pin
Kent Sharkey24-Nov-22 9:16
staffKent Sharkey24-Nov-22 9:16 
GeneralRe: San Francisco police consider letting robots use ‘deadly force’ Pin
Super Lloyd24-Nov-22 14:41
Super Lloyd24-Nov-22 14:41 
GeneralRe: San Francisco police consider letting robots use ‘deadly force’ Pin
obermd24-Nov-22 16:33
obermd24-Nov-22 16:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.