tutorial - CybAI news

14 Aug

Como somar horas no Google Sheets usando critérios para filtrar linhas?

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, javascript, software, tutorial, webdev

Olá, pessoal! Hoje quero compartilhar um script super útil que criei para resolver um problema comum no dia a dia. Se você já tentou somar "duração" no Google Sheets, deve ter percebido que as fórmulas SUMIF e SUMIFS não funcionam para somar durações de eventos ou produtos com base em critérios específicos. Isso pode ser um obstáculo dependendo do tipo de cálculo que você precisa fazer. Mas não se preocupe! O Google Sheets permite criar scripts em JavaScript e usá-los como fórmulas personalizadas. No meu script, criei duas variações: a primeira aceita um critério e a segunda até dois. Estou…

13 Aug

How to Install and Configure SafeLine WAF: A Quick Start Guide

stp2y0 CommentsNewscoding, community, cybersecurity, development, docker, engineering, inclusive, software, tutorial, webdev

Installing SafeLine To install SafeLine on a Linux system, run the following command:(Ensure you have Docker and Docker Compose installed beforehand.) bash -c "$(curl -fsSLk https://waf.chaitin.com/release/latest/setup.sh)" Enter fullscreen mode Exit fullscreen mode Default Installation Path: /data/safeline Logging into SafeLine Access SafeLine via the default port: 9443. Once you log in, you should see a screen similar to the one below. Feature Overview 1. View Attack Events You can click on the details to see the commands you entered, your IP, the time, and the type of injection detected. 2. Site Protection DetailsFor a single-site setup, you can view directories. 3.…

13 Aug

#44 — Group Rows And Combine Non-Null Values in Each of The Non-Grouping Columns

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

Problem description & analysis: In the Excel table below, the 1st column is the category; columns from the 2nd to the 42nd are parallel columns of data items (below only shows some of the columns), where there are two types of values – X and null. Occasionally, there are duplicate values in a column under the same category. Task: Group rows and combine values in each column in each group; only display one of the duplicate values if there are any. Solution: Use SPL XLL to do this: =spl("=?.group(~1).(g=~,(r1=~1).(g.(~(r1.#)).ifn()))",A2:E11) Enter fullscreen mode Exit fullscreen mode As shown in the picture…

12 Aug

Understanding and Implementing Static Arrays

stp2y0 CommentsNewscoding, community, cpp, development, engineering, inclusive, programming, software, tutorial

Important Takeaways Arrays allow us to keep track of lists of data of the same type (e.g., a list of numbers, strings, chars, etc.). There are two types of arrays: static and dynamic. This article focuses on static arrays. Static arrays require knowing the size at compile time, while dynamic arrays allow setting the size at runtime. Arrays can have any number of dimensions (1D, 2D, 3D, etc.), and each dimension can have any size, limited by the computer’s memory. For loops are the most appropriate structure to iterate over an array. Note that array indexes start at 0, not…

10 Aug

How to Install Windows Subsystem for Linux (WSL) and Run the Ubuntu Subsystem on Windows Using the Terminal

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, Linux, software, tutorial, ubuntu, window

If you've ever wanted to run Linux on your Windows computer, you're in the right place! In this blog, I'll guide you through the simple process of installing the Windows Subsystem for Linux (WSL) and getting the latest Ubuntu subsystem up and running—all from the terminal. By the end of this tutorial, you'll be able to use Ubuntu directly from your Windows machine. Let's get started! Step 0: Prepare Your Windows for WSL InstallationBefore we dive into enabling WSL and installing Ubuntu, you need to make sure certain features are enabled on your Windows machine. These features are essential for…

08 Aug

Introduction to SOLID Principles in Java Development

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, java, software, tutorial, webdev

In the ever-evolving field of software development, one of the biggest challenges is ensuring that code remains clean, maintainable, and scalable as projects grow. This is where the SOLID principles come into play. Coined by Robert C. Martin, also known as Uncle Bob, and later popularized by Michael Feathers, these five principles provide a solid (pun intended) foundation for writing object-oriented code that stands the test of time. But what exactly are the SOLID principles, and why should you, as a Java developer, care about them? In this post, we’ll explore each of these principles, understand their importance, and see…

08 Aug

How to add shadcn to existing project

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, javascript, nextjs, shadcn, software, tutorial

If you are a web developer, chances are you heard about shadcn/ui, one of the most popular component libraries based of Radix UI. In this post we'll explore how to add shadcn to existing project. Depending on how your project is setup and what framework you are using, adding shadcn to your existing project will vary. When using shadcn Typescript is recommended when using this library. Nevertheless, JavaScript version is also available. To add shadcn to your project first you will have to install Tailwind CSS if your project is not using it, since shadcn components are styled with it.…

07 Aug

Form Validation in React: An In-Depth Tutorial with Hooks and React Hook Form

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, react, reacthook, software, tutorial

Form validation is a crucial aspect of web development that ensures user inputs are accurate, complete, and consistent. In React, handling form validation can be achieved using various methods, including built-in hooks and specialized libraries like React Hook Form. This tutorial will walk you through the process of implementing form validation in React using both React hooks and the React Hook Form library. If you need help with complex form validation or prefer to focus on other parts of your project, consider hiring dedicated React developers to streamline your development process. Introduction Forms are a fundamental part of any web…

07 Aug

When to Consider Design Patterns

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, programming, software, softwaredevelopment, tutorial

This week, at the study group, our engineer asked a question: Should we follow the design pattern to design and implement the project from the beginning? The design pattern mentioned here refers to GoF's Design Patterns. Meanwhile, there is a related context which suggests that our coding should follow SOLID principle as much as possible, especially the first S and the second O, anyway. Since SOLID principle should be followed as much as possible, then the design pattern should also be taken into consideration from the very beginning, right? No, not really. What are design patterns? The design patterns we…

05 Aug

Angular Routing and Navigation Made So Easy A Child Could Do It

stp2y0 CommentsNewsangular, coding, community, development, engineering, inclusive, software, tutorial, typescript, webdev

As a junior developer one of the things that made it easier for me to navigate the code of large scale applications was understanding the concept of routing and navigation. This post focuses on the fundamentals of routing in Angular. It does not include more advanced concepts like route guards. I feel that once you strip away some of the complexities of code and focus on the fundamentals then the code becomes easier to understand. After that, you fill in the details (i.e. add back the complexity). Here I am demonstrating the fundamental concepts of routing in a story book…