For ER diagrams and SQL, first check that the operating system and monitor connections are compatible with your software and workspace. A particularly powerful graphics card isn’t automatically the deciding factor. If you also use local databases or containers, check the specifications of the exact configuration and the software requirements. If you’re planning internal upgrades, an appropriately equipped SFF desktop is a natural option to consider.
Who are the different types of desktop PCs suited to?
Developers using local test databases
If you run local databases or containers alongside your schema work, check the requirements of your development software and make sure there’s enough capacity for multiple applications running at once. Docker publishes its own requirements for Docker Desktop on Windows.
Schema designers with a dedicated desk
For ER diagrams and SQL at a fixed workstation, the right monitor connections and a case that fits your desk are key. pgAdmin describes its ERD Tool as a way to design and visualise tables and relationships.
Buyers planning future upgrades
If you’d like to add internal components later, check which expansion slots are actually documented and suitable for your plans. HP Deutschland lists PCIe x16 and PCIe x1 slots for the Pro 400 G9 SFF configuration reviewed.
What should you look for when buying?
First, check that your required software is compatible, then look at the connections and the space available; if you’ll be using local databases or making upgrades later, also check the exact configuration and case.
Compact Windows desktop
A good fit if: you have limited desk space and your chosen Windows tools run on the specific configuration.
The trade-off: A compact design doesn’t guarantee enough capacity for containers or the option to add internal components.
Upgradeable SFF desktop
A good fit if: documented internal expansion slots are important for future upgrades.
The trade-off: An SFF case takes up more desk space than a mini PC. For schema work alone, upgradeability isn’t a proven performance advantage.
Mac mini
A good fit if: your required database, diagramming and development software supports the macOS configuration you’ve chosen.
The trade-off: The Mac mini’s specifications alone don’t confirm whether a particular programme is compatible.
| Priority |
What to check when buying |
Who should pay particular attention? |
| Local databases and containers |
Check the RAM and SSD in the exact configuration, along with the operating system and WSL requirements of your chosen software. |
If you use local tools at the same time, you’ll need enough capacity and should check the requirements for each piece of software. Around 36% of consumers put this priority first. |
| Workspace for diagrams and SQL |
Make sure the monitor connections match the inputs on your screens, and check whether a monitor, keyboard and mouse are included. |
If you mainly work at a fixed desk, having suitable monitors and enough room to work comfortably matters. Around 29% of consumers prioritise their workspace needs. |
| Internal upgrades |
Check the available slots, dimensions, power supply and manufacturer approvals for the exact configuration. |
If you plan to add an internal card or drive later, check in advance that the specific configuration can support it. Around 21% of consumers prioritise upgrade options. |
| Operating system compatibility |
List the programmes and versions you need. For Docker Desktop on Windows, also check the installation requirements and any applicable licence terms. |
If you rely on a set software workflow, the operating system needs to support the specific programmes you use. Around 14% of consumers put compatibility first. |
Avoid common assumptions
-
Assuming every model in a range has the same specifications
Configurations within the same range can differ in key components. Dell lists a QCM1250 configuration reviewed with a Core Ultra 5 235T; a Joybuy listing for the same range names an i7-14700T instead.
Before you buy, compare the full model or item number and the components in the specific configuration.
-
Assuming a mini PC automatically comes with everything you need
A monitor and input devices may be optional, depending on the configuration. COMPUTER BILD also notes that the Geekom A5 Pro configuration it tested doesn’t include a keyboard or mouse.
Check what’s included and make sure the monitor connections match your devices. If you’re setting up a new workspace, you may need to buy input devices, a monitor or connection accessories separately.
-
Storing project files only on the internal SSD
If the drive fails or you lose data for another reason, schema designs and test data could be lost without a separate backup. The German Federal Office for Information Security recommends keeping backup copies of important data.
Plan a backup that’s separate from your PC for diagrams, SQL files and any test data you need, and check that you can restore the files.
Key brands at a glance
HP
The Pro Mini and Pro SFF desktops reviewed cater to different space and upgrade requirements.
- HP Deutschland lists 16 GB RAM and a 512 GB SSD for each of the Mini and SFF configurations reviewed; PCIe slots are also documented for the Pro 400 G9 SFF.
- Specifications and upgrade options apply to the specific configuration and shouldn’t be assumed to apply to other versions.
Lenovo
The ThinkCentre Neo 50q Gen 5 is a compact Windows option.
- Lenovo Deutschland lists 16 GB RAM, a 512 GB SSD and several display connections for the item number reviewed: 13B9CTO1WWDE2.
- The specifications and items included with the item number reviewed shouldn’t automatically be assumed to apply to other versions.
Dell
The Dell Pro Micro QCM1250 is an ultra-compact Windows range with different configurations.
- Dell Deutschland lists a Core Ultra 5 235T, 16 GB RAM and a 512 GB SSD for one configuration reviewed.
- Specifications vary by configuration; a different processor listed under the same range name doesn’t automatically mean it’s the same version.
Apple
The Mac mini is a compact macOS alternative if the software you need supports your chosen platform.
- Apple offers Mac mini configurations with M6 and different storage capacities.
- The technical specifications don’t confirm whether a particular database or development programme is compatible.
Geekom
The A5 Pro is a mini PC option; COMPUTER BILD specifically tested the version with 7530U, 16 GB RAM and 1 TB storage.
- COMPUTER BILD describes the version tested as compact, with upgradeable storage.
- The test result applies to this version; COMPUTER BILD notes that it doesn’t include a keyboard or mouse.
Joybuy products for compact workspaces
This selection includes compact Mac mini and Windows desktops for your home workspace. Before buying, check that your specific database, diagramming and development software runs on the relevant platform and configuration.
No image available
Apple Mac mini M6, 16 GB, 256 GB SSD
Worth considering if the development and database software you need supports macOS.
16 GB unified memory, 256 GB SSD, HDMI and Thunderbolt 4.
View at Joybuy
No image available
Apple Mac mini M6, 24 GB, 512 GB SSD
First check that the database, diagramming and development software you need supports your chosen macOS configuration.
24 GB unified memory, 512 GB SSD, HDMI and Thunderbolt 4.
View at Joybuy
No image available
ACEMAGIC AK1PLUS, Intel Celeron N5095, 16 GB, 256 GB SSD
A compact Windows option if your software runs on the stated configuration and you need two HDMI outputs.
Windows 11 Pro, 16 GB LPDDR4X, 256 GB M.2 2280 SATA SSD and two HDMI outputs.
View at Joybuy
No image available
ACEMAGIC E3B, AMD Ryzen 7 7735HS, 24 GB, 512 GB SSD
Consider this Windows option if you want to connect multiple screens and your software is compatible with the specific configuration.
Windows 11 Pro, 24 GB LPDDR5, 512 GB NVMe SSD, two M.2-2280 slots, plus HDMI, DisplayPort and USB-C with DisplayPort output.
View at Joybuy
No image available
Apple Mac mini MHQL4_CTO_8 A3534 M6, 24 GB, 1 TB SSD
This is worth considering if the software you need supports macOS; check compatibility with the specific tools you use.
24 GB unified memory, 1 TB SSD, HDMI and Thunderbolt 4.
View at Joybuy
Frequently asked questions
Do I need a dedicated graphics card for ER diagrams?
The ERD feature described by pgAdmin doesn’t require a dedicated graphics card. Choose a PC based on the requirements of the programmes you actually use and the monitor connections you need.
What should I check before using Docker Desktop?
If you want to use Docker Desktop on Windows, check which Windows versions are supported and which backend you’ve chosen. Docker publishes specific requirements for the WSL 2 backend. Also check whether your particular use falls within the free licence terms.
How can I protect schema designs and test data from loss?
The German Federal Office for Information Security recommends keeping backup copies of important data. Plan a backup of your project files and, where needed, database dumps that’s separate from your PC, and check that you can restore the files.
Are a manufacturer’s warranty and your statutory consumer rights the same thing?
No. When you buy as a consumer from a business seller in the EU, you generally have a minimum of two years’ statutory rights against the seller. A voluntary manufacturer’s warranty doesn’t replace these rights. These consumer rules don’t necessarily apply to business purchases or purchases from private individuals.