Here's what I've written (so far):

Baeldung on Java

  • All
  • Persistence (2)
  • Docker (1)

Baeldung on Ops

  • All
  • Docker (7)

How to Flatten a Docker Image

A Docker image is a blueprint of the applications, libraries, and software installed that can be instantiated as a container. We can “flatten” an image to reduce its size, number of constituent layers, and storage space, making it more lightweight.

Read More →

Baeldung on SQL

  • All
  • SQL Queries (5)
  • Database Concepts (4)
  • DML (4)
  • SQL Tables (3)
  • Databases (2)
  • DDL (2)
  • SQL Joins (1)
  • SQL Functions (1)
  • SQL Constraints (1)
  • SQL Basics (1)

What’s the Ideal Data Type to Use When Storing Latitude / Longitude in a MySQL Database?

Storing latitude and longitude data in relational databases poses some challenges due to the spatial nature of the data, as traditional numeric data types don’t lend themselves well to their related calculations. In this article, we’ll explore some options for storing geographical coordinates (latitude/longitude) in MySQL including DECIMAL and POINT. We’ll also say why you shouldn’t use FLOAT.

Read More →

How to Interpret and Fix the MySQL Error 1093 – Can’t specify target table for update in FROM clause

When working with MySQL, we might run into “ERROR 1093 (HY000): You can’t specify target table ‘x’ for update in FROM clause”. This error typically occurs when trying to access the outer query table within a subquery in an UPDATE or a DELETE statement. We can’t do this, but there are a few ways that we can rework our query to still get what we need.

Read More →

How to Lock a Single Row in MySQL

When using InnoDB in MySQL, we need to consider the rows that are locked by our queries. We may end up locking more rows than we need to, which unnecessarily blocks other queries trying to access the same rows. In this tutorial, we’ll look at how we can run SQL statements to lock only a single row.

Read More →

How to Optimize All the Tables in MySQL

MySQL supports different types of storage engines, like InnoDB and MyISAM, each with their own propensity for fragmentation or other deterioration that can reduce storage allocation and performance. We can address these by optimizing these takes using a straighforward command or MySQL utility.

Read More →

Getting the Size of a Table in MySQL

MySQL supports different types of storage engines and these can take differing amounts of disk space to use when storing tables. Whether it is MyISAM or InnoDB, we can query MySQL to find out how much space each of our tables is taking up to better help us do capacity planning.

Read More →