🖤 It's time to speak up, donate or even just stream a fundraising video, because Black Lives Matter. Our thoughts are with everyone in the US and beyond fighting for this cause. | StatusCode Weekly Covering the week's news in software development, ops, platforms, and tooling. The Stack Overflow Developer Survey 2020 Results — Over 65,000 developers took part in Stack Overflow's popular annual survey and you can now swim through the results. We learn lots of things, including: - JavaScript is the most popular language amongst respondents.
- MySQL holds the top spot in databases.
- Python is the language people most want to learn.
- 78% enjoy coding as a hobby, as well as work.
- Perl is where the money is(?!)
- Men are disproportionately represented in all fields of development, but particularly in devops and sysadmin, and much less so in data science and education.
Stack Overflow | SQLite 3.32.0 Released — The world's most popular database takes another baby step forward: - Support for faster 'approximate'
ANALYZE queries. - A
iif() SQL function which acts like an "IF" in other languages, or like CASE WHEN X THEN Y ELSE Z END in more traditional SQL. - You can now include up to 32766 parameters in a query, up from the previous maximum of 999. (I'd like to see code doing that!)
SQLite | Find A Job Through Vettery — Vettery specializes in tech roles and is completely free for job seekers. Create a profile to get started. Vettery | ℹ️ Interested in running a job listing in StatusCode Weekly? There's more info here. ▶ A Practical-ish Introduction to Data Science — This is pretty high level but extremely accessible and well worth the time if the terms 'data science' and 'machine learning' leave you scratching your head half the time. Mark West | The Radix 2^51 Trick — A surprisingly understandable explanation of optimizing the addition of huge numbers (think larger than 64 bits) by deferring carries to the end of the process. Tim McLean | ▶ Remote Development with Visual Studio Code — I've only recently started to play with VS Code's remote editing and development features but have been very impressed. If it's all new to you, this talk rounds up the general concepts. Chris Dias | The Joy of Serverless — "In this post, I shall unashamedly extoll the subjective (perhaps even emotional) virtues of serverless software development." Come on, Tom, hit us with some positivity 😁 Tom Wright | Snowpack 2.0: A Build System for the Modern Web — Say bye-bye to your bundler and let modern browsers' ES module support do the heavy lifting with Snowpack. Or if you need to target more than just modern browsers, you can always just use it to speed things up in development. This talk by Ryan Lanciaux introduces the idea of escaping using bundlers, if you're new to this area. Fred K. Schott | Perspective: Streaming Pivot Visualization via WebAssembly — An interesting use for WebAssembly here. Originally built for J P Morgan, Perspective is for building real-time high performance interactive visualizations, powered by a C++ engine compiled to WASM under the hood. The Fintech Open Source Foundation | Android Studio 4.0 Released — Lots of new stuff in the latest release of the official IDE for Android development, including a new Motion Editor to help bring your apps to life, a Build Analyzer to investigate causes for slower build times, and Java 8 language APIs you can use regardless of your app's minimum API level. Google | |
0 коммент.: