We plan to dig deep into this topic on Brain Science (listen and subscribe here), but until then, here’s some great advice from Flavio Copes based on many years of working remotely. I’m an introvert, I am independent and I like doing things alone. This post is heavily influenced by this fact, and you might find that what I say is madness if you’re an extrovert who needs people around to be productive. The first suggestion I have for you is to have a dedicated office space. It does not need to be in another building, but it might be necessary if you have lots of people in your house. I do have a dedicated room, with a door I can close. It’s very helpful because it avoids.. interruptions.

read more

In an effort to make my team write better SQL, I went over reports written by non-developers and code reviews, and gathered common mistakes and missed optimization opportunities in SQL. Dividing integers, accidentally counting nullable columns, column position in GROUP BY and ORDER BY, and 9 other common gotchas. Don’t get got!

read more

Flowy makes creating WebApps with flowchart functionality an incredibly simple task. Build automation software, mind mapping tools, or simple programming platforms in minutes by implementing the library into your project. Live demo here.

read more

If you are a leader or someone aspiring to lead, consider this approach to engineering management. This post is a summary of the approach and tools I’ve used to build an engineering team, where everyone is a leader - including sharing of the project management expectations Google Docs guide that my team uses. It’s also a reflection on the pain points that came with this approach. I can’t advocate for how universally this approach could work. However, based on my results, it is something I suggest engineering leaders - especially frontline managers - consider as an option.

read more

This package is does not have the goal of parsing all possible date formats and timestamps, I recommend you attempt parsing those first and then falling back on this package to provide “natural language” support.

read more

Watch out! If you start reading this paper you could be lost for hours following all the interesting links and ideas, and end up even more dissatisfied than you already are with the state of software today. You might also be inspired to help work towards a better future. I’m all in :). I co-sign that sentiment. When the author says “this paper” they are referring to this paper which they are about to summarize. If you haven’t considered local-first software before, you should know that there are seven key properties to it, which are described in detail in the paper and in brief in the summary.

read more

Our approach comes from low-latency trading; QuestDB’s stack is engineered from scratch, zero-GC Java and dependency-free. QuestDB ingests data via HTTP, PostgresSQL wire protocol, Influx line protocol or directly from Java. Reading data is done using SQL via HTTP, PostgreSQL wire protocol or via Java API. The whole database and console fit in a 3.5Mb package. According to the great knowledge base in the sky, NewSQL is, “a class of relational database management systems that seek to provide the scalability of NoSQL systems for online transaction processing workloads while maintaining the ACID guarantees of a traditional database system.”

read more

This booklet covers four main steps of designing a machine learning system: Project setup Data pipeline Modeling: selecting, training, and debugging Serving: testing, deploying, and maintaining It comes with links to practical resources that explain each aspect in more details. It also suggests case studies written by machine learning engineers at major tech companies who have deployed machine learning systems to solve real-world problems.

read more

Prior to Unicode, international communication was grueling- everyone had defined their separate extended character set in the upperhalf of ASCII (called Code Pages) that would conflict- Just think, German speakers coordinating with Korean speakers over which 127 character Code Page to use. Thankfully the Unicode standard caught on and unified communication. What follows is an awesome list of Unicode “tidbits, packages, and resources”. And of course there’s a sub-section on everyone’s favorite: emojis

read more

If you’re looking for a thorough primer of Go modules, Bill Kennedy has you covered: In this post, I will focus on the transition from GOPATH to modules and the problems modules are solving. Along the way, I will provide just enough of the semantics so you can have a better understanding of how modules work at a high level. Maybe more importantly, why they work the way they do. When you’re done with this, check out part 2 of the series about projects, dependencies, and gopls.

read more

Lots of cool new features, such as MariaDB support, exclusion constraints for Postgres users, filter expressions, and more. Congrats to all involved on a great release! 🎉

read more

When your database is the source of truth, it’s often useful to inspect that truth and reuse it elsewhere in your application. import pgStructure from "pg-structure"; async function demo() { const db = await pgStructure({ database: "db", user: "u", password: "pass" }, { includeSchemas: ["public"] }); const table = db.get("contact"); const columnNames = table.columns.map(c => c.name); const columnTypeName = table.columns.get("options").type.name; const indexColumnNames = table.indexes.get("ix_mail").columns; const relatedTables = table.hasManyTables; }

read more

Metaflow is a joint effort by Netflix and AWS that attempts to solve the discrepancy between what data scientists care about and what they spend their time doing (pictured below). Get the backstory on Netflix’s technology blog.

read more

It can be used to build websites, documents and feeds, as a templating tool, or as a renderer for higher-level components and tools. It’s primary focus is on static site generation and Swift-based web development. I’ve always enjoyed using DSL’s like this. let html = HTML( .head( .title("My website"), .stylesheet("styles.css") ), .body( .div( .h1("My website"), .p("Writing HTML in Swift is pretty great!") ) ) )

read more

Certbot was first released in 2015, and since then it has helped more than two million website administrators enable HTTPS by automatically deploying Let’s Encrypt certificates. Let’s Encrypt is a free certificate authority that EFF helped launch in 2015, now run for the public’s benefit through the Internet Security Research Group (ISRG). A lot of progress has been made since we first talked about Let’s Encrypt on The Changelog.

read more