Tekartik
Official@tekartik · France
Mobile & Web development
Agent Skills by Tekartik
Showing 13 vetted skills indexed across 1 GitHub repositories.
tekartiksqflite-darwin-setup
Configure and troubleshoot the iOS and macOS implementation of the sqflite Flutter plugin.
tekartiksqflite-android-setup
Configures and troubleshoots the sqflite Android implementation for Flutter SQLite databases.
tekartiksqflite-common-ffi-web-setup
Configures sqflite SQLite databases for Flutter web and Dart web apps using WebAssembly.
tekartiksqflite-common-ffi-web-options
Configure custom sqflite web factories, worker options, and IndexedDB stores for Flutter web.
tekartiksqflite-ffi-flutter
Configures sqflite_ffi as a shared ffi SQLite database factory across Flutter isolates.
tekartiksqflite-common-api
Write Flutter-free Dart code against the sqflite SQLite API with injected database factories.
tekartiksqflite-crud-and-transactions
Implements CRUD operations, transactions, and batches with the sqflite Flutter plugin.
tekartiksqflite-testing-and-platforms
Configure sqflite database factories for Flutter tests, desktop, web, and SQL debugging.
tekartiksqflite-open-database
Open, migrate, and manage SQLite databases in Flutter apps with sqflite.
tekartiksqflite-platform-interface-implementers
Implements and registers platform implementations of the sqflite federated Flutter plugin.
tekartiksqflite-common-ffi-async-factory
Implements concurrent SQLite reads on desktop using the sqlite_async-backed sqflite DatabaseFactory.
tekartiksqflite-common-ffi-testing
Test sqflite database code on Dart VM and Flutter test runners using sqflite_common_ffi.
tekartiksqflite-common-ffi-desktop
Configures sqflite databases on Windows, Linux, and macOS using the sqflite_common_ffi factory.
Frequently Asked Questions About Tekartik
FAQPage SchemaWhat tasks can I accomplish with Tekartik's sqflite skills?▼
You can open, create, migrate, and delete SQLite databases in Flutter; run CRUD, raw queries, transactions, and batches; configure platform-specific setups for Android, iOS, macOS, desktop, and web; and test database code on the Dart VM without a device or emulator.
Who are these sqflite skills designed for?▼
Flutter and Dart developers building mobile, desktop, or web apps with local SQLite persistence, plus engineers implementing custom federated platform packages (sqflite_<platform>) or registering a custom DatabaseFactory through the SqflitePlatform interface and method channel.
How do I run sqflite on desktop, web, or in tests?▼
Use sqflite_common_ffi with sqfliteFfiInit and databaseFactoryFfi for Windows, Linux, macOS, and VM tests; use sqflite_common_ffi_web with dart run sqflite_common_ffi_web:setup to install sqlite3.wasm and sqflite_sw.js for web; set the global databaseFactory so openDatabase works.
What platform-specific configuration does sqflite require?▼
Android needs minSdk settings and optional WAL via manifest meta-data; iOS/macOS use the sqflite_darwin package with CocoaPods or Swift Package Manager, iOS 12/macOS 10.14 targets, and a bundled FMDB fork; web requires serving sqlite3.wasm and a worker file with IndexedDB persistence.
What are the known limitations and prerequisites of sqflite?▼
Supported column types are int, num, String, and Uint8List (no bool or DateTime); Android has a 1 MB CursorWindow row limit; the experimental ffi_async factory lacks logger support and ignores singleInstance; web storage is port-bound, and tests require swapping the global databaseFactory.