backend - CybAI news

15 Nov

EXPLAIN PLAN and DBMS_PROFILER

stp2y0 CommentsNewsbackend, coding, community, development, engineering, fullstack, inclusive, oracle, plsq, software

In Oracle SQL, EXPLAIN PLAN and DBMS_PROFILER are tools used to analyze and optimize query performance, but they serve different purposes and provide distinct insights. EXPLAIN PLAN EXPLAIN PLAN helps you understand the query execution path chosen by the Oracle optimizer. It shows the series of operations Oracle will use to execute your SQL statement, such as table scans, index scans, joins, and sorts. By examining the execution plan, you can identify areas where the query could be optimized. Key Operations in EXPLAIN PLAN: Table Access: Indicates how the table is accessed, such as a full scan (TABLE ACCESS FULL)…

03 Nov

Converting Blazor Project to WebForms Core

stp2y0 CommentsNewsbackend, blazor, coding, community, development, dotnet, engineering, inclusive, opensource, software

WebForms Core technology helps developers manage HTML tags on the server side without the need for client-side scripting. WebForms Core is a feature in the core of the CodeBehind framework. Note: CodeBehind framework is a powerful replacement for ASP.NET Core MVC and Razor Pages and other backend frameworks.The use of WebForms Core technology also makes developers not need to use front-end frameworks such as Vue, Angular and React.However, these two are not a replacement for WebAssembly; But they are well coordinated with WebAssembly. The following project is the default version 8 of Blazor .NET Core technology, which has been rewritten…

11 Oct

Fibonacci, Integer overflow, memoization e um exagero

stp2y0 CommentsNewsalgorithms, backend, coding, community, development, engineering, inclusive, java, learning, software

Vamos fazer um exercício. Abaixo deixo um código que retorna o número na posição n da sequência de Fibonacci: public static int fib(int n){ if (n <= 1){ return n; } return fib(n-1) + fib(n-2); } Enter fullscreen mode Exit fullscreen mode Que tal tentarmos mostrar no nosso terminal todos os números da sequência de fibonacci menores que 2147483647? public static int fib(int n){ if (n <= 1){ return n; } return fib(n-1) + fib(n-2); } public static void main(String[] args) { int position = 1; int currentNumber = fib(position); while (currentNumber < 2147483647) { System.out.println(currentNumber); position++; currentNumber = fib(position);…

03 Oct

Thought-Provoking Questions Every Backend Developer Should Ask

stp2y0 CommentsNewsbackend, backenddevelopment, beginners, coding, community, development, engineering, inclusive, software, tutorial

Whenever I embark on a backend development project, I find it essential to ask myself a set of critical questions. These questions help guide my approach to building a system that is scalable, secure, and highly performant. Here are some of the key areas I focus on and the thought-provoking questions I ask to ensure I'm building the best possible solution. 1. API Design & Usability APIs are the backbone of many backend services. They need to be both functional and easy to use, but they also require speed, security, and resilience against abuse. Some of the questions I ask…

29 Sep

Why is impossible to have a clean architecture inside a frontend project

stp2y0 CommentsNewsarchitecture, backend, coding, community, development, engineering, flutter, frontend, inclusive, software

The internet is full of videos, courses and articles teaching you to have something like "domain" folders in your frontend project, to create "entities" and everything that would make Uncle Bob fall apart. This little post shows why it's impossible to have a clean architecture in this kind of project. Clean Architecture Clean Architecture is a set of good practices to build a good architecture. It is based on the following principles: Independent of Frameworks Testable Independent of UI Independent of Database Independent of any external agency This post will not gonna dive into them. You can check the original…

27 Sep

Amazon Simple Queue Service (SQS)

stp2y0 CommentsNewsaws, backend, coding, community, development, engineering, inclusive, software, sqs, webdev

Amazon Simple Queue Service (SQS) is a fully managed messaging service offered by AWS (Amazon Web Services). It enables applications to communicate asynchronously by sending and receiving messages through queues. SQS is particularly useful for decoupling components of a distributed system, thereby improving the scalability and resiliency of the application. Key Features: 1. Standard Queues: Provides at-least-once delivery with no strict ordering guarantees.2. FIFO (First-In-First-Out) Queues: Ensures messages are delivered in the exact order they were sent, eliminating duplicates.3. Automated Management: SQS handles infrastructure, scaling, and redundancy, ensuring high availability.4. Durability and Security: Messages are stored securely with encryption at…

02 Sep

EF Core queries for unmapped types

stp2y0 CommentsNewsbackend, coding, community, csharp, database, development, dotnetcore, engineering, inclusive, software

Introduction Learn how to return unmapped types using SqlQuery which may be useful when mapped types are not sufficient. There are several overloads for SqlQuery, here we will use the following along with SqlQueryRaw which is not recommended as unlike SqlQery will leave parameters exposed to hackers. SqlQuery Create the SQL statement, in this case the SQL is to get all United States holidays in a given year. public static FormattableString GetHolidays(int year) => $""" SELECT CalendarDate, CalendarDateDescription AS [Description], CalendarMonth, DATENAME(MONTH, DATEADD(MONTH, CalendarMonth, -1)) AS [Month], CalendarDay AS [Day], DayOfWeekName, IIF(BusinessDay = 0, 'No', 'Yes') AS BusinessDay, IIF(Weekday =…

01 Sep

Day 2: Creating a Signup Page with Express.js – Building the Foundation for User Registration

stp2y0 CommentsNewsauthentication, backend, coding, community, development, engineering, express, inclusive, software

Despite a busy schedule as a Customer Engineer, I found time to explore the process of creating a signup page using Express.js. Here’s a step by step breakdown of the process: Explanation of Steps Create an Express App: Start by initializing a new Express.js application. Create a Port for the Server: Define a port where your server will listen for requests. Accept Body Data (Middleware): Middleware functions are crucial in Express.js to handle and process requests before they reach your route handlers. Use middleware like express.json() to handle incoming JSON or URL-encoded data. Have HTML Pages for Signup Form: Design…

29 Aug

How I Hacked a Company Recruitment Test The Unexpected Tech Adventure of My College Life

stp2y0 CommentsNewsbackend, coding, community, cybersecurity, development, engineering, inclusive, node, security, software

Ah, college life! The thrill of final year comes with the excitement of job placements. We all know the drill: companies come to campus, conduct aptitude tests, coding challenges, and sometimes, we get to showcase our skills in a high-stakes interview. But what if I told you that one of those tests turned into an unexpected adventure involving a bit of hacking? Buckle up as I share how I turned a routine exam into an impromptu tech experiment—and how it all unfolded. The Recruitment Challenge In our final year, our college arranged several companies to visit for recruitment. Most of…

24 Aug

Practical Guide to Set Up Multiple NodeJS Apps on AWS EC2 Instance with Automatic Deployment using GitHub Actions (Screenshots)

stp2y0 CommentsNewsbackend, coding, community, development, engineering, express, githubactions, inclusive, node, software

Introduction First of all, this is a verrrrrryyyyy loooooooooonnng epistle. Feel free to skim through to get the gist, and then come back again when you need to use it for a project. In this guide, I'll be as detailed as possible guiding you step by step on setting up your EC2 Instance, your code repository up to testing your deployment. Bookmark! Let's go! Setting Up an EC2 Instance on AWS. Navigate to the EC2 dashboard. Click on "Launch Instance" to create a new EC2 instance. Choose an Amazon Machine Image (AMI) (We'll use an Ubuntu Server AMI for this…