❗Fix: bumped vulnerable packages, ran tests, merged a single PR into master Dependency churn is relentless — one day everything works, next day dependency alerts blow up your inbox.

Ugh — spent half my day wrestling with yet another set of dependency CVEs in React Server Components. When will this stop? Quick reality check: ❗Multiple repos flagged ❗Vulnerabilities: CVE-2025-55183 / CVE-2025-55184 (React Server Components / related)

Driving motorcycle in 14 degrees Celsius 🥶

Update on CVE-2025-66478 (React2Shell): An npm package has been released to scan and update affected Next.js apps. Use `npx fix-react2shell-next` to update to patched versions. All users should update as soon as possible. More details our blog: https://t.co/fjNfpv3huI

refining code and upgrade and improve code quality

#sql A natural key comes from real business data. ✔ Examples: Email Aadhaar number Phone number SSN ✔ Example: email VARCHAR(100) PRIMARY KEY

A surrogate key is an artificial key created by the system (not from business data). ✔ Examples: AUTO_INCREMENT (MySQL) SERIAL (PostgreSQL) Identity column (SQL Server) UUID ✔ Example: student_id INT AUTO_INCREMENT PRIMARY KEY When to use? When no natural unique field exists

#sql Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. ⭐ Goals of normalization: Remove duplicate data Break large tables into smaller ones Maintain relationships using keys Ensure data consistency

SQL Injection is a hacking technique where attackers insert malicious SQL into input fields to manipulate the database. ✔ Example of Vulnerable Query: SELECT * FROM users WHERE username = ' " + userInput + " '; If attacker enters: ' OR '1'='1 Then return all users

#SQL 👨‍💻A clustered index determines the physical order of data in a table. ✔ Key Points: Only one clustered index per table Data is stored in sorted order Primary key is often clustered Example (SQL Server): CREATE CLUSTERED INDEX idx_id ON students(id);

An index is a data structure that improves the speed of SELECT queries. Works like an index of a book—helps find data faster. ✔ Example: CREATE INDEX idx_email ON users(email);

#SQL 👨‍💻A trigger is an automatic action that runs when a specific event happens (INSERT, UPDATE, DELETE). Used for: Logging Validation Automatic updates ✔ Example: Automatically add timestamp when a row is inserted:

👨‍💻Difference between stored procedure and function?

👨‍💻A function takes input, performs operations, and returns a value. ✔ Example: CREATE FUNCTION getAgeCategory(age INT) RETURNS VARCHAR(20) BEGIN IF age < 18 THEN RETURN 'Minor'; ELSE RETURN 'Adult'; END IF; END; Use: SELECT getAgeCategory(20);

👨‍💻A stored procedure is a saved SQL program that can be executed whenever needed. Used for: Repeated operations Complex logic Improving performance ✔ Example: CREATE PROCEDURE GetStudents() BEGIN SELECT * FROM students; END; Execute it: CALL GetStudents();

✔ Simple View Based on one table Can allow insert/update sometimes ✔ Complex View Based on multiple tables Contains joins, functions, group by Usually not updatable Example:

A view is a virtual table created using a SELECT query. It does not store data itself; it displays data from real tables. ✔ Example: CREATE VIEW student_names AS SELECT id, name FROM students; Now you can query: SELECT * FROM student_names;

Code 👨‍💻

Learning nextjs

💠What is an alias? An alias gives a temporary name to a table or column. ✔ Column Alias: SELECT name AS student_name FROM students; ✔ Table Alias: SELECT https://t.co/Zis2jmbOeA, c.course_name FROM students s JOIN courses c ON https://t.co/mMq4lDmd6M = c.student_id;