I absolutely hate no-code systems.
-
and yes I know I am speaking to the choir here. But I just have to vent. so I am working in this system that is based upon data and everything I am sure is in SQL somewhere in the clouds. but am I allowed to connect with like SQL management studio or heck even some sort of command terminal? Nope! so no SQL select available. You HAVE to use their interface. you have to select the whole table first and then you deselect the fields you dont want then you can apply a where clause it is all a stupid IDE with no way to write any freakin Code! and yes I know THEY "think" and THEY "say" you don't need a tech to do this. But only a real tech can actually figure it out. So the no code is less than useless because you actually haven't eliminated a tech job. You have just made it harder.
To err is human to really elephant it up you need a computer
I like only such systems which I have developed myself. Even then, I can rarely remember how to use them.
-
There is only one I like, and that's Synthmaker (now Flowstone) and it's more like low code in that you usually don't need code, but you can drop to ruby (and maybe psuedo asm with SSE type instructions if they still have that) and code modules with it. Most of it is dragging and dropping these nodes together and building sort of like "circuits" out of them.
To err is human. Fortune favors the monsters.
Sounds like SSIS, but I "drop to" C#. And easy enough to use SQL.
-
and yes I know I am speaking to the choir here. But I just have to vent. so I am working in this system that is based upon data and everything I am sure is in SQL somewhere in the clouds. but am I allowed to connect with like SQL management studio or heck even some sort of command terminal? Nope! so no SQL select available. You HAVE to use their interface. you have to select the whole table first and then you deselect the fields you dont want then you can apply a where clause it is all a stupid IDE with no way to write any freakin Code! and yes I know THEY "think" and THEY "say" you don't need a tech to do this. But only a real tech can actually figure it out. So the no code is less than useless because you actually haven't eliminated a tech job. You have just made it harder.
To err is human to really elephant it up you need a computer
They have been claiming solutions like that work since at least the 80s. They don't. To be fair they try to approach other problems in the same way by applying generalizations to certain types of problems. Comparable to building houses. They presume it is a tract house. They presume it will be built on an endless tract of land that represents a mathematical plane with an endless unchanging supply of the same materials and with no possible change in things like building codes, water supply etc. It works as well as that.
-
and yes I know I am speaking to the choir here. But I just have to vent. so I am working in this system that is based upon data and everything I am sure is in SQL somewhere in the clouds. but am I allowed to connect with like SQL management studio or heck even some sort of command terminal? Nope! so no SQL select available. You HAVE to use their interface. you have to select the whole table first and then you deselect the fields you dont want then you can apply a where clause it is all a stupid IDE with no way to write any freakin Code! and yes I know THEY "think" and THEY "say" you don't need a tech to do this. But only a real tech can actually figure it out. So the no code is less than useless because you actually haven't eliminated a tech job. You have just made it harder.
To err is human to really elephant it up you need a computer
Reminds me of the report generator in CR, or the venerable BizTalk or any number of systems designed to move the coding to the power user, not just a waste of time by the bane of any developer.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
-
Reminds me of the report generator in CR, or the venerable BizTalk or any number of systems designed to move the coding to the power user, not just a waste of time by the bane of any developer.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
-
this is exactly what they are trying to do.
To err is human to really elephant it up you need a computer
Problem is, that it's not less work (as it's meant to be), just less flexible
Wrong is evil and must be defeated. - Jeff Ello
-
and yes I know I am speaking to the choir here. But I just have to vent. so I am working in this system that is based upon data and everything I am sure is in SQL somewhere in the clouds. but am I allowed to connect with like SQL management studio or heck even some sort of command terminal? Nope! so no SQL select available. You HAVE to use their interface. you have to select the whole table first and then you deselect the fields you dont want then you can apply a where clause it is all a stupid IDE with no way to write any freakin Code! and yes I know THEY "think" and THEY "say" you don't need a tech to do this. But only a real tech can actually figure it out. So the no code is less than useless because you actually haven't eliminated a tech job. You have just made it harder.
To err is human to really elephant it up you need a computer
Like trying to program your smart TV with the remote.
Quote:
and yes I know THEY "think" and THEY "say ..."
THEY are the THEM. It's all a conspiracy created by the pronoun police.
Nothing succeeds like a budgie without teeth. To err is human, to arr is pirate.
-
and yes I know I am speaking to the choir here. But I just have to vent. so I am working in this system that is based upon data and everything I am sure is in SQL somewhere in the clouds. but am I allowed to connect with like SQL management studio or heck even some sort of command terminal? Nope! so no SQL select available. You HAVE to use their interface. you have to select the whole table first and then you deselect the fields you dont want then you can apply a where clause it is all a stupid IDE with no way to write any freakin Code! and yes I know THEY "think" and THEY "say" you don't need a tech to do this. But only a real tech can actually figure it out. So the no code is less than useless because you actually haven't eliminated a tech job. You have just made it harder.
To err is human to really elephant it up you need a computer
No-code systems are just a framework to the max. Convention over configuration.
-
and yes I know I am speaking to the choir here. But I just have to vent. so I am working in this system that is based upon data and everything I am sure is in SQL somewhere in the clouds. but am I allowed to connect with like SQL management studio or heck even some sort of command terminal? Nope! so no SQL select available. You HAVE to use their interface. you have to select the whole table first and then you deselect the fields you dont want then you can apply a where clause it is all a stupid IDE with no way to write any freakin Code! and yes I know THEY "think" and THEY "say" you don't need a tech to do this. But only a real tech can actually figure it out. So the no code is less than useless because you actually haven't eliminated a tech job. You have just made it harder.
To err is human to really elephant it up you need a computer
I was mouth open amazed that I only learned yesterday, that Azure Portal, the web site, has a command line button, at top, which opens, in page, a terminal to do all your work. and can select to do in bash or powershell i tottaly suck at using command line, but was like wow, all those guides which use terminal only be very useful.
-
Problem is, that it's not less work (as it's meant to be), just less flexible
Wrong is evil and must be defeated. - Jeff Ello
I assume you code exclusively in assembler, to preserve 'flexibility'?
-
and yes I know I am speaking to the choir here. But I just have to vent. so I am working in this system that is based upon data and everything I am sure is in SQL somewhere in the clouds. but am I allowed to connect with like SQL management studio or heck even some sort of command terminal? Nope! so no SQL select available. You HAVE to use their interface. you have to select the whole table first and then you deselect the fields you dont want then you can apply a where clause it is all a stupid IDE with no way to write any freakin Code! and yes I know THEY "think" and THEY "say" you don't need a tech to do this. But only a real tech can actually figure it out. So the no code is less than useless because you actually haven't eliminated a tech job. You have just made it harder.
To err is human to really elephant it up you need a computer
You seem to assume it's SQL Server, but it may not be, and even if it is it may not be next year. If you code against the database directly your work will break when the data is moved, to another server, another database system, or whatever. I imagine the system designers want to prevent that. The system is not there for your convenience, it's there to benefit the business and you are presumably engaged for your professional skills in working with it. Why not suggest improvements to the interface that would simplify matters, instead of ranting that it doesn't suit your skill level? If you can show how much time and cost they would save, you might find them welcomed....
-
I like only such systems which I have developed myself. Even then, I can rarely remember how to use them.
You did document them, right? No? Well there you go....
-
and yes I know I am speaking to the choir here. But I just have to vent. so I am working in this system that is based upon data and everything I am sure is in SQL somewhere in the clouds. but am I allowed to connect with like SQL management studio or heck even some sort of command terminal? Nope! so no SQL select available. You HAVE to use their interface. you have to select the whole table first and then you deselect the fields you dont want then you can apply a where clause it is all a stupid IDE with no way to write any freakin Code! and yes I know THEY "think" and THEY "say" you don't need a tech to do this. But only a real tech can actually figure it out. So the no code is less than useless because you actually haven't eliminated a tech job. You have just made it harder.
To err is human to really elephant it up you need a computer
The great thing about no-code systems is that you create more coding jobs. What about AI? Well, someone has to code those systems too. The problem is like you found, the interface layer will drive a tech-minded person insane because these tools are not made for us. They are made for and sold to managers who spent time in a marketing seminar watching a few examples that were perfectly crafted for the data. They pay incredible amounts of money for a tool that doesn't require health insurance and think they are saving a bundle. Suddenly there's a job opening for a SharePoint/App manager, and too often, it ends up being some non-tech-minded ex-business manager and friend of the HR lady you can't stand that suckered their last organization into moving everything to the cloud...and they need to hire some fakers - "tech-minded" assistants - to actually do the work, and they bother you all day because they can't figure out how to Google.
The key words "MUST", "MUST NOT", "REQUIRED", "SHALL", "SHALL NOT", "SHOULD", "SHOULD NOT", "RECOMMENDED", "MAY", and "OPTIONAL" in this document are to be interpreted as described in RFC 2119.
-
and yes I know I am speaking to the choir here. But I just have to vent. so I am working in this system that is based upon data and everything I am sure is in SQL somewhere in the clouds. but am I allowed to connect with like SQL management studio or heck even some sort of command terminal? Nope! so no SQL select available. You HAVE to use their interface. you have to select the whole table first and then you deselect the fields you dont want then you can apply a where clause it is all a stupid IDE with no way to write any freakin Code! and yes I know THEY "think" and THEY "say" you don't need a tech to do this. But only a real tech can actually figure it out. So the no code is less than useless because you actually haven't eliminated a tech job. You have just made it harder.
To err is human to really elephant it up you need a computer
I'm actually working on building a no-code tool for our staff to use for custom reports for our customers, and I'm trying to avoid "... only a real tech can actually figure it out" at all costs. I am putting a great deal of effort into making it make sense and be easy for those with little to no clue about SQL to be able to generate these reports without having to go into the db themselves or waiting for us to do it for them. I wonder if I can do it - make it easier/quicker for those who are uncomfortable with SQL, and maybe no harder nor slower for us. I'm giving it my best shot.
-
You did document them, right? No? Well there you go....
A simple readme file, plus example scripts.
-
and yes I know I am speaking to the choir here. But I just have to vent. so I am working in this system that is based upon data and everything I am sure is in SQL somewhere in the clouds. but am I allowed to connect with like SQL management studio or heck even some sort of command terminal? Nope! so no SQL select available. You HAVE to use their interface. you have to select the whole table first and then you deselect the fields you dont want then you can apply a where clause it is all a stupid IDE with no way to write any freakin Code! and yes I know THEY "think" and THEY "say" you don't need a tech to do this. But only a real tech can actually figure it out. So the no code is less than useless because you actually haven't eliminated a tech job. You have just made it harder.
To err is human to really elephant it up you need a computer
Yeah, many of these are a joke, just as you describe. The vendors oversell the systems, showing shiny examples of working systems neglecting to tell the potential customers that they were either built out by the vendor, at a silly cost, or built by customers who threw their IT department at the project. I actually sat in on a zoom meeting where I had to explain the SQL to the vendor. I turned off my video and audio after a while and explained it to my dog sitting next to me. She at least tilted her head; which beat the blank stares from the vendor's so-called SA and Dev. :omg:
-
and yes I know I am speaking to the choir here. But I just have to vent. so I am working in this system that is based upon data and everything I am sure is in SQL somewhere in the clouds. but am I allowed to connect with like SQL management studio or heck even some sort of command terminal? Nope! so no SQL select available. You HAVE to use their interface. you have to select the whole table first and then you deselect the fields you dont want then you can apply a where clause it is all a stupid IDE with no way to write any freakin Code! and yes I know THEY "think" and THEY "say" you don't need a tech to do this. But only a real tech can actually figure it out. So the no code is less than useless because you actually haven't eliminated a tech job. You have just made it harder.
To err is human to really elephant it up you need a computer
This makes me thing of a soldering project from a while ago. It came with a couple pushbuttons and an instruction sheet on how to get stuff done with those pushbuttons. Not exactly impossible, far from that, but I found that digging through the code & uploading a custom binary to the MCU is sooooo less hassle than controlling this thing with the buttons.
-
and yes I know I am speaking to the choir here. But I just have to vent. so I am working in this system that is based upon data and everything I am sure is in SQL somewhere in the clouds. but am I allowed to connect with like SQL management studio or heck even some sort of command terminal? Nope! so no SQL select available. You HAVE to use their interface. you have to select the whole table first and then you deselect the fields you dont want then you can apply a where clause it is all a stupid IDE with no way to write any freakin Code! and yes I know THEY "think" and THEY "say" you don't need a tech to do this. But only a real tech can actually figure it out. So the no code is less than useless because you actually haven't eliminated a tech job. You have just made it harder.
To err is human to really elephant it up you need a computer
"Working as intended". Companies sell this stuff to those in charge who don't know any better. They sell it as a way to "not require actual techies to manage, selling the idea that the company will save money by not needing to hire full techs. Instead they can hire low level techs that don't really understand how things work. The higher level techs that actually understood everything got tired of being locked out of making improvements and left for a company that values their skills. All the time, the vendor is pulling the company in deeper the more systems they set up for them. Eventually the company is left with nothing but low level techs that only understand the cookie cutter system that the company is now locked into paying for. With no way to innovate and adapt. Companies beware. You want to be successful, hire smart people that understand the system and can design the system you need to continue being successful.
-
You seem to assume it's SQL Server, but it may not be, and even if it is it may not be next year. If you code against the database directly your work will break when the data is moved, to another server, another database system, or whatever. I imagine the system designers want to prevent that. The system is not there for your convenience, it's there to benefit the business and you are presumably engaged for your professional skills in working with it. Why not suggest improvements to the interface that would simplify matters, instead of ranting that it doesn't suit your skill level? If you can show how much time and cost they would save, you might find them welcomed....
What you are saying may be right on some level. The OP wants to vent. Let’s let him do that. And why don’t you pull your lip over your face and swallow.
-
Problem is, that it's not less work (as it's meant to be), just less flexible
Wrong is evil and must be defeated. - Jeff Ello