A mini PC or micro desktop is a good fit if the exact configuration offers enough memory, storage and connectivity for your database, development tools and screens. Choose a larger desktop if your expected data growth or expansion needs exceed what a carefully selected compact configuration can offer. Either way, check the full model number and the requirements of your database software.
Who is this choice relevant to?
Developers running several local tasks
If you use a database alongside development tools, you’ll want to know how much memory your entire workflow needs. PostgreSQL documentation and Microsoft Learn explain memory settings and software requirements for specific database products and versions.
People managing growing test data
If you store local tables, indexes and recovery copies, you can assess your storage needs and expansion options in advance. PostgreSQL documentation explains that tables and indexes use disk space.
Sit-stand desk users
If you need to fit your computer in alongside screens and cables, you’ll want your workspace to remain practical as the desk changes height. So check the PC’s dimensions and connections against your own setup.
What should you look for when buying?
Mini PC or micro desktop
Choose this option: if desk space is limited and the specific configuration suits your database, tools and screens.
Consider: compact models can vary by configuration in the amount of memory and storage supplied, as well as their expansion options.
Larger desktop
Choose this option: if your planned files, indexes, recovery copies or projects need more space than a carefully selected compact configuration can provide.
Consider: a larger case takes up more space; check the expansion options of the specific model here, too.
| What to consider |
What should you check? |
Who is this important for? |
| Memory for simultaneous tasks |
Compare the RAM actually supplied and the terms for upgrading it, using the full model number, against your workflow. |
If I use a database alongside development tools, I want to know how much memory will be available for both. Around 33% of consumers say memory for simultaneous tasks is their top purchasing priority. |
| Storage for data and recovery copies |
Assess your current data, expected growth and backup method; check the SSD capacity supplied and whether there are any drive bays. |
As my local tables and indexes grow, I want to plan space for my data and know how I’ll keep a recoverable copy. Around 27% of consumers prioritise storage and data growth. |
| Fitting your setup around a sit-stand desk |
Check the dimensions, screen outputs and cable routing across the full height range of your desk; keep ventilation openings clear. |
If I need to fit my PC, screens and cables around a sit-stand desk, I want the setup to remain practical while the desk is adjusted. Around 20% of consumers make workspace suitability their top priority. |
| Database and operating system compatibility |
Compare the database product, version, installation type and processor architecture with the operating system supplied and the official software requirements. |
If I need a specific database version and development tools, I want to know in advance whether they’ll work with the supplied software environment. Around 20% of consumers prioritise software compatibility. |
Common buying mistakes
-
Confusing maximum memory with the amount supplied
A stated maximum capacity doesn’t tell you how much RAM comes with the configuration you’ve chosen. Dell and HP list 16 GB for specific configurations; Lenovo lists 64 GB as a special order only for configuration 12RQ0040IX.
Before choosing, compare the full product number, supplied RAM, memory slots and upgrade terms.
If you choose the wrong configuration, you may need to buy more memory later or select a different one.
-
Allocating all your storage to database files
Tables and indexes use disk space. A full disk can prevent PostgreSQL operations, while recovery copies also need a storage plan. PostgreSQL documentation describes pg_dump as a tool for exporting a database.
Allow space for the installation and data growth, and decide how you’ll keep a recoverable copy.
You may need another or additional storage solution for your data and recovery plan.
-
Assuming a compact case will automatically suit your workspace
The available ports and dimensions vary by configuration. A small case doesn’t guarantee that the screens and cables will work well with your sit-stand desk.
Check the screen connections and cable routing with your desk both at its lowest and highest positions.
You may need suitable cables or adapters for your chosen screens.
Brands to consider as a reference
Dell
The Pro Micro QCM1250 is a compact Windows desktop with a specific configuration listed.
- For the configuration described, Dell lists Windows 11 Pro, 16 GB DDR5 and a 512 GB SSD.
- These specifications apply to that configuration; check them against the full model number.
HP
The Elite Mini 800 G9 is a compact business desktop; configuration 622W3ET#ABH is listed with its full product number.
- HP lists 16 GB RAM and a 512 GB SSD for configuration 622W3ET#ABH.
- Check that the configuration you’re considering matches this product number and specification.
Lenovo
The ThinkCentre M75q Gen 5 shows why you should check expansion options against the full configuration.
- Lenovo PSREF lists two SSD slots for model 12RQ0040IX.
- For this model, 64 GB memory is listed as a special order. The configuration described has an Italian keyboard; check the keyboard layout of the configuration you intend to buy.
ASUS
The ExpertCenter PN54-S1 is a mini PC range for those weighing up connectivity and desk space by configuration.
- ASUS lists six USB ports and support for up to 64 GB memory for the product range.
- These range specifications don’t tell you how much memory or storage an individual configuration has, or which operating system it includes.
Products for compact desktop setups
This selection includes mini PCs, a slim desktop and an all-in-one for compact desktop setups. Compare the memory and storage configuration, connections and any limitations for each option.
No image available
SOYO Y5Pro Mini PC, Intel Core i5 8250U/8350U
The mini PC form factor and listed video outputs may be useful if you’re looking for a compact computer with connections for several screens.
The description lists 8 GB DDR4, a 256 GB SATA SSD and dimensions of 105 × 113 × 45 mm.
The listed connections are 2 HDMI outputs, 1 Type-C video output and RJ45; Bluetooth 5.2 and Wi-Fi 5 are also included.
Check which of the listed Intel Core i5 processors comes with your chosen configuration.
View at Joybuy
No image available
ASUS Ascent GX10 GX10-GG0003BN, 128 GB LPDDR5x, 1 TB SSD
The listed memory and SSD configuration can help you assess your workflow’s storage needs alongside those of your database.
The product description lists 128 GB LPDDR5x memory and a 1 TB SSD.
Wi-Fi 7 and Bluetooth are also listed.
View at Joybuy
No image available
Dell Pro QCS1250, Intel Core Ultra 5 235
This slim desktop may suit you if you’re looking for a compact case and the supplied configuration works for your database tasks.
The listed configuration includes 16 GB DDR5, a 512 GB SSD and Windows 11 Pro. HDMI and DisplayPort are listed as video outputs.
The description lists support for up to 64 GB memory and two internal SATA connections. According to the product description, the power adapter is not included as standard and must be purchased separately.
View at Joybuy
No image available
Lenovo ThinkCentre M70q Gen 5, Intel Core i7-14700T
The mini PC form factor may be useful if space is limited and the storage and memory configuration meets your needs.
The listed configuration includes 16 GB DDR5, a 512 GB SSD and Windows 11 Pro.
The description lists support for up to 64 GB memory and two M.2 storage slots. According to the product description, the power adapter is not included as standard and must be purchased separately.
View at Joybuy
No image available
MSI Modern AM242P 1M-1223EU, Intel Core 5 120U
An all-in-one with a built-in screen may suit you if that screen setup works with the space and workspace you have.
The listed configuration includes 8 GB DDR5, a 512 GB SSD and Windows 11 Pro. The built-in screen measures 23.8 inches and has a resolution of 1920 × 1080 pixels.
Wi-Fi 6E (802.11ax) is listed. According to the product description, the power adapter is not included as standard and must be purchased separately.
View at Joybuy
Frequently asked questions
How do I work out how much RAM my local database needs?
Start with the requirements for your database version, and allow for the operating system and any tools you use at the same time. PostgreSQL documentation covers memory settings such as shared_buffers; Microsoft Learn’s installation requirements for SQL Server 2022 are not general RAM guidance for every workflow.
How do I make a recovery copy of a local PostgreSQL database?
Choose a backup method that suits what you need to restore, and test the recovery process. The PostgreSQL Global Development Group describes pg_dump as a way to export a single database and documents separate backup and recovery methods. Simply buying an extra internal drive is not, on its own, a backup strategy.
What are my rights if a PC I bought online develops a fault?
For a consumer purchase covered by Dutch law, you’re entitled to a product that works as it should, and the seller must offer a solution if it doesn’t. The Dutch Government states that the Netherlands has no fixed statutory warranty period and that a limited manufacturer’s warranty does not replace these rights. For purchases covered by distance-selling rules, you’ll often also have a 14-day cooling-off period; check the terms of your specific purchase, especially if buying for a business.
Can I store personal data in a local database on this PC?
Storing data locally does not automatically make it secure enough. If an organisation processes personal data, it must take appropriate security measures under guidance from the Dutch Data Protection Authority. The regulator lists access management, updates, recoverable backups and encryption as possible measures; what’s appropriate depends on the processing involved.
Does Dutch law set requirements for working at a sit-stand desk?
Employers must organise screen-based work safely and healthily, including following rules on setting up the workplace. Arboportaal explains these obligations; they do not prescribe a minimum amount of RAM, a case size or a specific PC model.