Skip to content
360SOFTY
HomeInsights

Insights

Ideas for building
better software.

Engineering perspectives on architecture, product development, AI, and the everyday decisions behind useful software.

From the engineering desk

Browse practical articles or follow the latest technology updates.

Subscribe via RSS →

Curated links from external sources — not 360Softy original articles.

ExternalSoftware Engineering
DEV Community

Month-over-Month Growth in SQL: LAG, the Growth Formula, and the Traps

By Michael Nocito, data analyst · Published August 7, 2026 By the end of this page you can write a month-over-month growth query and trust its answer. You will know the growth formula and how to say it in a sentence, what LAG() actually does, and the three traps that produce wrong percentages without producing an error: integer division, the empty first month, and the missing month. It is about twenty minutes. Here is what to actually do today. Before you trust any growth query you have already

sqldatabasetutorial
DEV CommunityRead original
ExternalSoftware Engineering
DEV Community

How to Find Duplicate Rows in SQL (and Decide What Counts as One)

By Michael Nocito, data analyst · Published August 7, 2026 By the end of this page you can check any table for duplicate rows, list every copy, and mark which one to keep, all with queries you understand. You will also know the step that comes before any query: deciding what "duplicate" means for this table, because two rows can match on everything or on one column, and those are different problems with different fixes. It is about twenty minutes. Here is what to actually do with it. On the next

sqldatabasetutorial
DEV CommunityRead original
ExternalSoftware Engineering
DEV Community

pandas GroupBy: How to Summarize a DataFrame Without Losing Track of Your Rows

By Michael Nocito, data analyst · Published August 7, 2026 By the end of this page you can take a DataFrame, summarize it by any column or combination of columns, get several statistics at once with sensible names, and account for every row that went in, including the ones pandas would otherwise drop without telling you. It is about twenty-five minutes, and every output shown was produced by actually running the code on the table printed below. Here is what to actually do today. In your next gro

pythonpandasdataanalysis
DEV CommunityRead original
ExternalSoftware Engineering
DEV Community

POO: Herança

Introdução Uma classe (subclasse/derivada) reaproveita estrutura e comportamento de outra (superclasse/base), podendo especializar o que for necessário. class Funcionario { public string Nome { get; set; } protected decimal SalarioBase; public Funcionario(string nome, decimal salarioBase) { Nome = nome; SalarioBase = salarioBase; } public virtual decimal CalcularSalario() => SalarioBase; } class Gerente : Funcionario { private decimal _bonus;

codingdotnetprogramming
DEV CommunityRead original
ExternalTechnology Trends
The Verge Tech

HoverAir’s transforming modular drone has already been halted in the US

The HoverAir Versa. | Image: HoverAir I am so sorry, fellow US gadget fans: the FCC's drone ban appears to have struck again. The HoverAir Versa - a baby steadycam with snap-on propeller wings that transform it into a drone - has already stopped taking US orders just three days after its Indiegogo debut, and may be forced to abandon shipping plans in the US. HoverAir is now telling backers it's only shipping its camera to the US, not the piece that turns it into a drone, "due to a few remainin

The Verge TechRead original
ExternalTechnology Trends
The Verge Tech

TikTok will pay $400 million to settle DOJ child privacy lawsuit

The US Department of Justice announced on Friday that TikTok will pay $400 million to settle a lawsuit filed in 2024 over allegedly violating the Children's Online Privacy Protection Act (COPPA). In the lawsuit, the DOJ alleged that TikTok collected data from children without notifying parents or obtaining consent and did not delete the accounts when parents requested. TikTok is set to pay $300 million right away and will pay a further $100 million "upon entry of an order vacating a prior consen

The Verge TechRead original

Let’s start with a conversation

Tell us what you’re working on.

An idea, a challenge, or a system that needs to work better. We’ll help you understand the next step.

Discuss your project

Prefer email? [email protected]