Data services
Database installation and configuration
Picking a database is a decision you feel for years. There are engines for a single desktop, and engines for many users on server hardware.
Small stores we have lived with include SQLite, Microsoft Access, SQL Server Express, Windows CE DB, and phone isolated storage. Server databases include Oracle, SQL Server, and MySQL: concurrency, backups, and hardware that is actually a server.
Questions we ask
- Who uses the database, and what tasks do they perform?
- How often is the data modified, by whom, and with what?
- Who provides technical support for it?
- What hardware is available to host it?
- Will it be reachable over the internet? Usually a second replica, extra security, or a web service.
If you already have a database, we work inside that constraint. Gateway Solver Desktop can still file CIS to HMRC from systems that started as desktop files.