DamianSuess

OSX How To: Uninstall native MySQL and install MariaDB via Homebrew

This is a short overview on how to completely remove any old mysql server installs in OSX and upgrade to MariaDB without conflicts. Things can get a bit weird when you have various old installs of MySQL server floating around, and utilizing homebrew to install and upgrade MariaDB as a drop in replacement for MySQL has worked well, especially if you're used to managing MySQL installs via yum in linux.

First: Backup Your Data!

Backup all of your current databases with mysqldump

This isn't a tutorial on backups, and there are many ways to do it. You should know how to backup your data anyway. For this example, we'll do a full backup of our InnoDB databases.

DamianSuess

namespace TestApp.Droid
{
  [Activity(Label = "myApp",
          MainLauncher = true,
          Icon = "@drawable/Icon",
          ScreenOrientation = ScreenOrientation.Landscape)]
  public class MainActivity : global::Xamarin.Forms.Platform.Android.FormsAppCompatActivity
  {
    protected override void OnCreate(Bundle bundle)
    {

DamianSuess

namespace TestApp.Droid
{
  [Activity(Label = "TestApp",
            Icon = "@drawable/icon",
            Theme = "@style/MyTheme",
            ConfigurationChanges = ConfigChanges.ScreenSize | ConfigChanges.Orientation,
            NoHistory = true)]
  public class MainActivity : global::Xamarin.Forms.Platform.Android.FormsAppCompatActivity
  {
    protected override void OnCreate(Bundle bundle)

DamianSuess

/*
  Source:
  https://forums.xamarin.com/discussion/30055/connecting-to-a-bluetooth-scanner-with-xamarin-android#Comment_94845
  
  The problem relates to device.GetUuids. You are assuming the Uuid is what you
  want with ElementAt(0). What you need is a loop inside your foreach, like in
  the following testing, that the device supports the Bluetooth Serial Port Profile
*/

  ParcelUuid[] uuids = device.GetUuids();

DamianSuess

// Requires the following permission in your AndroidManifest.xml
// <uses-permission android:name="android.permission.READ_PHONE_STATE" />

using System.Collections.Generic;
using Android.Telephony;
// ...
protected override void OnCreate(Bundle bundle)
{
  base.OnCreate(bundle);
  

DamianSuess

namespace XI.Template
{
  using System.ComponentModel;
 
  class ThreadTest
  {
 
    #region Constructor and attributes
 
    private System.ComponentModel.BackgroundWorker _thread;

DamianSuess

//
// Used to create a Combined GUID for database Primary Keys
//
public Guid GenerateComb()
{
  // T-SQL Equivalent
  // DECLARE @guid UNIQUEIDENTIFIER;
  // SET @guid = CAST(CAST(NEWID() AS BINARY(10)) + CAST(GETDATE() AS BINARY(6)) AS UNIQUEIDENTIFIER);
  // SELECT @guid;

DamianSuess

using System.IO;
using System.Reflection;
using System.Runtime.InteropServices;
using System.Text;

namespace Xeno.Tools
{
  class IniFile
  {
    private const string INI_EXT = ".ini";

DamianSuess

using System.Diagnostics;
// ...

Stopwatch sw = new Stopwatch();
sw.Start();

// ...

sw.Stop();
Console.WriteLine("Elapsed={0}", sw.Elapsed);

DamianSuess

  /// ----------------------------------------------------------------------------
  /// <summary>Convert from String^ to std::string</summary>
  System::Void TestClass::MarshalString(String ^ strIn, string& strOut)
  {
    using namespace Runtime::InteropServices;
    const char* chars = (const char*)(Marshal::StringToHGlobalAnsi(strIn)).ToPointer();
    strOut = chars;
    Marshal::FreeHGlobal(IntPtr((void*)chars));
  }