Earlier quoted context omitted.
So you have 0.1% SQL skill .. work on it.
Actually a flat 0%.
Well, that the issue with php devs.
Ask HN: Getting tired of complexity in web development
141–150 of 292 posts
Re: Ask HN: Getting tired of complexity in web development
#142I call this the "path to enlightenment." You have discovered that the most popular toolchain is overkill for 95% of the things its used for. The problem is that's true literally across the board. You move to the backend and you have to deal with people who fell in love with microservices and weird databases that they didn't need. You move to ops and you have to deal with k8s when a single container would do. If you t…
Speaking of ops. What is the simplest reproducible way to accomplish this task. - create vm instance ( setup firewall, users, network dna, stuff) - install : apache, runtime - install app.
There is already many answers to your question and not to be rude, but I think it perfectly shows part of the problem OP is talking about.
Every single answer goes straight to name dropping various specific techs/tools and I don’t doubt it really is the most simple way for each poster. But I think a much better answer, would be a bunch of questions that dig into what kind of problem you are trying to solve, what are the circumstances, skillset, limitations, budget, is it 1 tiny private app for fun or a couple of apps your team or even company depends on etc.
Because it depends on the specifics in _your_ situation and jumping straight to _a_ solution, without understanding _your_ problem, is imho part of the over-complexity-problem in our industry.
Re: Ask HN: Getting tired of complexity in web development
#143Re: Ask HN: Getting tired of complexity in web development
#144Earlier quoted context omitted.
>Why does this happen? I wrote about a hypothesis here: https://medium.com/@scott.stevenson/how-to-finally-make-some... Most of us are scared by the ambiguity of actual creative work, so unless we are under the threat of deadline, we seek out "structured games" to play so that we can put off the anxiety of freeform work. These games are: (1) Tool Game: Researching and setting up tools (2) Learning Game: Books, podcas…
> (1) Tool Game: Researching and setting up tools (2) Learning Game: Books, podcasts, courses (3) Maintenance Game: Cleaning up our desktop, desk, house, etc. (4) Process Game: Setting up new processes and following them I…I…I am triggered by this. So it’s as if, people such as myself are on the hunt for artificial positive feedback loops that are functionally beautified masks of procrastination. Fueled by, perhaps a…
I wouldn't write these off entirely. One of their positive outcomes is that you get to switch. Switching is important so you don't get bored or fed up. Just don't take these things too seriously, and don't stick your newfound hype into everything. Let things breathe, sleep on them. For like a few months or years.
Re: Ask HN: Getting tired of complexity in web development
#145>I’ve hit a point where it just doesn’t seem like the end justifies the means in the vast majority of cases anymore I agree, but the only path forward is to change the specifications for HTML/CSS/JavaScript. As an industry we need to accept that these technologies get used to build web pages as well as software and adjust. This will remove a ton of the tooling. I think there are 3 basic things we could do to solve th…
> Add dynamic interpolation to the HTML spec. This stops every framework from having to invent it's own version of it. Not sure what this means exactly > 2. Update the DOM api to allow data binding/state and improve the Web APIs around routing/history to make SPAs even easier. Something like AlpineJS built-in? > 3. Update the HTML spec to allow for semantically describing user interface elements of software applicati…
My post will expand on all of this in detail, including addressing ARIA.
Re: Ask HN: Getting tired of complexity in web development
#146I call this the "path to enlightenment." You have discovered that the most popular toolchain is overkill for 95% of the things its used for. The problem is that's true literally across the board. You move to the backend and you have to deal with people who fell in love with microservices and weird databases that they didn't need. You move to ops and you have to deal with k8s when a single container would do. If you t…
>Why does this happen? A lot of people value more enhancing their résumé than solving problems
a lot of companies value shiny resume than complex problems solved
Re: Ask HN: Getting tired of complexity in web development
#147>I’ve hit a point where it just doesn’t seem like the end justifies the means in the vast majority of cases anymore I agree, but the only path forward is to change the specifications for HTML/CSS/JavaScript. As an industry we need to accept that these technologies get used to build web pages as well as software and adjust. This will remove a ton of the tooling. I think there are 3 basic things we could do to solve th…
No post body was provided.
Re: Ask HN: Getting tired of complexity in web development
#148Earlier quoted context omitted.
The ORM code will be 10x smaller than the generated SQL, especially for structured data and composing queries. Not to mention that static typing which is going to ensure your query is valid when the code compiles, no typos. Plus maintainability of finding all references of tables/fields. Plus the ability to quicky refactor all of that. Plus mapping to DTOs. I didn't even get into entity tracking which is a whole othe…
Hold on, we are talking php here. There is no code compiling. Either way what you are describing sounds like instead of maintaining sql code you prefer maintaining orm code. DTOs are just overhead. I gave up on all these after 15 years of using them because the benefits are precisely zero (except for migrations). Similarly with typescript, if you are competent enough with js and as a programmer you dont need it. The…
With hundreds of developers and millions of lines of code - yes Typescript and ORMs will completely eliminate entire classes of bugs, and be a force multiplier when it comes to productivity.
You should never rule out a tool as 'unnecessary' even if you can't think of any possible reason for it. Try to keep an open mind here, you may not know everything.
Re: Ask HN: Getting tired of complexity in web development
#149There is a huge shortage of developers on corporate information security teams. Many organizations' CorpSec teams spend an egregious amount of time toiling in manual processes. In infosec, that is why you constantly hear of burnout. If you wanted to switch into information security as a developer, many well-paying, well-known orgs would welcome you in with open arms in some kind of automation developer role. I have n…
This is very interesting. Where can I start and learn more about it?
This article is a really brief primer on this line of work. A lot of it is working with Python, JavaScript, APIs, and building custom solutions to get different COTS security tools and things like Jira to talk to each other. It may not be for everyone but I really enjoy it.
https://www.cadosecurity.com/the-next-in-demand-job-title-se...
Re: Ask HN: Getting tired of complexity in web development
#150Earlier quoted context omitted.
Can you show me an example of the 10x less code?
You're going to get a huge reduction in code for all sorts of things, especially when navigating multiple relations, grouping, sub-selects, etc.. var results = db.myTable .where(x => x.value > 6) .where(mySpecialConditionalLogicFunction) .select(x => { thing = x.relation.relation.relation.value, thingList2 = x.relation.relations .groupby(y => y.value) .select(g => g.count) .orderby(y => y.value) .take(5), thing3 = x.…
This brings fond memories of my early stages where i became fond of the method chaining pattern. I became fascinated by it when using doctrine.
However the code you pasted is horrible and easily replaced by sql. Not only does someone else need to learn your custom logic functions and dtos but they also need to read stuff like “ x.relation.relation.relation.value”. I see your point in regards to dtos “automagically” updating queries, but if you have queries laying around everywhere thats another code smell. Basically, this is solving artificial problems.
The code you pasted can be replaced by a trivial query, which should table columns be renamed (i mean whats the frequency of that anyway, potentially another code smell), it would take less to update than updating all the dtos custom functions and the sausage code.
Edit: i am not belittling you, my point is that the code above solves self inflicted issues that could be written in a basic sql query with bound params. Basically you spend twice as much to write and maintain code that is simply not necessary.