productivity - CybAI news

02 Jul

Boost Team Efficiency with Smaller PRs

stp2y0 CommentsNewscicd, coding, community, development, devops, engineering, inclusive, productivity, software

Ever felt overwhelmed by massive Pull Requests (PRs) that drag on for days, or even weeks? John Kline from Riot Games has the answers you’ve been looking for. In a recent DevLogue episode, John dished out game-changing insights on how reducing PR size can supercharge your team's performance. Slice and Dice: Breaking Down the Work The first step to conquering PR bloat is breaking down work into bite-sized chunks. Forget those monstrous, long-lived PRs. Instead, aim for short-lived PRs that deliver small, incremental changes daily. This not only makes reviews a breeze but also minimizes risk and integration issues. Two…

02 Jul

Uttam Prayas Foundation: Growing Education and Health

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, ngo, productivity, software, uttamprayasfoundation

The Uttam Prayas Foundation is a remarkable organization making a big difference in Greater Noida West. They help people in need and care deeply about the environment. Their belief, "True education lies in doing charity, serving others, and doing so without ego," drives all their efforts. This means they believe the best way to learn is by helping others without expecting anything in return. Let’s look at how the Uttam Prayas Foundation makes a positive change in the world. Here are some of their amazing programs and activities that benefit the community. Health and Well-Being Programs Free Health Check-Up CampsThe…

01 Jul

Split & Group Text and Perform Distinct on Each Group

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, productivity, programming, software, tutorial

Problem description & analysis: Below is an irregularly categorized detail table. Column A and column B are categories and both have duplicate values. Column C contains detailed data consisting of strings separated by "comma+space", and there are duplicates among the string values. Task: Split detail data in each category, group them by category, get unique values of each group, and concatenate them using "comma+space". Solution: Use SPL XLL to enter the following formula: =spl("=E@b(?.group(~1,~2;~.conj(~3.split@ct()).id().concat("","")))",A2:C12) Enter fullscreen mode Exit fullscreen mode As shown in the picture below: Explanation: group()function groups rows and handles data in each group; ~1 represents the first…

27 Jun

Import A TXT File Where The Separator Is Missing In A Column To Excel

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, productivity, programming, software, tutorial

Problem description & analysis: We have a comma-separated txt file that has a total of 10 columns. As certain values of the 3rd column do not have separators, that column is missing and the corresponding rows only have 9 columns, as shown in the last rows: We need to import the txt file to an Excel file. If the 3rd column is missing, use space to fill it and then sort rows by the 1st column: A B C D E F G H I J 3 01-0104-0133 MAYO RONIE #2 202403 2024-03-21 22:51:43.000 1449.49 0 0 8 4 01-0120-0137…

25 Jun

ONTO THE OTHER

stp2y0 CommentsNewsbeginners, coding, community, design, development, engineering, inclusive, productivity, software

Hey everyone, I got super busy with a lot of stuff, but I am back! So, where were we? Ah yes, check out the progress I made in the past two hours. I wanted to update you all as soon as possible (image1). (image1) Yes, I know it looks like a Mario tube right now, and you're probably thinking, "What in the world is this?" Basically, I want to attach the actual head of the turret onto this thing. Remember how I wanted to make this a rail gun and showed a picture of how I wanted it to look?…

24 Jun

In Excel, Parse Hexadecimal Numbers And Make Queries

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, productivity, programming, software, tutorial

Problem description & analysis: In the following table, value of cell A1 is made up of names of several people and their attendances in four days. For example, c is 1100 expressed in hexadecimal notation, meaning the corresponding person has attendance in the 1st day and the 2nd day and is absent in the 3rd day and the 4th day. We need to find the number of people who has the attendance in the day input in A2. For example, three people are present in the 1st day and two people are present in the 3rd day. Solution: Use SPL…

22 Jun

The Body Shop of Security: Biometrics

stp2y0 CommentsNewscoding, community, development, discuss, engineering, inclusive, learning, productivity, security, software

Introduction Biometrics is a physical security technique that makes use of a person's physical characteristics which are unique to that person.This technique is used to authenticate the user's identity and grant access to the certain things. It is a kind of personal touch for authentication which can only be done by the genuine user. Types of Biometrics _Physiological : _ Physiological Biometrics is based on a person's body's unique features like fingerprints, facial recognition, iris scan, etc. This system of authentication is difficult to forge as compared to passwords. This type of security will remain constant throughout the person's life…

21 Jun

Understanding Microservices: A Technical Overview

stp2y0 CommentsNewsarchitecture, coding, community, development, engineering, inclusive, microservices, productivity, software

Since the end of 2017, the term "microservices" has become increasingly common. But what exactly are microservices? "Microservices are small, autonomous services working together to meet a specific demand." or "Independent services that together compose a single system." To clarify, microservices represent a software architecture, not merely a web service. As many systems and applications grow, it becomes increasingly challenging to implement changes. A simple change can necessitate a massive deployment. With luck, a deployment pipeline can ensure everything functions correctly before going live. We are moving towards a scenario where we use physical servers for deployment. Now imagine deploying…

18 Jun

Case Study – TDD in Node.js Inspector Server and Other Projects

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, productivity, software, softwaredevelopment, testing

Overview Test Driven Development (TDD) is a software development methodology where tests are written before the actual code. The progress of implementation is then guided by the status of these tests. There is often confusion between the terms "automated testing," "unit testing," and "TDD." To clarify: Automated Testing refers to any testing performed by specialized software without requiring manual intervention. This includes various types of testing, depending on the scope (unit/integration) or the metrics being evaluated (correctness, security, load, benchmarking). Unit Testing is a subset of automated testing that focuses on the smallest, independent logical units of code. These tests…

17 Jun

In Excel, Identify Data Layers Correctly and Convert Them to a Standardized Table

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, productivity, programming, software, tutorial

Problem description & analysis: Data in the column below has three layers: the 1st layer is a string, the 2nd layer is a date, and the 3rd layer contains multiple time values: A 1 NAME1 2 2024-06-03 3 04:06:12 4 04:09:23 5 08:09:23 6 12:09:23 7 17:02:23 8 2024-06-02 9 04:06:12 10 04:09:23 11 08:09:23 12 NAME2 13 2024-06-03 14 04:06:12 15 04:09:23 16 2024-06-02 17 12:09:23 18 17:02:23 Enter fullscreen mode Exit fullscreen mode We need to identify the three layers of data correctly and convert them to a standardized table: D E F 1 NAME1 2024-06-03 04:06:12 2…