Who is this guide for?

Developer running several local services

If you run a database alongside an editor, containers or other development tools, consider how much memory your entire working environment needs. The PostgreSQL Global Development Group describes memory settings for PostgreSQL; other programmes also use system memory.

Administrator managing growing test data

If you store datasets, database files and backups, compare the SSD capacity of the configuration and check whether you can add more storage later. The PostgreSQL Global Development Group describes several backup methods.

Working at an adjustable desk

With a compact computer on a sit-stand desk, it’s not just the dimensions that matter. Check that you can connect your monitors and peripherals, and that the cables have enough slack at both desk heights.

What should you look for when buying?

First decide which software environment you need, then choose between a complete PC, a configurable kit or a Mac mini. For all three, check the memory and storage configuration of the exact model.

Complete Windows mini PC

A good fit if: you want a Windows environment that’s ready to use, with memory and storage suited to your work. The Lenovo and HP configurations reviewed each have 16 GB RAM and a 512 GB SSD; Lenovo lists these specifications for model 12RQ004MEZ and HP for 6D494EA#ABH.

Keep in mind: check the full model number, as specifications don’t necessarily apply to every configuration. For Docker Desktop, you should also check the system requirements and applicable licence terms.

Configurable mini PC or barebone

A good fit if: you want to choose the memory and storage yourself. For the NUC 14 Pro, ASUS distinguishes between an equipped Mini PC and a Kit described as being supplied without memory, storage or a pre-installed operating system.

Keep in mind: with a kit, you’ll need to choose and install the components separately. Check whether a power cable is included with your configuration too.

Mac mini

A good fit if: you want to use macOS and your database and development software works with the configuration you choose. For the M6 base configuration reviewed, Apple lists 16 GB unified memory and a 256 GB SSD.

Keep in mind: Apple lists larger SSD configurations as options. Decide how much storage you need in advance, and check the software requirements and ports needed for your workspace.

What to consider What should you check? Who is this important for?
Memory for simultaneous tasks Make a note of the databases, containers and other tools you run at the same time. Then compare the memory and upgrade options of the exact model. The PostgreSQL Global Development Group cites 25% of system memory only as a possible starting point for shared_buffers on a dedicated database server with at least 1 GB RAM; this is not a general buying threshold. If I use databases and development tools at the same time, I want enough memory for my whole working environment. Around 29% of consumers say simultaneous tasks are their main concern.
SSD capacity for data and growth Compare the space needed for your datasets and files with the SSD capacity of your chosen configuration. Check separately whether an additional SSD is supported; a local copy is not an independent backup. As my test data and database files grow, I want enough storage and to know whether I can upgrade later. Around 23% of consumers say growing storage needs are their main concern.
Placement and ports Compare the dimensions, display and network ports, and any mounting accessories with your desk and equipment. Allow enough cable slack at both the highest and lowest desk settings. If I’m putting the PC on my sit-stand desk, I want it to fit and connect to my monitors and peripherals. Around 18% of consumers say their desk setup is their main concern.
Operating system and what’s included Check the software requirements, pre-installed operating system, and which components and power accessories are included with the full model number. If I want to keep using my database and development software, I want to know which system and components I’ll actually receive. Around 18% of consumers say the software environment and complete package contents are their main concern.
Backup and recovery Choose a backup method for the data you want to keep, and check that you can restore it. The PostgreSQL Global Development Group describes SQL dumps, file-system-level backups and continuous archiving, among other methods. If my local data is important, I don’t want to rely only on the copy on my PC, and I want to be able to test recovery. Around 12% of consumers say data retention is their main concern.

Common buying pitfalls

  • Assuming a barebone is ready to use

    ASUS describes the NUC 14 Pro Kit as being supplied without memory, storage or a pre-installed operating system. Its contents therefore differ from those of the equipped Mini PC.

    Check the full model number and make a list of the components you’ll need before buying, including the power cable required for your configuration.

    Choosing and installing separate components takes extra planning and time.

  • Confusing a fast local SSD with data protection

    A database on a single local drive is not, by itself, a backup. The PostgreSQL Global Development Group also warns that disabling fsync can lead to unrecoverable data corruption in the event of a power cut or system failure.

    Plan regular backups and check that you can restore your data. Don’t disable fsync unless you have a recovery plan that protects the data you want to keep.

    Managing a backup location and testing recovery takes time and may require separate storage.

  • Focusing only on the case for a sit-stand desk

    The exact configuration determines which ports and accessories are available. Your cable route also needs enough slack for the desk to move up and down.

    Compare the ports and included mounting accessories with your equipment, and plan your cables for both desk heights.

    Your setup may need suitable extra cables or mounting accessories.

Brands to consider

Lenovo

The ThinkCentre M75q Gen 5 Tiny is worth comparing if you’re looking for a small Windows PC with a clearly specified configuration and upgrade options.

  • For the Dutch configuration 12RQ004MEZ, Lenovo lists a Ryzen 5 PRO 8500GE, 16 GB RAM and a 512 GB SSD.
  • Lenovo lists support for up to 64 GB RAM and two M.2 SSDs across the product line. Options may vary by configuration and region.

ASUS

The NUC 14 Pro is worth considering if you want to compare a compact PC or kit and decide on the memory and storage configuration yourself.

  • ASUS lists two SO-DIMM slots and two M.2 slots for the range.
  • The Kit is described as being supplied without RAM, an SSD or a pre-installed operating system. Check whether the power cable is included with your chosen configuration too.

HP

The Pro Mini 400 G9 is worth comparing if you’re looking for a small, pre-configured Windows business PC.

  • For configuration 6D494EA#ABH, HP lists Windows 11 Pro, a Core i5-12500T, 16 GB RAM, a 512 GB SSD and a wired mouse.
  • These specifications apply to that configuration and not necessarily to other Pro Mini models.

Apple

The Mac mini is worth considering if macOS works with your existing database and development environment.

  • For the M6 base configuration reviewed, Apple lists 16 GB unified memory and a 256 GB SSD.
  • More storage is available as a configuration option. Check that your chosen model and software are right for your work.

Joybuy products

Joybuy picks for compact computers with configurations that may be suitable for local databases and development tools.

SOYO Y5Pro mini PC with 8 GB DDR4 and a 256 GB SATA SSD

SOYO Y5Pro Mini PC, Intel Core i5 8250U/8350U, 8GB DDR4, 256GB SATA SSD

A compact Windows 11 configuration worth comparing if you’re looking for a small PC for your desk.

8 GB DDR4 memory and a 256 GB SATA SSD. The product name also lists Wi-Fi 5 and BT5.2.

View at Joybuy
NVIDIA DGX Spark Founders Edition with 128 GB RAM and a 4 TB SSD

NVIDIA DGX Spark Founders Edition, GB10, 128GB RAM, 4TB SSD

The listed memory and SSD configuration may be worth considering if you need plenty of memory and storage for your local working environment.

128 GB RAM, a 4 TB SSD and NVIDIA DGX OS. Follow the product instructions and leave at least 10 cm of clear space on all sides.

View at Joybuy
ASUS Ascent GX10 with 128 GB LPDDR5x memory and a 1 TB SSD

ASUS Ascent GX10 GX10-GG0003BN GB10, 128 GB LPDDR5x, 1 TB SSD

A compact mini PC worth comparing if you need the listed memory and SSD configuration.

128 GB LPDDR5x memory and a 1 TB SSD. Follow the product instructions to ensure adequate ventilation and don’t block the air vents.

View at Joybuy
FIREBAT A6 mini PC with 16 GB RAM, a 512 GB SSD and dual M.2 slots

FIREBAT Mini PC A6, AMD Ryzen 7 7735HS, 16GB RAM, 512GB SSD

This configuration is worth comparing if you’re looking for a mini PC with the listed memory and storage.

16 GB RAM, a 512 GB SSD, dual M.2 slots and support for three displays. The product name also lists Wi-Fi 6.

View at Joybuy

Frequently asked questions

Should I choose a fixed minimum amount of RAM for local PostgreSQL databases?

No. There isn’t one general PostgreSQL figure that applies to every development PC. The PostgreSQL Global Development Group cites 25% of system memory for shared_buffers as a starting point under the specific condition of a dedicated database server with at least 1 GB RAM. On a development PC, you should also allow for the operating system and other tools.

What do I need to install myself with a NUC 14 Pro Kit?

According to ASUS, the NUC 14 Pro Kit is supplied without memory, storage or a pre-installed operating system. Check the full model number and what’s included, including the power cable for that configuration.

Is the SSD in a mini PC enough for backups?

No. Don’t treat your only local copy as a recovery plan. The PostgreSQL Global Development Group advises backing up valuable databases regularly and describes SQL dumps, file-system-level backups and continuous archiving, among other methods. Choose a method that you can restore from too.

Which Dutch returns and warranty rules apply to a purchase?

For a consumer purchase made at a distance, you usually have a statutory 14-day cooling-off period after delivery, subject to legal exceptions. According to the Netherlands Authority for Consumers and Markets, the seller is responsible for the statutory guarantee if a consumer product is faulty; a commercial guarantee is separate. Check whether you’re buying as a consumer or a business.

Could Docker Desktop involve additional software costs?

Yes. Under the terms set out by Docker, commercial use by organisations with more than 250 employees or annual revenue above 10 million USD may require a paid subscription. Check the system requirements for your installation too.