Akavache 5.0 + Microsoft Mobile Services 0.15 = Conflict about appcenter-sdk-dotnet

[guperrot]

We do not have dependency on any 3rd party sqlite libraries on Xamarin.iOS, we use the system one and that conflicts at runtime with Avakache which uses a 3rd party library for sqlite.

What Jae answered is that the runtime error can be avoided by initializing MobileCenter before.

[guperrot]

I am considering leaving this one opened for visibility and avoid duplicates.

[ghuntley]

Howdy,

One of the maintainers for Akavache here. We aren't a huge fan of bundle_green, because it means an app is not using the same SQLite version on all platforms. This logic was part of the discussion back when Akavache chose to use bundle_e_sqlite3.

Eventually Microsoft is going to get an edge case where tests are green and they'll ship a a red build unknowingly for the iOS platform.

Eric (author of sqlpcliteraw) advocates using bundle_e_sqlite3 for these reasons but agrees that standardizing on a single bundle is not the 100% path to success. Rather it is just a path to a different kind of frustration. For example there are alternatives implementations of Sqlite such as Chipher and Couchbase.Lite.

This is discussed further over at
https://reactivex.slack.com/archives/C02CBKUV8/p1504541597000250 - send an email to [email protected] for a slack invitation.

[jaeklim]

MobileCenter must be started prior to any 3rd party libraries that are using custom SQLite. If you do so, there shouldn't be any issues with Akavache 5.0.

[guperrot]

No answer in 7 days, closing. Will reopen if needed.

[ghuntley]

@guperrot and @jaelim-ms there are issues and will be more issues like this raised in the future. Please start a conversation with the library author that you build upon and use as a dependancy for more specifics. This is a design issue, not a support issue.

[ghuntley]

@guperrot thanks for the convo. Learned a few things (thank-you) - not sure how we can resolve this one considering how Mobile Centre for .NET is constructed. Please close this issue out and Akavache will keep tracking over at reactiveui/Akavache#382

Summary:

• Azure Mobile Centre is actually developed as objective-c first; then that library is bundled up into an assembly w/p/invoke headers/bindings. See https://github.com/Microsoft/mobile-center-sdk-ios/tree/develop/MobileCenter/MobileCenter
• There's no easy way out of this situation; the only way out of this hot mess would be if the entire .NET ecosystem started using and standardized on bundle_green (i.e. don't ship sqlite for ios) but that still wouldn't fix consumers who use sqlite encryption or couchbase lite.

[biapar]

I send the code to Azure Mobility group, too.
The code where to init is into app.cs and I init the Mobile Library into appstart before Akavache.

`Xamarin Forms.

public App()

    {

        InitializeComponent();



     

        FlowListView.Init();



        //MainPage = new Harley_Davidson_Protection.MainPage();



        //BlobCache.ApplicationName = "HDAkavache";   // Init Akavache



        var menuPage = new MenuPage();



        NavigationPage = new NavigationPage(new DashboardPage())

        {

            BarBackgroundColor = Color.FromHex("#000"),

            BarTextColor = Color.White

        };



        //NavigationPage.BarBackgroundColor = Color.Black;



        //NavigationPage.BarTextColor =  Color.FromHex("#f48322");



        //NavigationPage.BarTextColor = Color.White;





        RootPage = new RootPage();

        RootPage.Master = menuPage;

        RootPage.Detail = NavigationPage;

        MainPage = RootPage;





        Color origPageBgColor = Color.Black;

        RootPage.IsPresentedChanged += async (object sender, EventArgs e) =>

        {

            if (Xamarin.Forms.Device.OS == TargetPlatform.iOS)

            {

                if (RootPage.IsPresented)

                {

                    var currentPage = ((NavigationPage)RootPage.Detail).CurrentPage;

                    origPageBgColor = currentPage.BackgroundColor;





                    currentPage.BackgroundColor = Color.Black;

                    currentPage.FadeTo(0.5);

                    if (currentPage.BackgroundColor == Color.Default)

                    {

                        currentPage.BackgroundColor = Color.White;



                    }



                    menuPage.Icon = "cross16.png";

                }

                else

                {

                    var currentPage = ((NavigationPage)RootPage.Detail).CurrentPage;

                    currentPage.BackgroundColor = origPageBgColor;

                    menuPage.Icon = "menu16.png";

                    currentPage.FadeTo(1.0);

                }

            }

        };

     }



    protected override void OnStart()

    {

        // Handle when your app starts





        Push.PushNotificationReceived += (sender, e) => {



            // Add the notification message and title to the message

            var summary = $"Push notification received:" +

                                $"\n\tNotification title: {e.Title}" +

                                $"\n\tMessage: {e.Message}";



            // If there is custom data associated with the notification,

            // print the entries

            if (e.CustomData != null)

            {

                summary += "\n\tCustom data:\n";

                foreach (var key in e.CustomData.Keys)

                {

                    summary += $"\t\t{key} : {e.CustomData[key]}\n";

                }

            }



            // Send the notification summary to debug output

            System.Diagnostics.Debug.WriteLine(summary);



            CrossLocalNotifications.Current.Show("Harley Davidson Protection", summary);

        };



      

        MobileCenter.Start("ios=xyzagd;" +

               "android=dfghtke;",

               typeof(Analytics), typeof(Crashes), typeof(Push));



      

    }`

[jaeklim]

I replied to you already, looks you are initializing Akavache in a constructor. Please move it after MobileCenter Start call.

[guperrot]

You can call MobileCenter.Start in constructor if you want by the way.

[biapar]

I already did what you say but I had the same problem.

[guperrot]

@biapar can you test with 0.16.0? A change has been made in iOS database implementation that could improve compatibility.

[guperrot]

@biapar did you get a chance to test with 0.16.0?

[sanyandreichuk]

I had the same issue and can confirm that 0.16.0 fixed it.

[biapar]

Hi, No. I’ll release the app in the next week and I don’t want some jokes. So I’ll create a new branch and l’ll try to update the libs avacache and mobile-center. Saluti ing. Biagio Paruolo

…

Il giorno 19 ott 2017, alle ore 21:53, Guillaume Perrot ***@***.***> ha scritto: @biapar did you get a chance to test with 0.16.0? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.

[biapar]

Very good. Saluti ing. Biagio Paruolo

…

Il giorno 20 ott 2017, alle ore 06:49, Sanya Andreichuk ***@***.***> ha scritto: I had the same issue and can confirm that 0.16.0 fixed it. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.

[guperrot]

@biapar when you said "very good", that means it worked for you?

[biapar]

No no, for Sanya Andreichuk response. 2017-10-21 3:14 GMT+02:00 Guillaume Perrot <[email protected]>:

…

@biapar <https://github.com/biapar> when you said "very good", that means it worked for you? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#439 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAoYDWUY1-4uDULGBwmSsLlZVVoiy3e7ks5suUVbgaJpZM4PaPbe> .

-- *Cordiali Saluti / Best RegardsIng. Biagio Paruolo* *Red Consulting s.a.s* Via Garibaldi, 1/B - 83025 Montoro Inferiore ( AV ) - Italy Tel: [phone] Fax: [phone] Web: www.redconsulting.it Email: [email protected] / SkyPe: biagioparuolo / Linkedin: it.linkedin.com/in/biagioparuolo/ Microsoft Partner | Web, E-commerce and Mobile Solutions | Register Gold Reseller | OVH Partner | Umbraco Partner This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

[guperrot]

Ok, based on @l3xer answer, 0.16.0 seems to fix the issue, so will wait another week before closing this ticket if I don't hear anything bad here.