Using SQL Server as Object Storage Engine and Metadata Engine

[wizpresso-steve-cy-fan]

Our company is running both Windows and MSSQL and we are curious on whether we can use our existing infrastructure to deploy JuiceFS. More specifically, we notice the object storage engine is just using XORM as a generic database interface:

juicefs/pkg/object/sql.go

Lines 34 to 40 in 6044432

	_ "github.com/go-sql-driver/mysql"
	_ "github.com/lib/pq"
	_ "github.com/mattn/go-sqlite3"
	"github.com/sirupsen/logrus"
	"xorm.io/xorm"
	"xorm.io/xorm/log"
	"xorm.io/xorm/names"

On the metadata engine side, we did a quick grep and see that there are only 6 results in https://github.com/juicedata/juicefs/blob/main/pkg/meta/sql.go. This means SQL dialect specific is close to none and we are confident this can be done with very little effort. So, should we also add https://github.com/denisenkom/go-mssqldb for an almost free-ride?

[wizpresso-steve-cy-fan]

To deploy a MSSQL test server in the CI pipeline, we can use https://hub.docker.com/_/microsoft-azure-sql-edge.