Your question is confusing… are you asking how to get better at project management?

Especially because pretty much every programming language is slowly getting all the features… Java and C++ now have first class function support which used to be a hallmark of functional languages.

In normal SQL you’d use a window function to do this but I don’t know if mysql supports that.

It is a bad language choice for that need but a lot of people don’t have a choice or aren’t the decision makers.

That’s them, yup!

Like half of the npm is maintained by a single, arguably awful, person who writes his microprojects into large pieces of software to maximize how often his code gets installed.

And they still get emails from randos when some program that uses curl doesn’t work (the Readme is top notch).

I think math is the best way we know to train analytical thinking - one place it’s absolutely necessary is graphical rendering, if you’re building or improving a rendering engine it’s absolutely fucking vital. Outside of that it’s really unimportant for developers to know math - even for crypto or banking stuff. When it comes to encryption/compression you need to know math to write the algorithm but can generally implement it without a strong background in math so long as it’s well defined enough… but you’ll usually be using a library.

So, TL;DR the CS field needs like a thousand people that are excellent at math and the rest of us pretty much never need it.

Private equity ownership sucks balls… publicly traded companies are only marginally better.

Ew, minified sketchy links, an article with no sourcing for the ranking… just a vehicle to sell courses.

Boo.

So all of our dates should be stored in UTC… but everytime we have to deal with an unmarked column we have to check if it’s in PST because a developer forgot. If a developer did forget, they’d probably grab the PDT value during DST.

Honestly, I’m working on a system with data we control and we’ve been migrating pg columns from WITHOUT to WITH TIMEZONE - our server natively runs in PST rather than UTC for convenience and everytime we find a naive timestamp we have two main options to consider - whether the dev properly stored values as UTC or whether they just used a now like function and got PST.

Gosh, if you’re able to share that I’d love to see that train wreck.

Yes, but usually not actual HTML because then there are a lot of security issues to address. BBCode might even be a better choice, i.e. [b]Bold Text[/b]

If I wanted a WYSIWYG field I’d probably still use markdown. I could add the buttons to properly inject markdown symbol and use a JS markdown renderer for the text field. Tbh I’d be amazed if there weren’t at least a dozen out-of-the-box packages that included a live rendered text area with a widget array.

In this instance I’m not advocating for markdown as a user interface but just using it as a quick and dirty markup language. Be aware that if you turn to HTML, you’d be adopting responsibility for a lot of non-trivial security issues. If the customization went beyond markdown (into, for instance, fonts) you’d need a more complex solution so you’d likely want to investigate other tag or boundary marker based markup languages out there. Markdown is just simple and has ten billion implementations out there.

That is a very unlikely approach.

Rich text in the modern world is almost exclusively solved by using markdown because it’s such a trivial solution.

In previous words it was usually solved either using range tags (similar to HTML, sometimes literally HTML, more often custom stuff) or embedded boundary markers (something that marked a new boundary and then had a full definition of the styles to follow, sometimes omitting styles that didn’t change, often times in some insanely dense binary format for predictable scanning).

Usually, it’s more sane to embed formatting in the string itself rather than having styling separately defined (i.e. CSS, kinda). Because otherwise storage would be a huge pain and reading would require a lot of non-consecutive disk scans.

I’d suggest choosing a mature language with a large number of utilities/libraries available - Java, Python, Rust spring to mind but the graphical shit is really what you’d want to lean hard on a library is. I don’t know enough to say for certain but it sounds like most of your work will be defining objects and how they interact… off the shelf solutions can’t really help with that.

It’s very possible to say positive things about AI around here - you just have some really big gaps in knowledge when it comes to how generative AI functions.

I think you may have speeded to a conclusion.

merges WordPress into the apt repository for grep

watches the world burn