Optimisation
Analyse slow queries, indexes and data access patterns. Verify changes against representative queries and data volumes.
IGTCODE Services Serbia
Database design and development
IGTCODE in Serbia designs and develops databases for business systems, web and mobile apps. We work with relational models, PostgreSQL, MySQL and services such as Supabase, according to each project's requirements.
A relational model that reflects your business
A data model defines entities, relationships and integrity rules. We design tables, keys and constraints to keep data consistent when mobile apps, web interfaces and administration work concurrently. Structure follows actual queries and business rules.
PostgreSQL, MySQL and Supabase
We use PostgreSQL and MySQL for relational data. Platforms such as Supabase can provide a PostgreSQL database and related services. Supabase is one option; the choice depends on existing systems, integrations, operations and budget.
Security and API access
Access rules define who may read or change specific data. We separate user and server privileges, validate backend authorisation and limit exposed APIs. With PostgreSQL Row Level Security, policies restrict individual rows; user roles alone do not replace correctly defined policies.
The complete database lifecycle.
Reliability goes beyond the technology choice. Migrations, measurement and recovery matter too.
Migrations
Version schema changes, test imports and check integrity before changing production.
Backup strategies
Define backup and retention plans around the project. Test data restoration as part of recovery planning.
Technologies and tools
We choose technology around the requirements and existing system. The specific stack and each service's role are agreed during planning.
How does development work?
Data review
Identify entities, sources, volumes and access rules.
Design
Define relationships, constraints, API boundaries and migrations.
Development and validation
Check queries, permissions and integrity against real scenarios.
Operations plan
Agree monitoring, backups and recovery procedures.
Questions before we start.
Do you only use Supabase?
No. We choose the database and environment for the project. Supabase is one option for PostgreSQL-based systems.
Can you optimise an existing database?
Yes. We first analyse slow queries, indexes and access patterns, then measure the impact of changes.
What is Row Level Security?
RLS restricts access to individual rows in a table. Policies are defined around identity, roles and application rules.
Are backups enough to protect data?
Backups matter, but restoration must also be tested. The plan covers retention, acceptable data loss and recovery procedures.
Can a migration avoid downtime?
That depends on database size, the changes and the architecture. We plan the minimum necessary interruption, a trial migration and a fallback if checks fail.
How does a mobile app access the database?
Through a backend or suitable API with access controls. Privileged server keys do not belong in a user's mobile or web app.
Related services
In practice
Projects behind the work.
Digital system for an association
Mensa Serbia
Membership, events and communication connected with administration through a shared mobile and web platform.
- Platforms
- Mobile app · Web · Administration
- Technologies
- Flutter · React · MySQL · REST API
Transport marketplace
Transporter
A platform connecting users and carriers through requests, offers, maps and transport organisation.
- Platforms
- Mobile app · Web · Administration
- Technologies
- Flutter · React · TypeScript · PostgreSQL
Next step
Let's define
your project.
Tell us what it needs to do, who will use it and what matters most to you. Together, we will clarify the scope and propose the next step.