📂 Ruwan Suraweera ARTICLES

How to Convert CSV to SQL: Types, Dialects & Safe INSERT Statementshow-to-convert-csv-to-sql

How to Convert CSV to SQL: Types, Dialects & Safe INSERT Statementshow-to-convert-csv-to-sql

How to Convert CSV to SQL A CSV is just rows of text;...

Read More

How to Convert CSV to SQL: Types, Dialects & Safe INSERT Statementshow-to-convert-csv-to-sql

how-to-convert-csv-to-sql

How to Convert CSV to SQL A CSV is just rows of text; a SQL table is structured, typed data. Turning one into the other is a routine task, but doing it well means understanding a few things the automatic tools handle quietly: how columns become types, why the same query looks different across databases, … Read more

How PDF Files Work Inside – Text, Pages and Why Redaction Is Hard

How PDF Files Work Inside – Text, Pages and Why Redaction Is Hard

How PDF Files Work Inside A plain explanation of what is actually stored...

Read More

How PDF Files Work Inside – Text, Pages and Why Redaction Is Hard

how PDF files work

How PDF Files Work Inside A plain explanation of what is actually stored inside a PDF, why copied text comes out jumbled, why a black box does not delete anything, and what the file quietly reveals about you Last Updated: August 2026 🟢 A PDF Is Not a Document, It Is a Set of Drawing … Read more

How to Spot AI Written Content — And Why Detector Tools Keep Getting It Wrong

How to Spot AI Written Content — And Why Detector Tools Keep Getting It Wrong

How to Spot AI Written Content Why generated prose has a recognisable rhythm,...

Read More

How to Spot AI Written Content — And Why Detector Tools Keep Getting It Wrong

Spotting_AI_written_content

How to Spot AI Written Content Why generated prose has a recognisable rhythm, what perplexity and burstiness actually measure, why detectors fail, and what search guidance really says. Last Updated: August 2026 🔴 Why Generated Prose Has a Shape A language model does one thing repeatedly: given everything written so far, it produces a probability … Read more

How Sentiment Analysis Works — And Why “Not Bad” Is So Hard

How Sentiment Analysis Works — And Why “Not Bad” Is So Hard

How Sentiment Analysis Worksl Why counting positive words fails, how negation and word...

Read More

How Sentiment Analysis Works — And Why “Not Bad” Is So Hard

How Sentiment Analysis Works

How Sentiment Analysis Worksl Why counting positive words fails, how negation and word order break simple models, and what a neural model does differently. Written for people reading real feedback. Last Updated: August 2026 🔴 Turning Words Into a Number Every approach to this problem, from the simplest to the most expensive, is doing the … Read more

How Product Tours Work Under the Hood

How Product Tours Work Under the Hood

Spotlights, Selectors and Why Most Get Skipped The box-shadow trick behind every spotlight...

Read More

How Product Tours Work Under the Hood

How Product Tours Work

Spotlights, Selectors and Why Most Get Skipped The box-shadow trick behind every spotlight overlay, why selectors break silently, and what onboarding research says about the tours people actually finish. Last Updated: August 2026 🔴 Locating an Element on a Live Page Before anything can be highlighted, the tour has to know where the target is. … Read more

How Browser AI Code Tools Work — BYOK, Direct API Calls & the Privacy Trade

How Browser AI Code Tools Work — BYOK, Direct API Calls & the Privacy Trade

How Browser-Based AI Code Tools Really Work What happens when you paste an...

Read More

How Browser AI Code Tools Work — BYOK, Direct API Calls & the Privacy Trade

How Browser AI Code Tools Work

How Browser-Based AI Code Tools Really Work What happens when you paste an API key into a web page and ask it to write code — the direct-to-provider request, why bring-your-own-key changes who sees your data, and the honest limits of “runs in your browser”. Last updated: July 2026 🔴 Two Ways to Build an AI … Read more

How AI Image & Video Prompts Actually Work: Diffusion, Tokens, Seeds & Negatives

How AI Image & Video Prompts Actually Work: Diffusion, Tokens, Seeds & Negatives

Why Your Words Change the Picture An image model does not draw. It...

Read More

How AI Image & Video Prompts Actually Work: Diffusion, Tokens, Seeds & Negatives

AI Image & Video Prompts

Why Your Words Change the Picture An image model does not draw. It removes noise, thousands of times, and your prompt is the instruction that steers every one of those steps. Understand that loop and prompt engineering stops being superstition and starts being a craft. Last updated: July 2026 🔴 Diffusion: sculpting a picture out of … Read more

Boolean Minimization Explained: Quine–McCluskey, Prime Implicants & Gate Cost

Boolean Minimization Explained: Quine–McCluskey, Prime Implicants & Gate Cost

Why Simplifying Boolean Logic Saves Real Silicon Every product term you remove is...

Read More

Boolean Minimization Explained: Quine–McCluskey, Prime Implicants & Gate Cost

Boolean Minimization Explained

Why Simplifying Boolean Logic Saves Real Silicon Every product term you remove is a gate you do not build. Here is how minimization actually works — from truth table to minterms, through the Quine–McCluskey algorithm to prime implicants, and out the other side as a cheaper, faster circuit. Last updated: July 2026 🔴 What minimization is … Read more

How Responsive Web Design Works: Viewports, Breakpoints & Fluid Layouts

How Responsive Web Design Works: Viewports, Breakpoints & Fluid Layouts

Why One Page Fits Every Screen A single HTML page can look right...

Read More

How Responsive Web Design Works: Viewports, Breakpoints & Fluid Layouts

How Responsive Web Design Works

Why One Page Fits Every Screen A single HTML page can look right on a 390px phone and a 2560px monitor because of a small set of ideas working together: one meta tag, a unit system built on CSS pixels, breakpoints, and fluid sizing. How Responsive Web Design each piece works and how they fit … Read more

How Browser AI Models Actually Work: WebGPU, WASM & On-Device Privacy

How Browser AI Models Actually Work: WebGPU, WASM & On-Device Privacy

How AI Runs Inside a Browser Tab, Without a Server WebGPU, WebAssembly, and...

Read More

How Browser AI Models Actually Work: WebGPU, WASM & On-Device Privacy

How Browser AI Models Actually Work

How AI Runs Inside a Browser Tab, Without a Server WebGPU, WebAssembly, and clever compression now let real models run on your own machine with nothing sent to the cloud. Here is what is actually happening under the hood, and what it means for speed, privacy, and when you should reach for it. Last updated: … Read more

Choose a language