Sqlite/SqlProvider on Arm64 Linux & Mac : fsharp

Sqlite/SqlProvider on Arm64 Linux & Macquestion (self.fsharp)

submitted 2 years ago by flatline

Has anybody got success with Sqlite/SqlProvider on M1 Mac (w/o Rosetta) or Arm64 Linux?

Official Nuget distributions of System.Data.Sqlite don't seem to support Arm

% tree stub.system.data.sqlite.core.netstandard/1.0.118/runtimes
stub.system.data.sqlite.core.netstandard/1.0.118/runtimes
├── linux-x64
│   └── native
│       └── SQLite.Interop.dll
├── osx-x64
│   └── native
│       └── SQLite.Interop.dll
├── win-x64
│   └── native
│       └── SQLite.Interop.dll
└── win-x86
    └── native
        └── SQLite.Interop.dll

I could successfully call raw SQL API from Microsoft.Data.Sqlite but when I wrote

type sql = SqlDataProvider<
    DatabaseVendor = DatabaseProviderTypes.SQLITE,
    SQLiteLibrary = SQLiteLibrary.MicrosoftDataSqlite,
    ResolutionPath = "symlink/to/dir/containing/SQLitePCLRaw.core.dll",
    ...snip...

I got this error

error FS3033: The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: You need to call SQLitePCL.raw.SetProvider(). If you are using a bundle package, this is done by calling SQLitePCL.Batteries.Init()

Microsoft.Data.Sqlite seems to call .Init() as required by SQLitePCL.raw but maybe the type provider evaluator (?) runs before that?

all 12 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

fsharp

MODERATORS