Setup embeddable database

[Lelelo1]

Setup SQLite in Haxe
As I want the search to be embeddable in the client I need to setup a working database interaction. SQLite exists in the Sys package in haxe, and Open Street Map has it's data in it.
However since my primary target now being .net - it is unclear how to set up the needed driver: https://community.haxe.org/t/sqlite-in-c-target/3270/2 I will use a .net standard nuget package with SQLite driver and functionality init.

For other targets like cocoa I would use the C++ driver and set it up later.

Using haxe means I can have shared resources. But is a bit unclear what the path to .db would be.

Also it can be seen as a separate project to create cross platform embeddable db as a haxelib. It could depend on native packages and/or native drivers. Then set up in way the client/developer can read and write any data to it.

It needs to be assured also that the data is persistent between app start, on mobile for instance...

[Lelelo1]

Seems like there is libraries for cross database: https://lib.haxe.org/t/database/
They have not been updated for long time but looks reliable.

[Lelelo1]

It seems like I can create an internal database and object relational mapping. The haxlib has is updated and has many downloads: https://github.com/HaxeFoundation/record-macros
I will test and see if it also includes the necessary drivers on each platform

[Lelelo1]

It seems bit completed to work with orm, and running the sample code resulted in errors.

This the following json db haxelib seem to be simple to work with, and it says it works on all Sys targets.
It has not been updated for a while, but I will try it!: https://github.com/ciscoheat/haxelow

[Lelelo1]

I will setup the db and make a test on a Xamarin Forms android device. And on cocoa I will run it on watchOS os via Xcode in the way that the watchOSDummySample was made with haxe-c-bridge

[Lelelo1]

Then I will have to structure the data in a good way

[Lelelo1]

It does not seem like in an agnostic file path can be made unless creating in memory db. I think it should be possible to read the shipped db as resources (json) and create a in memory db out of it, to use in the search in the client.

This means it can't permanently written to at runtime, but I don't that would be advisable to do any way. Here is a sketch:

The in memory db is created at runtim - using it for search of categorical tags. The resources should be created when building the library and tags are assembled

---

I will see if in memory reading from resource works in dotnet target and cocoa (via haxe-c-bridge)

[Lelelo1]

I choose to go with sqlite. Since multiple .db files are needed for specifying language - I will be looking to see if it is possible to read and write persistent (disk saved) database files in haxe, and test in Xamarin Forms on android, and in cocoa for apple watch.

[Lelelo1]

To test it out I am first checking so that. can save and read a text field in haxe, on Android iOS, watchOS. It was not possible with default

var filename = "./testTags.txt";
    var output = File.write(filename, false);
    output.writeString(text);
    output.close();
    
    Sys.println("read written file...");
    var input = File.read(filename, false);
    var gotText = input.readLine();

So I am looking for other means with some haxelib maybe to do it

[Lelelo1]

The path needs to given from the client, here is docs with xamarin: https://docs.microsoft.com/en-us/xamarin/xamarin-forms/data-cloud/data/databases

There should be something similar in swift (cocoa) for watchOS, probably NSPersistentContainer. I needed to update my apple watch to test it out more.

I will setup a test method which writes the TestTags to file specified with url - then reading them from file. In cocoa, this step will have to be made with care - as mentioned by haxiomic in haxe-c-bridge I will need specking a TestTag.h and declare a custom array type. It should also be stack allocated and copied in client
But I will test with dotnet first