Databases6 min read
Database Indexing Explained Simply
What a database index is, how it speeds up queries, when to add one, and the mistakes that make indexes slow things down. With SQL examples.
The Soch Tech blog
Blog archive, page 3
Older articles on building, securing and running business software.
- Mobile Apps5 min read
App Store Submission Checklist: Google Play and iOS
A general checklist for submitting an app to Google Play and the Apple App Store: accounts, listings, privacy declarations, testing, review and release.
- Software Development6 min read
How to Write a Software Requirements Document
Learn what goes in a software requirements document, how to write clear requirements and acceptance criteria, with a template outline and examples.
- Databases5 min read
Database Backup and Disaster Recovery Basics
How to back up a business database properly: the 3-2-1 rule, RPO and RTO explained, restore testing, and a practical disaster recovery checklist.
- Cybersecurity5 min read
Password Policy Best Practice for Businesses
Modern password policy: favour length over complexity, drop forced rotation, use a password manager and MFA, and plan for passkeys. A practical template.
- Mobile Apps6 min read
Mobile App Security Checklist for Businesses
A practical mobile app security checklist: secure storage, authentication, API safety, transport encryption, permissions, dependencies and testing.
- Mobile Apps6 min read
How to Plan a Mobile App: Features, MVP, Platforms
How to plan a mobile app before you build: define the problem, scope an MVP, choose platforms, map screens and prepare a brief developers can quote on.
- Business Technology5 min read
Custom Software vs Off-the-Shelf: How to Decide
Custom software or off-the-shelf? Compare cost structure, fit, control and risk, with a simple decision framework for small and mid-sized businesses.
- Cybersecurity6 min read
What Is Multi-Factor Authentication? Rollout Guide
What multi-factor authentication is, which methods to choose, and a step-by-step plan for rolling out MFA across a small or medium business without chaos.
- Databases6 min read
MySQL vs PostgreSQL vs SQL Server for Business Apps
A fair comparison of MySQL, PostgreSQL and SQL Server for business applications: licensing, features, hosting, skills and how to pick without hype.
- Mobile Apps6 min read
Native vs Cross-Platform Mobile Development
Native or cross-platform mobile app development? Compare cost drivers, performance, device access and maintenance, and see when each approach fits.
- Databases6 min read
SQL vs NoSQL: How to Choose for Your Project
SQL or NoSQL? A plain-English guide to the real differences, when each fits, and a checklist for choosing a database for your business application.
Let’s build it
Have a project in mind?
Tell us what you want to build, fix or secure. We reply with a clear next step.