~/devreads

26 Apr 2023

25 Apr 2023

Eric Elliott 16 min read

Why Every Developer Should Learn ChatGPT and SudoLang I recently started using an AI Driven Development (AIDD) process that has many benefits: Increased development productivity 10x — 20x , allowing us to take on more projects, and more ambitious challenges that would previously have been too resource-intensive to tackle. Opened up our applications to magical features we could not have…

chatgptartificial-intelligencesoftware-developmentmachine-learningai

James Gill 2 min read

We developed the Global Metrics site to show aggregate metrics across all websites using GoSquared Analytics. Global Metrics gave a... The post Saying Goodbye to Global Metrics appeared first on GoSquared Blog.

gosquared updates

lukaseder 1 min read

Microsoft T-SQL supports a language feature called table-valued parameter (TVP), which is a parameter of a table type that can be passed to a stored procedure or function. For example, you may write: This function takes a table-valued parameter (TVP), and produces a result set containing the cross product of the parameter table with itself. … Continue reading How to…

jooq-in-usecode generationcode generatorjavajdbc

Harish Bohara 5 min read

In 2006, British mathematician Clive Humby declared “data is the new oil.”Like oil, data in raw form — sans insights and analysis has limited use. To harness the potential on data, organizations are constantly seeking ways to leverage their data to gain a competitive edge. This is where data science comes into play. CRED has evolved from a single product…

kubernetesdata-science-workflowmodel-repositoryplatformdeployment-automation

24 Apr 2023

Matthew Green 5 min read

As a rule, book reviews are not a thing I usually do. So when I received an out-of-the-blue email from Cory Doctorow last week asking if I would review his latest book, Red Team Blues, it took a minute to overcome my initial skepticism. While I’m a fan of Cory’s work, this is a narrow/nerdy … Continue reading Book Review:…

book reviewsbooksinfosec

23 Apr 2023

Henrik Warne 4 min read

Two months ago, I was a guest on the Maintainable podcast. The first question the host Robby Russell asks is “What are a few characteristics of well-maintained software?”. This is such a great question, and I thought I would expand … Continue reading →

programmingsoftwarewell-maintained

21 Apr 2023

Omari Thompson-Edwards 3 min read

One of the key features of TypeScript is the powerful ability to use union types. These types allow you to combine multiple types together in powerful ways, making it easier to work with complex data structures and functions. In this article, I’ll explain Union types, and when to use them. A union type is a […]

typescript

Omari Thompson-Edwards 4 min read

If you’re working with Typescript and dealing with text processing, you might have heard of a powerful tool called “regex.” Regex, or regular expressions, is a pattern-matching language that allows you to search for specific patterns in text strings. It’s a versatile tool that can be used for a wide range of text processing tasks, […]

typescript

Omari Thompson-Edwards 3 min read

Sending emails is an essential part of many application. In this article, we’ll work through a full-stack solution for sending emails in Next.js, using Next.js API routes, along with SendGrid, a great API service for sending emails. Setting Up To use SendGrid, you’ll need to create an account. Head over to their website and sign […]

next.js

20 Apr 2023

19 Apr 2023

Developer Relations Team 1 min read

Fan-out is a messaging pattern where messages are broadcast in a one-to-many arrangement. A basic example of this pattern can be seen in Pub/Sub.

Developer Relations Team 1 min read

Video chat describes visual, remote communication between two or more parties, each equipped with a camera and microphone.

vladmihalcea 1 min read

Introduction In this article, we are going to see what is the best way to call SQL Server stored procedures with jOOQ. I decided to write this article because stored procedures and database functions are extremely useful for data-intensive applications, and sometimes, they are the only solution to process data efficiently. While SQL remains the de-facto way to query data,…

jooqjavasql serverstored procedure

Rob 1 min read

I recently needed count the number of rows in an SQL query that had a Group By clause. It looked something like this: SELECT account_name FROM events WHERE created_at >= CURDATE() - INTERVAL 3 MONTH GROUP BY account_id This provides a list of account names (28 in my case), but if you try to count them using: SELECT COUNT(account_name) as…

database

18 Apr 2023

Tinder 7 min read

Authored by: Rojan Rijal, Tinder Security Labs | Johnny Nipper, Sr. Director | Tanner Emek, Sr Engineering Manager Summary In 2021, GitHub released support for OpenID Connect (OIDC) for GitHub Actions (GHA), allowing developers to securely interact with their infrastructure resources in Amazon Web Services (AWS), and other major cloud service providers. The OIDC support allows GHA jobs to retrieve…

securitygithubawsoidc

David Walsh 1 min read

Cheating in online games is a huge issue these days — just ask anyone playing PUBG. Cheaters aren’t difficult for players to spot but vendors oftentimes don’t do enough to punish these villains. Krafton recently announced they would start banning cheaters by hardware ID, which got me thinking about how you can get a user’s hardware ID. There’s no definitive…

17 Apr 2023

Nic Raboy 1 min read

So the data within your organization spans across multiple databases, database platforms, and even storage types, but you need to bring it together and make sense of the data that's dispersed. This is... The post Delivering a Near Real-Time Single View into Operations with a Federated Database appeared first on MongoDB.

David Walsh 1 min read

Managing, sorting, and manipulating data with JavaScript is a skill we’ve often delegated to third party libraries like lodash. As the JavaScript language progresses, however, these features eventually get. added to the JavaScript specification. Two such APIs for grouping of Array data are `Array.prototype.group and Array.prototype.groupToMap. Array.prototype.group To group an array of objects by a given property, call the group…

15 Apr 2023

1 min read

What’s the “right” level of CPU utilization for a server? If you look at a monitoring dashboard from a well-designed and well-run service, what CPU utilization should we hope to see, averaged over a day or two? It’s a very general question, and it’s not clear it should have a single answer. That said, for a long time, I generally…

14 Apr 2023

Emmanuel Joubaud 13 min read

The Jobteaser application contains a lot of different relatively independent modules to help universities provide career guidance to students: a job board, a career event management system, a career advice appointment management system… When we decided to migrate our application’s backend from a monolith to a service-oriented architecture, we strived to keep each module as isolated as possible from the…

software-engineeringsoftware-architecturekafkamicroservicesdistributed-systems

1 min read

Our traders and researchers love Python for its agility and for its huge open-source ecosystem, especially when it comes to machine learning. But the heavy use of notebooks can make it difficult to support. Notebooks have a very different lifecycle than regular code, and aren’t always rigorously version controlled. And while most of our code (much of it written in…

13 Apr 2023

David Walsh 1 min read

A while back I wrote an article on how to Convert Image to Data URI with JavaScript. It’s a neat trick developers can use for any number of reasons. Instead of abusing canvas, however, why not simply get the base64 data from command line? You can use base64 and pbcopy to convert a file to base64 and copy it to…

vladmihalcea 1 min read

Introduction In this article, we are going to see how the PostgreSQL Auto Explain feature works and why you should use it to gather the actual execution plan for SQL statements that execute on a production system. SQL Execution Plan As I explained in this article, when you send a SQL statement to PostgreSQL, the statement is executed as illustrated…

postgresqlsqlauto explainexecution plan

Vibhuti Garg 1 min read

Emerging regulations, like the revised U.S. FTC Safeguards Rule, are largely focused on proactive threat defense to drive effective security. Interestingly, the revised U.S. Federal Trade Commission (FTC) Safeguards Rule now covers auto dealers and other “non-banking financial institutions.” This is because automobile dealerships, amongst many other organizations, process and store consumers’ personal financial data. The […] The post Revisions…

spotlightcompliancedns-layer securityftc safeguards rule

11 Apr 2023

Michael Friis 2 min read

In this post, we’d like to share an example of the kind of behind-the-scenes work that the Heroku team does to continuously improve the platform based on customer feedback. The Heroku Common Runtime is one of the best parts of Heroku. It’s the modern embodiment of the principle of computing resource time-sharing pioneered by John […] The post More Predictable…

engineering

Sameera Thangudu 6 min read

Did you know that ground stations transmit signals to satellites 22,236 miles above the equator in geostationary orbits, and that those signals are then beamed down to the entire North American subcontinent? Satellite radios today serve hundreds of channels across 9,540,000 square miles. Unless you’re working at a secret military facility, deep underground, you can…

uncategorizedinfrastructurescalabilitysoftware-architecture

10 Apr 2023

Michael Carroll 1 min read

Network protocols are constantly changing, and many app developers must be able to adapt to the evolving landscape.

David Walsh 1 min read

I’m a big fan of having as much information as I can get within the command line. I couldn’t go without knowing which git branch I’m on, for example. Another important piece of information I like having is my current battery percentage. To get the current battery level from command line, you can run: pmset -g batt | grep -Eo…

8 Apr 2023

Stanko 2 min read

When writing Node.js scripts, I often want to output information to the console in different colors. Usually, it is to get the user's attention and signalize success or error. I could reach for a battle-tested library like Chalk, but I usually don't need all of its features. Instead, I have a tiny script I copy from project to project: const…

7 Apr 2023

Emmanuel Joubaud 12 min read

When it comes to the communication between microservices, there are 2 possible extremes: All-sync: whenever a service needs data from another service, it fetches it via a synchronous API call (REST, gRPC, GraphQL). Service calls service calls service… which tends to evolve into layers of APIs, where each layer has dependencies on the next. All-async: no sync calls between services,…

microservicesgosoftware-engineeringsoftware-architectureruby

6 Apr 2023

Adam Hess 5 min read

Since the beginning, GitHub.com has been a Ruby on Rails monolith. Today, the application is nearly two million lines of code and more than 1,000 engineers collaborate on it daily. We deploy as often as 20 times a day, and nearly every week one of those deploys is a Rails upgrade. Upgrading Rails weekly Every Monday a scheduled GitHub Action…

Nazanin Hoglund 1 min read

Are you writing loans at your car dealership, printing checks, issuing your own store credit card — or otherwise handling consumer financial data? You may not consider yourself a “financial institution” — but the U.S. Federal Trade Commission (FTC) sure does. FTC is classifying countless companies as a “non-banking financial institutions” subject to its revised […] The post FTC Safeguards…

spotlightcomplianceftc safeguards rule

5 Apr 2023

4 Apr 2023

Nic Raboy 1 min read

Need a consistent development and deployment experience as developers work across teams and use different machines for their daily tasks? That is where Docker has you covered with containers. A common... The post Local Development with the MongoDB Atlas CLI and Docker appeared first on MongoDB.

vladmihalcea 1 min read

Introduction Welcome to a new issue of the High-Performance Java Persistence Newsletter in which we share articles, videos, workshops, and StackOverflow answers that are very relevant to any developer who interacts with a database system using Java. Articles The pick of this edition is this article, which explains the performance optimizations done by the Quora engineering team to scale their…

newsletterhibernatejavajpamysql

George Luong 10 min read

Notifications are a key aspect of the Slack user experience. Users rely on timely notifications of mentions and DMs to keep on top of important information. Poor notification completeness erodes the trust of all Slack users. Notifications flow through almost all the systems in our infrastructure. As illustrated in Figure 1 below, a notification request…

uncategorized

3 Apr 2023

Eric Elliott 9 min read

Running Riteway’s usage example tests in SudoLang running on ChatGPT using GPT-4 I have been a long-time advocate of Test-Driven Development (TDD) because of its many productivity and quality benefits. You can read more about those in “TDD Changed My Life” . When I realized that GPT-4 was capable of following complex instructions, one of the first things I thought…

aimachine-learningtechnologyjavascriptchatgpt

jgamblin 2 min read

Reference Rot (also called linked rot) is when hyperlinks, over time, cease to point to their originally targeted file, web page, or server due to that resource being relocated to a new address or permanently unavailable. Tod Beardsley from the CVE board gave a talk at the 2023 CVE Global Summit called ‘Link Rot: The Problem and Archiving for Posterity‘…

uncategorized

1 Apr 2023

1 min read

It’s April Cools again. For a few summers in high school and undergrad, I was a day camp counselor. I’ve written before about how it helped me develop storytelling skills, but recently I thought of it again because, while I was cleaning out a closet full of old junk, I happened upon a bag of embroidery thread. While stereotypically used…

Eric Elliott 15 min read

Pseudocode is a fantastic way to sketch programs using informal, natural language, without worrying about specific syntax. It’s like sketching your thoughts before diving into the nitty-gritty of coding. It’s useful for brainstorming and communicating ideas with others. I have been using pseudocode to express ideas to Large Language Models (LLMs) since GPT-3 was announced in mid 2020. However, up…

chatgptnlpsoftware-developmenttechnologyai

31 Mar 2023

Courtney Webster 3 min read

The April 2023 release of the Python and Jupyter extensions for Visual Studio Code are now available. This release includes Data Wrangler, a create environment button embedded in dependency files, environments API for extension authors, kernel picker improvements, and move symbol refactoring. Keep reading to learn more! The post Python in Visual Studio Code – April 2023 Release appeared first…

python

Emmanuel Joubaud 8 min read

This is an introduction to how we’ve implemented microservices at a mid-size scale-up called Jobteaser , with a mix of Go and Ruby service chassis, gRPC APIs and data replication via Kafka. Foundation: The service chassis Back in early 2019, when Jobteaser decided to get serious about breaking up its decade-old Rails monolith into microservices, we assembled a Foundation team…

microservicesgosoftware-architecturerubysoftware-engineering

30 Mar 2023

29 Mar 2023

28 Mar 2023

Oliver Carson 1 min read

create a game scoring system that enhances player experience, from tracking scores to integrating social features for more engaging gameplay

Developer Relations Team 1 min read

Read our complete guide on how to build a telemedicine app. In this guide, you’ll learn about telemedicine, HIPPA, PHI, and solutions for building.

Developer Relations Team 1 min read

In this guide, we describe why you’d want to build a 2d game, types of 2d games, and tips for making your 2d games interactive, social, and engaging.

Oliver Carson 1 min read

Learn how to enable objects to store metadata for users, channels, and memberships without the need of setting up your own database.

Oliver Carson 1 min read

Follow this how-to and learn how you can build and power your Unity games with PubNub.

Oliver Carson 1 min read

Read our complete guide on building interactive role-playing games. In this guide, you’ll learn to build interactive elements for online games.