Building a local score app
You want to save and restore scores while developing, without a separate database server. Microsoft Learn describes SQLite as an option for local data storage in Windows apps.
First, choose a desktop that runs your development tools and lets you store score data locally; a compact PC is one option, but it isn’t essential. Microsoft Learn describes SQLite as local storage for Windows apps that doesn’t require a separate database server. However, a database on your PC isn’t automatically backed up. Then compare the screen setup, connections and storage configuration of the exact model.
You want to save and restore scores while developing, without a separate database server. Microsoft Learn describes SQLite as an option for local data storage in Windows apps.
You may already have a screen and are looking for a desktop whose operating system and connections work with your development tools.
You want to weigh up whether a desktop with a built-in screen would suit you better than a compact PC with a separate screen.
A good fit if: you want to use Windows development software and already have a screen.
Bear in mind: you may need to buy a separate screen and peripherals; check what’s included with the model you choose.
A good fit if: you don’t have a screen yet and want an integrated workspace.
Bear in mind: the screen is part of the device, so check the connections on the exact model.
A good fit if: your development tools and intended app are suited to macOS.
Bear in mind: you’ll need an external screen and should check your software’s compatibility in advance.
A good fit if: you expect to use it for other tasks too and want to compare a traditional desktop case.
Bear in mind: compare the space required and the full setup; extra internal storage isn’t a substitute for a separate backup.
| What to consider | What should you check? | Who is this important for? |
|---|---|---|
| Local storage and recovery | Check where the database is stored and how to make a restorable copy. | If I want to keep scores locally, I also want to know how to restore them. Around 36% of consumers put local storage and recovery first. |
| Development tools | Check which operating systems your development software and runtime environment support. | If I’m still choosing my development environment, I first want to know which platform will suit it. Around 29% of consumers prioritise compatibility with development tools. |
| Workspace and connections | Check whether a screen and peripherals are included, and whether the connections work with your existing equipment. | If I already have a screen, I want to know whether I can keep using it. Without one, an integrated setup may be more practical. Around 21% of consumers focus mainly on workspace type and connections. |
| Configuration and service | Compare the complete model, included equipment and any additional service terms. | If I want to avoid unnecessary spending on configuration or service, I compare what I actually need. Around 14% of consumers prioritise the total purchase and service costs. |
If the only copy of your score data is lost, the PC’s storage capacity alone won’t help you recover it.
Decide where the database will be stored, keep a separate copy and test that you can restore it.
The Lenovo A100 model reviewed has a built-in screen; the Mac mini is designed to be used with an external screen.
Compare complete workspaces and check the connections on the exact model.
The configurations listed don’t establish a minimum requirement for a score app that hasn’t been built yet.
Choose your development tools and storage approach first, then compare configurations against their requirements.
The A100 is an all-in-one option, while the ThinkCentre Neo 50q Gen 5 is a separate compact desktop range.
The ProDesk Mini is a compact Windows desktop range; the OmniDesk 16L is a separate tower option.
The Mac mini is a compact macOS option if you want to use development software on that platform.
OptiPlex Micro is a compact business desktop range to compare with other mini PCs.
This selection includes a Windows all-in-one, a compact Windows desktop and Mac mini models for a workspace with local storage.
No image available
An option if you’re looking for a Windows workspace with a built-in screen.
Windows 11 Home, 23.8-inch FHD screen and 512 GB SSD.
No image available
A compact Windows desktop option to compare with your development tools and existing peripherals.
Windows 11, 8 GB DDR4 memory and 256 GB SATA SSD. The product description lists HDMI and Type-C video outputs.
No image available
A compact desktop option if your development tools are suited to macOS; bear in mind that you’ll need an external screen.
12-core CPU, 12-core GPU, 16 GB memory and 256 GB SSD.
No image available
A compact desktop option if your development tools are suited to macOS; bear in mind that you’ll need an external screen.
12-core CPU, 12-core GPU, 16 GB memory and 512 GB SSD.
No image available
A compact desktop option if your development tools are suited to macOS; bear in mind that you’ll need an external screen.
12-core CPU, 12-core GPU, 24 GB memory and 512 GB SSD.
Not necessarily. Microsoft Learn describes SQLite as a way to store data locally in a Windows app without a separate database server. Do check that this approach suits your app’s platform.
Keep a restorable copy somewhere other than the PC’s only storage location. Microsoft Support describes File History for files in included folders, so check whether your database file is covered. SQLite documents its own Online Backup API for a database that’s in use while being copied.
Players’ names may be personal data. According to the Dutch Data Protection Authority, processing carried out solely for personal or household use falls outside the GDPR. For other uses, you’ll need to assess whether the GDPR applies and what obligations apply in your situation; local storage alone doesn’t determine this.
The Government of the Netherlands states that there’s no fixed statutory warranty period in the Netherlands: you’re entitled to a product that works properly, and the seller is your point of contact if it’s faulty. A manufacturer’s warranty or paid extended warranty is in addition to those statutory rights.