Drift and GetX

[AMT-Cheif]

Hello, I'm new of state manager, I'm just started to learning.
I'm using drift to manage database data, I followed a tutorial online that use provider, but since is complicated for me, I started to use getX on other part of the application, now I would like to remove provider parts and use only getX;
So, Drift wiki say:
Using the database
If you've created a MyDatabase class by following the getting started guide, you still need to somehow obtain an instance of it. It's recommended to only have one (singleton) instance of your database, so you could store that instance in a global variable:

If you're using the GetX package, you can add it as a service that manages the database instance:.

void main() {
  Get.put(MyDatabase());
  runApp(MyFlutterApp());
}

here my actual code:

LazyDatabase _openConnection(){
  // the LazyDatabase util lets us find the right location for the file async.
  return LazyDatabase(() async {
    // put the database file, called db.sqlite here, into the documents folder
    // for your app.
    final dbFolder = await getApplicationDocumentsDirectory();
    final file = File(path.join(dbFolder.path,'TEST_db.db'));
    // Make sqlite3 pick a more suitable location for temporary files - the
    // one from the system may be inaccessible due to sandboxing.
    final cachebase = (await getTemporaryDirectory()).path;
    // We can't access /tmp on Android, which sqlite3 would try by default.
    // Explicitly tell it about the correct temporary directory.
    sqlite3.tempDirectory = cachebase;
    return NativeDatabase.createInBackground(file);

  });
}

@DriftDatabase(tables: [ITEM, ORDER],daos: [ITEMDao,ORDERDao])
class AppDb extends _$AppDb{
  AppDb() : super(_openConnection());
  @override
  int get schemaVersion =>1;
  }

and inside the screens where I need to manage data:
for example to build a list:

body: StreamBuilder<List<ORDERData>>(
          stream:Provider.of<AppDb>(context, listen: true).ORDERDao.getORDERs(),
          builder: (context, snapshot) {
            final List<ORDERData>? order = snapshot.data;
            if (snapshot.connectionState != ConnectionState.active) {
              return const Center(
                child: CircularProgressIndicator(),
              );
            }
            if (snapshot.hasError) {
              return Center(
                child: Text(snapshot.error.toString()),
              );
            }
            if (order != null) {
              return ListView.builder(.........

or to to add an Order:
void AddORDER(){

final isValid =_formKey.currentState?.validate();
if (isValid !=null && isValid){
  final entity= ORDERCompanion(
    name: drift.Value(_Namecontroller.text),
    description:drift.Value(_Descriptioncontroller.text),
    price: drift.Value(double.parse(_PRICEcontroller.text)),
  );
  Provider.of<AppDb>(context,listen: false).ORDERDao.insertORDER(entity).then((value)=> ScaffoldMessenger.of(context)
      .showMaterialBanner(
    MaterialBanner(
      backgroundColor: Colors.red,
      content: Text('New ORDER inserted: $value'),
      actions: [
        TextButton(
            onPressed: (){
              ScaffoldMessenger.of(context).clearMaterialBanners();
              ScaffoldMessenger.of(context).clearSnackBars();
            },
            child:const Text('Close', style: TextStyle(color: Colors.white),))
      ],
    ),
  ),
  );
}
  }
}

and in the main.dart:

Future<void> main() async {

  runApp(
    Provider(
      create: (context) => AppDb(),
      child: const MyApp(),
      dispose: (context, AppDb db) => db.close(),
    ),
  );
}

Can you help me to convert it to use getX?

[simolus3]

It's impossible to see what kind of class Get is from the dartdoc of that package, but if it's a global dependency manager then you could do Get.put(AppDb()) in main and then use the database with Get.find<AppDb>() where you are currently using provider.