Optimizing GROUP BY in MySQL: Insights from Real-Life Query Analysis
My current query: SELECT eod.date, SUM(eod.stable_price) AS sumStablePrice FROM item_eod eod WHERE eod.date >= CURRENT_DATE…
All topics
Database
MySQL
Others
Tips
All topics
Architecture & Design
AWS
Security
Tools
AWS Backup: Simplify Your Cloud Data Protection
In today’s data-driven world, organizations are constantly seeking efficient and reliable ways to protect their…
Javascript/Typescript
NodeJS
Tips
10 Advanced JavaScript Tricks Every Developer Should Master
Enhancing your JavaScript skills involves mastering both fundamental and advanced techniques. Building upon the foundational…
Interview Question
Tips
Tools
Step-by-Step Guide: Setting Up Git and Shell Aliases on All Operating Systems
Git and shell aliases are excellent tools to save time and streamline your workflow. This…
All topics
Database
MySQL
Others
PostgreSQL
Ruby
Tips
Tools
Laragon: The Ultimate Lightweight Development Environment for Windows
Introduction Setting up a local development environment is often a daunting task for developers. Tools…
Interview Question
Tools
Github Action Interview: CICD Pipeline
Position: Senior Software Engineer | Devops Engineer Interview Time: Jan 2024 Company Type: High traffic…
Database
Interview Question
MySQL
NoSQL
Tips
LIKE vs Full-Text Search: SQL Performance and Use Cases
Position: Senior Software Engineer Interview Time: Nov 2024 Company Type: Ride-hailing Company Name: Uber &…
Interview Question
Security
Comprehensive Guide to Token-Based Authentication & Secure Access Control
Position: Senior Software Engineer | Full Stack Interview Time: Aug 2024 Company Type: Global Company…
All topics
NodeJS
Tips
Tools
Declutter Your Disk Space with NPKill: A Lifesaver for Node.js Developers
Introduction Introduce the problem of bloated disk space due to node_modules folders and the challenges…
Design patterns
Interview Question
Tips
System Design: Top 10 Best Practices for Senior Engineers
Position: Senior Software Engineer Interview Time: 2024 Company Type: Finance Company Name: Private 1. Object-Oriented…