4,348 karma · joined January 24, 2011
Nowadays I mostly consult startups, helping them with app architecture and planning for performance/scalability, or act as a team leader on small to medium sized projects. Prefer smaller companies/teams, and remote work is a must.
I've spent quite a lot of time working on integrations and fixing the issues with custom written apis and systems, usually with outdated & undocumented code, and thus over time I've developed very versatile set of skills and got very good in figuring things out, learning fast and working independently on complex setups.
Most of the time I work in PHP (prefer laravel or symfony) and javascript (jquery, knockout, angular 1.x, vue, react, node), but I've also got tons of experience with fixing advanced CSS issues, as well as a fair amount of devops skills: linux administration, apache/nginx, advanced mysql (query optimization, high-performance, scaling, administration) and AWS, ansible, etc. I've used perl a lot before, and now use ruby/RoR from time to time. I've worked on a number of projects with postgresql, redis and mongodb as well. And at some point in time I've also spent a lot of time writing custom themes/plugins for Wordpress (not my primary interest anymore however).
You can find me on twitter: @ivanhoe011, feel free to DM me there.
Allulose is not a poison by any measure, but if you're so paranoid about what your children eat why feeding them with instant foods like FruitLoops in a first place? Breakfast cereals are highly processed food, even without any added sugar - parent as concerned about the food quality as you certainly can come up with a healthier breakfasts for their kids?
Borland Delphi had the best and the most useful documentation/help system that I ever used - and those were times before Google or even access to Internet for many of us, so reading manuals played a huge role in learning.
Capitalism is fine when it benefits the overall economy, but when it starts self-imploding because of interests of a few, then government jumps in usually - that's why we have anti-monopoly laws, because monopoly hurts the progress...
Being a senior dev is IMHO much simpler. It's all about being able to solve problems independently, without needing supervision, guidance or tutoring. If you can pass to a dev some business requirement, and know that they'll return with an optimal solution implementation, you've got yourself a true senior dev.
Well, you asked for sql and ansi sql function is listagg(), so technically this is not the right answer - and definitely a completely useless one for mysql or oracle users.
It also means that now we seriously lack people capable of working close to the bare metal - and the same will happen to many other skills and niche knowledge that AI will be able to replace (e.g. why school statics engineers, if AI can solve the math for architects directly).
That will IMHO result in some bad things as well:
- There will be no one left to oversee and improve the work done by AI,
- It will further slow down the overall progress because the most of people will lack deeper insights into how things work and AI will probably still be of the limited use for making ground-breaking original discoveries,
- And finally, though as individuals we will probably keep our IQs, just entertaining them with something else, as whole our civilization will loose some knowledge and skills - making us all dumber in a way.
Well, I guess it depends on the type of attacks one experiences, but hackers and spammers who target US-based businesses are not idiots, they know how to use vpns and tor and proxies. So on a technical level you get close to nothing security-wise. You reduce a number of bots and worms randomly accessing your servers, can stop some script kiddies who don't know better and make life a bit harder to web scrapers (but not much) - and that's it.