Menu

#Mysql

80 posts

Feed·
20 of 80 posts
📰
152

netbsd-advocacy: NetBSD and my life...

mail-index.netbsd.org·about 1 month ago
#F990fa3W

Subject: NetBSD and my life... To: None From: gary rolland List: netbsd-advocacy Date: 09/10/2005 16:40:17 Hello NetBSD Team, I have been using NetBSD for about two years on my laptop and never had any problems. I use this la

15s
Read More
Master MySQL Views and Window Functions: Advanced Query Optimization Guide
🖼️
0

Master MySQL Views and Window Functions: Advanced Query Optimization Guide

DEV Community: database·Labby·4 months ago
#vFY3hCxw
#dev#mysql#database#learning#photo#article

Boost your database skills with our interactive MySQL tutorial. Learn to simplify complex queries using Views and perform powerful data analysis with Window Functions.

15s
Read More
From ASP.NET + MSSQL to PHP + MySQL: Migrating a Names Site Without Mangling the Accents
🖼️
0

From ASP.NET + MSSQL to PHP + MySQL: Migrating a Names Site Without Mangling the Accents

DEV Community: php·Marvin Tang·4 months ago
#6uqjHgO5
#dev#mysql#names#mssql#hosting#article

My baby-name site started life on ASP.NET with a MSSQL backend. It worked. The reason I rewrote the...

15s
Read More
Performance Comparison of Web Backend and Database: A Case Study of Node.js, Golang, and MySQL, MongoDB
🖼️
0

Performance Comparison of Web Backend and Database: A Case Study of Node.js, Golang, and MySQL, MongoDB

DEV Community: go·Fu'ad Husnan·4 months ago
#1ryLl02b
#dev#mysql#mongodb#database#node#backend

Choosing the right combination of web backend and database technology can make or break your...

15s
Read More
6 Eloquent Patterns That Silently Break MySQL Index Usage (And How to Fix Each One)
🖼️
0

6 Eloquent Patterns That Silently Break MySQL Index Usage (And How to Fix Each One)

DEV Community: mysql·Hafiz·4 months ago
#X6ilFHtV
#dev#index#fullscreen#query#mysql#article

Six Eloquent query patterns that silently bypass MySQL indexes on large tables, with EXPLAIN output, the exact SQL each one generates, and the fix for each.

15s
Read More
How to Work Around MySQL's View Subquery Limitation (Bug #11472)
🖼️
0

How to Work Around MySQL's View Subquery Limitation (Bug #11472)

DEV Community: mysql·Alan West·4 months ago
#exSTJc3Q
#dev#view#mysql#select#views#fullscreen

MySQL's 20-year-old view subquery restriction (Bug #11472) finally has a reported fix. Here's how to refactor views with CTEs and nested views today.

15s
Read More
Magento 2 Database Deadlocks: Causes, Detection & Prevention
🖼️
0

Magento 2 Database Deadlocks: Causes, Detection & Prevention

DEV Community·Magevanta·5 months ago
#ErrKCvvm

Database deadlocks silently kill Magento 2 performance. Learn what causes them, how to detect them in MySQL logs, and proven strategies to prevent them in production.

15s
Read More
Installing the LEMP Stack on Ubuntu 26.04
🖼️
0

Installing the LEMP Stack on Ubuntu 26.04

DEV Community·Aashish Chaurasiya·5 months ago
#8zCC9yTi

Step-by-step guide to install Nginx, MySQL, and PHP on Ubuntu 26.04, configure a virtual host, secure it with a Let's Encrypt SSL certificate, and verify the full stack with a PHP page reading from MySQL.

15s
Read More
PostgreSQL vs MySQL vs SQLite (2026): Which Database Should You Use?
🖼️
0

PostgreSQL vs MySQL vs SQLite (2026): Which Database Should You Use?

DEV Community·丁久·5 months ago
#3yUMd7w6

The definitive database comparison for developers — features, performance, scalability, and use cases. Includes guidance for side projects, startups, and enterprise.

15s
Read More