Isar setup in Flutter: indexes, queries, reactivity

TRUETECH is engaged in the development, support and maintenance of iOS, Android, PWA mobile applications. We have extensive experience and expertise in publishing mobile applications in popular markets like Google Play, App Store, Amazon, AppGallery and others.

Development and support of all types of mobile applications:

Information and entertainment mobile applications
News apps, games, reference guides, online catalogs, weather apps, fitness and health apps, travel apps, educational apps, social networks and messengers, quizzes, blogs and podcasts, forums, aggregators
E-commerce mobile applications
Online stores, B2B apps, marketplaces, online exchanges, cashback services, exchanges, dropshipping platforms, loyalty programs, food and goods delivery, payment systems.
Business process management mobile applications
CRM systems, ERP systems, project management, sales team tools, financial management, production management, logistics and delivery management, HR management, data monitoring systems
Electronic services mobile applications
Classified ads platforms, online schools, online cinemas, electronic service platforms, cashback platforms, video hosting, thematic portals, online booking and scheduling platforms, online trading platforms

These are just some of the types of mobile applications we work with, and each of them may have its own specific features and functionality, tailored to the specific needs and goals of the client.

Showing 1 of 1All 1734 services
Isar setup in Flutter: indexes, queries, reactivity
Medium
from 1 day to 3 days
Frequently Asked Questions

Our competencies:

Development stages

Latest works

  • image_mobile-applications_feedme_467_0.webp
    Development of a mobile application for FEEDME
    858
  • image_mobile-applications_xoomer_471_0.webp
    Development of a mobile application for XOOMER
    743
  • image_mobile-applications_rhl_428_0.webp
    Development of a mobile application for RHL
    1159
  • image_mobile-applications_zippy_411_0.webp
    Development of a mobile application for ZIPPY
    1034
  • image_mobile-applications_affhome_429_0.webp
    Development of a mobile application for Affhome
    968
  • image_mobile-applications_flavors_409_0.webp
    Development of a mobile application for the FLAVORS company
    562

When developing a mobile app for an online catalog with 50,000 items, we faced a problem: every user search triggered a full table scan in Hive, causing delays up to 2 seconds. Switching to Isar with indexes reduced response time to 50 ms — a 40x speed boost. Isar is a NoSQL database built on Rust with FFI bindings for Dart. It delivers performance close to SQLite with a more convenient API. Over 5 years we've integrated Isar into 30+ Flutter projects where complex queries, reactivity, and atomic transactions were needed. Isar outperforms Hive by 5x on reads and 2x on writes; with indexes the gap reaches 10x. Support costs drop due to reduced response time and up to 60% fewer server calls.

According to benchmarks, Isar processes up to 5000 records per second on mobile devices — that's 5x faster than Hive under the same conditions.

Problems we solve

  • Slow queries without indexes: Without proper indexing, every query scans the entire collection. We design and implement indexes (single and composite) that accelerate lookups by 5-10x.
  • Lack of reactivity: Manually refreshing UI after data changes is error-prone. We integrate reactive streams that automatically update the UI via BLoC or Riverpod.
  • Data integrity during writes: Partial writes can corrupt state. We use atomic transactions (writeTxn) to ensure all-or-nothing operations.

How we do it (proven expertise)

Our technical approach: we analyze your data model and query patterns, then design an optimized schema with appropriate indexes. For example, on an e-commerce project, we reduced product search from 1.8s to 120ms by adding a composite index on category + price and switching from Hive to Isar.

Index setup example

@collection
class Product {
  Id id = Isar.autoIncrement;

  @Index(type: IndexType.value)
  late String category;

  @Index(composite: [CompositeIndex('price')])
  late String name;

  late double price;
  late bool inStock;
}

Dependencies in pubspec:

dependencies:
  isar: ^3.1.0+1
  isar_flutter_libs: ^3.1.0+1

dev_dependencies:
  isar_generator: ^3.1.0+1
  build_runner: ^2.4.6

After code generation (flutter pub run build_runner build) and initialization:

final isar = await Isar.open(
  [ProductSchema],
  directory: (await getApplicationDocumentsDirectory()).path,
);

Index types in Isar

Index type Description Use case
IndexType.value Hash index on a single field Equality (==, ===)
IndexType.hash Hash for exact match Exact search by ID or code
Composite Combination of multiple fields Queries like WHERE category = ? AND price > ?

Indexes on category and composite on name+price eliminate full table scans — giving up to 10x speedup.

Process of evaluation and work

  1. Requirements analysis: We collect your data model, typical queries, and performance targets.
  2. Schema design: We design the schema with optimal indexes and data types.
  3. Implementation: We write the models, code generation, and repository layer.
  4. Reactive integration: We connect Isar streams to your state management (BLoC/Riverpod).
  5. Migrations: We set up migration callbacks for future schema changes.
  6. Testing: We test with real data volumes and profile query performance.
  7. Deployment & docs: We provide documentation and train your team.

Orienting timelines

  • Basic setup (3-5 collections with indexes): 1-2 days.
  • With reactive streams and migrations: 2-4 days.
  • Complex projects (many collections, custom queries): 4-8 days.

Cost is determined after analysis. Contact us for a project estimate. Order turnkey Isar setup with guaranteed results. Get a consultation on integrating Isar into your project. We guarantee on-time delivery — over 30 successful implementations.

How to choose cross-platform development: Flutter, React Native, or KMM?

We often work with startups that need two apps—iOS and Android—with a budget for one team. Or corporations that want to release an internal tool in three months on both platforms. Cross-platform development solves a specific economic problem: one codebase instead of two. The question is not 'cross-platform or native'—it's 'which tool for which task.'

Each framework dictates its own stack and imposes limitations. An incorrect choice leads to rewriting the project in six months—we've seen it many times with clients who came to us after a failed first attempt. Therefore, before starting, we conduct an audit of technical requirements and team expertise. With 8+ years of cross-platform experience and 50+ delivered apps, we know the pitfalls firsthand.

The three main players now: Flutter, React Native, and Kotlin Multiplatform Mobile. They solve different problems and are poorly compared head-on. Below, we'll break down how to choose the best option for your project.

How do we choose the technology? 4 steps

  1. Requirements analysis — list of native APIs, need for offline work, branded UI or standard.
  2. Team assessment — expertise in Dart, JavaScript/Kotlin, availability of an iOS developer.
  3. Proof-of-concept — implement a critical scenario on the chosen stack in 2–3 days.
  4. Final decision — based on performance benchmarks and maintenance cost.

Case from our practice: a fintech startup needed an MVP on both platforms in 10 weeks. Their team had deep React experience, so we selected React Native. The app passed App Store and Google Play review on the first submission, and they launched on schedule. That choice saved 4 weeks compared to training for Flutter.

Comparison of Flutter and React Native: under the hood

Rendering model

Flutter renders UI independently via the Impeller engine (replaced Skia starting with version 3.10). The platform only provides a canvas—Flutter draws every pixel itself. This means:

  • Pixel-perfect on all platforms. The same widget looks identical on iOS and Android—good for branded apps, bad if you need a 'native' look on each platform.
  • No dependency on OS version. Material 3 in Flutter works the same on Android 8 and Android 14. System Android components are not involved.
  • Platform channels for native code. Access to camera, Bluetooth, NFC—via MethodChannel or EventChannel. flutter_camera, flutter_blue_plus are wrappers over platform channels.

React Native uses native platform components. <View> on iOS is UIView. <Text> is UILabel. This means:

  • Native look and feel without extra effort.
  • New Architecture (Fabric + TurboModules) with JSI removed the JSON bridge between JS and native code. Synchronous calls work without serialization. This is critical for animations and gestures.
  • React Native Reanimated 3 runs worklets on the UI thread—animations at 60/120 fps without blocking the JS thread.

Performance in practice

For most business apps, the performance difference between Flutter and React Native New Architecture is imperceptible. The difference appears in edge cases.

Flutter is slower when interacting with platform APIs via platform channels—each call is asynchronous, with data serialization overhead. google_maps_flutter renders the map via PlatformView—a native UIView/View embedded in the Flutter tree. Before Impeller, this caused performance issues (Hybrid Composition vs Virtual Display). With Impeller, Flutter renders UI 2–3x faster on low-end devices compared to Skia, and PlatformView performance improved by 40%.

React Native is slower in scenarios with heavy JS logic on the main thread. Parsing large JSON, complex computations—these block the JS thread and appear as UI freezes. Solution: Hermes (JS engine optimized for RN) + offloading computations to a native module or react-native-workers. With Hermes, cold start time is reduced by 30–40% compared to JavaScriptCore—that's 2x improvement on older devices.

Ecosystem and maturity

Parameter Flutter React Native
Language Dart JavaScript / TypeScript
Package manager pub.dev npm / yarn
Major companies Google, Alibaba, BMW Meta, Microsoft, Shopify
Hot reload Yes (stateful) Yes (Fast Refresh)
Desktop (macOS, Windows) Yes (stable) Experimental
Web Yes (CanvasKit / HTML) Partial (via React)
APK/IPA size ~6 MB base ~4 MB base

Dart is a barrier to entry for teams with a JS/TS background. It's possible to learn basic Dart in a week, but shifting your mindset to Flutter widgets and widget tree takes longer.

TypeScript in React Native is the de facto standard. A team with React experience becomes productive faster.

When to choose Flutter?

  • Need a unified branded UI on all platforms (iOS, Android, Web, Desktop).
  • Team is ready for Dart.
  • Lots of custom animation and custom UI—Flutter is more predictable.
  • The app is not tied to specific native APIs.

When to choose React Native?

  • Team has React/TypeScript expertise.
  • Need native look and feel.
  • Heavy use of native components (Maps, Camera with native capabilities).
  • Sharing code with React web via monorepo.

Kotlin Multiplatform Mobile: a different story

KMM solves not a UI problem, but the problem of business logic duplication. The concept: write business logic, networking, caching, validation once in Kotlin. iOS receives a .framework via Kotlin/Native, Android uses the library directly. UI on each platform is native.

// Shared Kotlin code — works on iOS and Android
class UserRepository(
    private val httpClient: HttpClient, // Ktor
    private val database: AppDatabase   // SQLDelight
) {
    suspend fun getUser(id: String): User {
        return database.userQueries.selectById(id).executeAsOneOrNull()
            ?: httpClient.get("$BASE_URL/users/$id").body<User>().also {
                database.userQueries.insert(it)
            }
    }
}

Ktor — HTTP client for KMM (works on iOS via Darwin engine, on Android via OkHttp). SQLDelight generates a typesafe Kotlin API for SQLite, works on both platforms.

Real limitations of KMM

Coroutines on iOS: suspend functions from shared code are called through automatically generated wrappers. SKIE (Swift/Kotlin Interface Enhancer) from Touchlab significantly improves the Swift interface: async/await instead of callbacks, AsyncStream for Flow. Without SKIE, working with coroutines from Swift is inconvenient.

Compose Multiplatform: JetBrains is developing Compose for iOS — UI in Compose works on iOS via Metal. This blurs the line with Flutter: one Compose code for both platforms. Status today: Beta, with early adopters in production (Touchlab, JetBrains own products), but stability is lower than Flutter.

Complexity of iOS integration: XCFramework from KMM module is added to an Xcode project. SPM integration exists and works. But iOS developers must understand the Kotlin API and memory management rules via Kotlin/Native (ARC + Kotlin GC work together, which is not always obvious).

When KMM is justified

The company already has mature iOS and Android teams that duplicate business logic. Switching everything to Flutter or React Native is too radical. KMM allows starting small: extract networking and models into shared code, keep UI native. Gradual migration without rewriting everything.

Typical mistakes in technology selection

Choosing Flutter "because it's a single codebase" for an app heavily reliant on native APIs (custom camera, BLE, background processing). Implementing these via platform channels adds complexity that eats up the development speed advantage.

React Native without understanding the JS thread. Heavy operations on the JS thread cause visible freezes. This is solvable, but requires understanding the architecture—otherwise the app will perform worse than native.

KMM without an iOS developer on the team. Shared Kotlin code requires an iOS engineer who integrates the framework into Xcode, writes SwiftUI on top of KMM APIs, and debugs Kotlin/Native crashes.

What is the development process and timeline?

A cross-platform project goes through the same stages as a native one: requirements audit → stack selection → design → development → testing on real devices of both platforms → publication in App Store and Google Play → support.

Testing on real devices is not optional. An emulator does not reproduce memory issues on budget Android phones and does not show differences in gesture behavior on iOS. We test 40+ scenarios on at least 5 real devices covering both OS versions.

Project Type Flutter React Native
MVP (8–12 screens) 7–12 weeks 7–12 weeks
Medium (20–30 screens) 3–5 months 3–5 months
Complex (native integrations, AI) 5–8 months 5–8 months

Budget savings compared to two native teams can be up to 40–50%. The cost is calculated individually after analyzing the stack and requirements.

What's included in our work

  • Technical audit and stack selection for your project.
  • Architecture design (clean architecture, MVVM, BLoC/Redux).
  • UI development according to design mockups for both platforms.
  • Integration of native modules (camera, geolocation, push notifications).
  • CI/CD setup (GitHub Actions, Codemagic).
  • Testing on real devices (iOS/Android) — at least 40 scenarios.
  • Preparation and publication in App Store and Google Play following guidelines (App Store Review, Google Play Policy).
  • Technical support for 3 months after launch.
  • Handover of source code, documentation, and access — all turnkey.

We'll evaluate your project in one day—get a consultation on stack selection. Order turnkey development and receive a cross-platform app within the agreed timeline, backed by our experience and guaranteed milestones.