tutorial - CybAI news

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…

30 Jun

What is Associative Arrays in Computer Science

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

In computer science, an associative array, map, symbol table, or dictionary is an abstract data type that stores a collection of (key, value) pairs, such that each possible key appears at most once in the collection. In mathematical terms, an associative array is a function with a finite domain. It supports 'lookup', 'remove', and 'insert' operations. The Dictionary Problem The dictionary problem is the classic problem of designing efficient data structures that implement associative arrays. The two major solutions to the dictionary problem are hash tables and search trees. It is sometimes also possible to solve the problem using directly…

30 Jun

Scaling databases with AWS RDS and read replicas

stp2y0 CommentsNewsaws, cloud, coding, community, database, development, engineering, inclusive, software, tutorial

Amazon Web Services (AWS) Relational Database Service (RDS) is a managed service that simplifies the process of configuring, operating, and scaling a relational database in the cloud. AWS RDS is a versatile choice that supports several database engines including PostgreSQL, MySQL, Oracle, MariaDB, Microsoft SQL Server, and Amazon's own Aurora. Advantages of using RDS over a self hosted database Managed Service - AWS RDS is a fully managed service, which means that AWS takes care of provisioning, patching, backup, recovery, and even scaling. This allows developers and database administrators to focus on the application development and optimization rather than managing…

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…

27 Jun

Como Escanear Portas em um Website com Python

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, network, python, software, tutorial, website

Você já deve ter ouvido falar do Nmap e de escaneamento de portas em servidores, bem, nesse script feito em Python vamos fazer algo bem semelhante, vamos verificar as portas abertas em websites. Vamos explorar um pouco de maneira simples e fácil de entender Introdução Portas abertas em um servidor são como portas de entrada para diferentes serviços. Saber quais portas estão abertas pode ajudar você a entender melhor a segurança do seu site ou simplesmente satisfazer sua curiosidade sobre o funcionamento interno de um site. Vamos mergulhar em um script que escaneia essas portas usando Python. Código completo import…

26 Jun

Use AWS Generative AI CDK constructs to speed up app development

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, infrastructureascode, machinelearning, python, software, tutorial

Assemble and deploy the infrastructure for a RAG solution using AWS CDK for Python In this blog, we will use the AWS Generative AI Constructs Library to deploy a complete RAG application composed of the following components: Knowledge Bases for Amazon Bedrock: This is the foundation for the RAG solution. OpenSearch Serverless collection: It supports the vector search collection type that provides similarity search capability. An S3 bucket: This will act as the data source for the Knowledge Base. AWS Lambda function (written in Python) along with an API Gateway that uses the RetrieveAndGenerate API to query the knowledge base…

25 Jun

Introduction to the Periodic Table of DevOps Tools

stp2y0 CommentsNewsbeginners, coding, community, development, devops, engineering, inclusive, software, tools, tutorial

In the rapidly evolving landscape of DevOps, selecting the right tools can be daunting. The "Periodic Table of DevOps Tools" serves as a comprehensive guide, categorizing and organizing tools into various functions, making it easier for practitioners to navigate the complex ecosystem. This blog will introduce you to this innovative approach and prepare you for deeper dives into individual tools in upcoming posts. Understanding the Periodic Table of DevOps Tools The concept of a periodic table in DevOps is inspired by the periodic table of chemical elements, but instead of elements, it categorizes a myriad of tools across different stages…

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…

24 Jun

Unlocking Developer Secrets: Insights Beyond the Code

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

By 2030, it's predicted that we'll all be content creators. While this might sound like a futuristic fantasy to some, I find it an intriguing prediction. After all, sharing knowledge and experiences is a core human desire. Full disclosure: I wouldn't exactly call myself a wordsmith. For years, my fingers have flown across keyboards crafting code, not catchy headlines. But maybe that's the point. As a seasoned developer, I bring a unique perspective to the content creation table. So, consider this my first tentative step into this exciting new world. I'm here to share my experiences – the triumphs, the…

23 Jun

4 Ideas to Create Organic Growth for a Web App

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, seo, software, startup, tutorial, webdev

Growing a web app is hard, especially when you have limited capital. This is usually the case for us small indie developers, and because of that, I have built an arsenal of growth ideas to launch that website with a bang! 1. Utilize social media When starting out, the easiest win is social media. It can generate a lot of buzz right out of the gates, and people tend to share a website they like with their friends. My usual launch of a website goes something like this: Publishing 10 short form videos (Across YouTube shorts, TikTok and Instagram Reels)…