Deployment and release

[jmakinin]

I have been facing issues building a workable release version of my application running the Prisma client with SQLite database.
The built release app cannot establish a connection to the SQLite database I am using.

My system is Windows 11

Flutter version

$ flutter --version
Flutter 3.10.6 • channel stable • https://github.com/flutter/flutter.git
Framework • revision f468f3366c (3 months ago) • 2023-07-12 15:19:05 -0700
Engine • revision cdbeda788a
Tools • Dart 3.0.6 • DevTools 2.23.1

Dart version

$ dart --version
Dart SDK version: 3.0.6 (stable) (Tue Jul 11 18:49:07 2023 +0000) on "windows_x64"

And I am targeting deployment to the Windows platform.

this is the database connection class

import 'dart:io';
import 'package:orm/logger.dart';
import 'generated/prisma_client.dart';

class PrismaConnect {
static final databaseUrl =
Platform.script.resolve('assets/database/source.sqlite').toFilePath();
late final PrismaClient prisma;

PrismaConnect() {
_connect();
}

Future _connect() async {
prisma = PrismaClient(
stdout: Event.values,
datasources: Datasources(db: 'file:$databaseUrl'),
);
await prisma.$connect(); // Await the connection
}

Future close() async {
await prisma.$disconnect(); // Close the connection
}
}

this is the main application instance

import 'package:class_wise/core/utils/constants.dart';
import 'package:flutter/material.dart';
import 'package:flutter_riverpod/flutter_riverpod.dart';
import 'package:go_router/go_router.dart';
import 'package:google_fonts/google_fonts.dart';
import 'package:window_size/window_size.dart';
//routes
import 'package:class_wise/routes/router.dart';

void main() {
WidgetsFlutterBinding.ensureInitialized();
setWindowTitle("CLassWise");
setWindowMinSize(const Size(1500, 900));
setWindowMaxSize(Size.infinite);

runApp(ProviderScope(
child: MyApp(),
));
}

class MyApp extends StatelessWidget {
final GoRouter _router = createRouter();
@OverRide
Widget build(BuildContext context) {
return MaterialApp.router(
debugShowCheckedModeBanner: false,
title: 'ClassWise',
theme: ThemeData.dark().copyWith(
scaffoldBackgroundColor: bgColor,
textTheme: GoogleFonts.robotoFlexTextTheme(Theme.of(context).textTheme)
.apply(bodyColor: Colors.white),
canvasColor: secondaryColor,
),
routerConfig: _router,
);
}
}

I'm pretty new to this, and I have so far not seen a Flutter desktop application in production (I don't know of any at the moment that uses the stack I am using)
Any help will be much appreciated.

#Windows #Deployment #Production #BuildRelease #DatabaseConnection #Flutter #Dart

[medz]

At present, Flutter (native) is not supported and can only be used for the data proxy engine. It will take me about two months to solve this problem.

[jmakinin]

okay, sure. I'm deadlocked in a project I'm currently working on, and the alternative is to change the entire stack if it can not be implemented as needed.

How can I help speed things up?

[medz]

okay, sure. I'm deadlocked in a project I'm currently working on, and the alternative is to change the entire stack if it can not be implemented as needed.

How can I help speed things up?

@jmakinin Can you help me speed up the implementation of this? There are many problems I have to deal with now. The first is debt, and the other is the adaptation of the new protocol of Prisma 5 (this will almost cause the entire project to be rewritten). I also need Prisma to dynamic library. It is really difficult to write. I am the only one maintaining the project from its inception to the present. I really have a lot of things that need to be done.

[medz]

I'm actively developing a new version to adapt to Prisma 5

[medz]

#328