--- title: "GitHub's roadmap, SQL tricks, and whose bug is it anyway?" publication: "StatusCode Weekly" issue: 277 published_at: "2020-07-29" canonical_url: "https://weekly.statuscode.com/issues/277" --- Plus building a cheap KVM over IP, software developer advice, and a new version of git. #277 — July 29, 2020 [Web Version](https://weekly.statuscode.com/issues/277) StatusCode Weekly Covering the week's news in software development, ops, platforms, and tooling. [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/v1596028175/b1h3v202jsw1rnf6ayne.jpg)](https://hakibenita.com/sql-tricks-application-dba) [Some SQL Tricks of an Application DBA](https://hakibenita.com/sql-tricks-application-dba) — A neat article with a variety of non-trivial tips for database development. If you ever touch SQL, you should find something useful here or at least enjoy the exploration. Haki Benita [The Official, Public GitHub Roadmap](https://github.com/github/roadmap/projects/1) — There are [some notes on what this means](https://github.com/github/roadmap) but basically you can see what the GitHub team are working on, what stage those developments are at, and what’s coming up when. Who’s ready for private instances of GitHub Packages in 2021? GitHub [![\](https://copm.s3.amazonaws.com/87e97607.png)](https://www.ardanlabs.com/corporate-training/?utm_source=Cooperpress%20PrimaryV3) [Remote Instructor-Led Go, Docker, Kubernetes, & Python Training](https://www.ardanlabs.com/corporate-training/?utm_source=Cooperpress%20PrimaryV3) — We offer live-streaming remote training sessions for individual engineers and companies that want to augment their knowledge in Go, Docker, Kubernetes, and Python. We’ve trained over 5,000 engineers via our carefully crafted classes. Ardan Labs sponsor [Cloudflare Unveils 'Workers Unbound'](https://blog.cloudflare.com/introducing-workers-unbound/) — Somehow it’s been three years since Cloudflare released [Workers](https://workers.cloudflare.com/), their JavaScript-powered take on an edge-based serverless platform. _Unbound_ takes Workers a step further with support for longer execution times. In related news, they’ve [also announced broader language support for Workers](https://blog.cloudflare.com/cloudflare-workers-announces-broad-language-support/), by supporting Python, Scala, Kotlin, Reason and Dart out of the box. The Cloudflare Blog [The AWS Bill Heard Around The World](https://chrisshort.net/the-aws-bill-heard-around-the-world/) — We mentioned the Twitter thread about the surprise $2700 AWS bill recently but here’s a proper write up. It’s more nuanced than you think and might have exposed a bug. Chris Short [Amazon Fraud Detector Now Generally Available](https://aws.amazon.com/blogs/aws/amazon-fraud-detector-is-now-generally-available/) — A fully managed service on AWS for identifying potentially fraudulent online activities (think payments or fake accounts). It uses your data, machine learning and ‘more than 20 years of fraud detection expertise’. Alejandra Quetzalli (AWS) **⚡️ Quick bytes:** - Stack Overflow, the popular copy and paste Q&A site, has [raised $85m in series E funding.](https://stackoverflow.blog/2020/07/28/ceo-quarterly-blog-post-3-series-e-funding/) - Google Groups took on a lot of Usenet archives many years ago (including a lot of great programming groups) but unfortunately [these archives are not entirely safe..](https://lwn.net/Articles/827233/) - Do you use [MDN](https://developer.mozilla.org/en-US/)? It [celebrated its _15th birthday_](https://hacks.mozilla.org/2020/07/mdn-web-docs-15-years-young/) last week in a variety of ways 🥳 - Parlez-vous Français? You may [find this 'glossary' of technical terms](https://bitoduc.fr/) amusing. - AWS EC2 has [some new instances based on AWS Graviton2](https://aws.amazon.com/blogs/aws/new-graviton2-instance-types-c6g-r6g-and-their-d-variant/) with local NVMe-based SSD storage. - GitHub has [released an OpenAPI description](https://github.blog/2020-07-27-introducing-githubs-openapi-description/) of their REST API. 💻 Jobs [One Application, Hundreds of Hiring Managers](https://www.vettery.com/tech?utm_source=newsletter&utm_medium=cooper-webopsweekly&utm_term=tech&utm_content=grouped&utm_campaign=ad-77581) — Use Vettery to connect with hiring managers at startups and Fortune 500 companies. It's free for job-seekers. Vettery ℹ️ _Interested in running a job listing in StatusCode Weekly? There's [more info here.](https://booking.cooperpress.com/jobs)_ 📕 Tutorials, Opinions and Stories [Whose Bug Is It Anyway?](https://shkspr.mobi/blog/2020/07/whose-bug-is-it-anyway/) — An interesting example of where a ‘bug’ caused by the interaction of several distinct systems appears to have no clear owner. Terence Eden [Analyzing 1.1 Billion Taxi Rides using OmniSciDB on a MacBook Pro](https://tech.marksblogg.com/omnisci-macos-macbookpro-mbp.html) — The latest in [a line of experiments](https://tech.marksblogg.com/benchmarks.html) Mark has run to analyze a large amount of data with different database systems. This time it’s the turn of [OmniSciDB](https://github.com/omnisci/omniscidb) (formerly known as MapD), a SQL-based columnar database engine. He’s _very_ excited about the results and describes the ability to do this sort of analysis on ‘office equipment’ to be a game changer. Mark Litwintschik [TinyPilot: Building a KVM Over IP for Under $100](https://mtlynch.io/tinypilot/) — Using only a Raspberry Pi and an $11 video capture dongle, you can create your own KVM over IP device, allowing you to send keyboard input to a remote computer and capture its display. Michael Lynch [Advice to Myself When Starting Out as a Software Developer](https://blog.pragmaticengineer.com/advice-to-myself-when-starting-as-a-software-developer/) — Nothing earth shattering here, but solid advice generally. Keep reading, keep learning, figure out refactoring and testing, and _teach_. Gergely Orosz [LogDNA <3 DevOps: Manage Logs on Your Terms](https://logdna.com/serverless-logging-performance-part-1/?utm_campaign=FY20Q3%20%20cooperpress&utm_source=Newsletter%20sposnsorship%20&utm_medium=status-code) — Ingest, retain, and parse to get results you need. Check out this deep dive into optimizing serverless logs. LogDNA sponsor [Introducing Domain-Oriented Microservice Architecture](https://eng.uber.com/microservice-architecture/) — Particularly from the context of Uber’s experiences. Adam Gluck (Uber Engineering) [Basic Ideas for Scaling Relational SQL Databases](https://stribny.name/blog/2020/07/scaling-relational-sql-databases) Petr Stříbný [Flash Game History: How Flash Games Shaped The Video Game Industry](https://www.flashgamehistory.com/) — An quirkily presented love letter to a quirky era of Web based game development. Jonas Richner [Ask HN: Former Software Engineers, What Are You Doing Now?](https://news.ycombinator.com/item?id=23951850) — While I’d quite _like_ you to stay in software, it’s interesting to hear what people who’ve left the software engineering life behind have gone on to do 😁 Hacker News [The Futility of “I Told You So!” in Software Engineering Teams](https://humza.sh/2020/07/24/the-futility-of-i-told-you-so.html) — Pointing out that you were right can backfire in a technical environment. Syed Humza Shah [Porting a macOS Clojure Dev Setup to Windows WSL2](https://blog.michielborkent.nl/2020/07/26/remote-wsl2-clojure/) Michiel Borkent [Some Best Practices for When Running Your Own Small Mail Server](https://bridge.grumpy-troll.org/2020/07/small-mailserver-bcp/) Phil Pennock 🛠 Code and Tools [Git 2.28: A Look at What's New](https://github.blog/2020-07-27-highlights-from-git-2-28/) — `init.defaultBranch` is a new setting so that you can specify an alternative to `master` (such as `main` or `trunk`, say) for your initial, default branch. Taylor Blau (GitHub) [The Regular Expression Visualizer, Simulator and Cross-Compiler Tool](https://blog.robertelder.org/regular-expression-visualizer/) — A neat tool if you want to visualize a regex or even get C code that implements the regex from scratch. Robert Elder [Docker Releases Plugin for Simplified Deployments into AWS ECS and Fargate](https://www.infoq.com/news/2020/07/docker-ecs-plugin/) — Docker has announced the public beta of their enhanced integration of Docker with AWS Elastic Container Service and AWS Fargate. InfoQ [Stream Chat: The Most Feature-Rich, Scalable & High-Speed Chat Solution](https://getstream.io/blog/hipaa-compliant-chat-apps/?utm_campaign=statuscode_ongoing&utm_medium=promoted_newsletter&utm_source=status_code) Stream sponsor [TextDB: A Simple Way to Share Small Amounts of Data](https://textdb.dev/) — You’re not going to use this in production but as a band-aid for a hackathon or some other quick task, it may be worth a look. Ian Davidson [An Intel 8080 Assembler and Online Simulator](https://eli.thegreenplace.net/2020/an-intel-8080-assembler-and-online-simulator/) — A neat online experiment if you want to play with some basic x86.. well x80 really (it’s [complicated](https://www.quora.com/What-is-the-difference-between-8080-and-8086)). Eli Bendersky [Evergreen: A Distributed Continuous Integration System from MongoDB](https://github.com/evergreen-ci/evergreen) — Built by MongoDB to test MongoDB, but it’s written in Go and dynamically allocates hosts to run tasks in parallel across many machines. Evergreen Curated by [Cooperpress](https://cooperpress.com/). [Change your email address](https://webopsweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://webopsweekly.com/leave/*|UID|*). © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom