go-rel / mssql Goto Github PK
View Code? Open in Web Editor NEWMicrosoft SQL server adapter for REL written in Golang.
Home Page: https://go-rel.github.io/
License: MIT License
Microsoft SQL server adapter for REL written in Golang.
Home Page: https://go-rel.github.io/
License: MIT License
The official support for the MSSQL driver has moved to Microsoft. It might be a good idea to switch to the new repository: https://github.com/microsoft/go-mssqldb
on conflict
/on duplicate key
syntax. but this syntax seems not supported in MSSQLMERGE
.Disclaimer: I'm just reviewing the code while deciding whether to use or not. I haven't used this for real yet.
I believe a GO string (Unicode) best matches to NVARCHAR instead of VARCHAR. That will support the full Unicode set. At least that's what I've done in my code and it's worked well.
Lines 137 to 142 in e7d7d12
Disclaimer: Just reviewing code at this point.
Lines 143 to 145 in e7d7d12
The "timestamp" keyword for a data type is deprecated and will be removed in a future version. They suggest using "rowversion".
Same disclaimer: Just reviewing code, not an actual user at this point.
The "text" type is deprecated in SQL Server and will be removed in a future version.
Microsoft suggests replacing with NVACHAR(MAX) or VARCHAR(MAX). I'd prefer NVARCHAR(MAX) to support Unicode.
Lines 143 to 145 in e7d7d12
Disclaimer: Just reviewing code at this point.
rel.ID
is interesting. It mixes in a few different things. It would be interesting to have a rel.BigID
that maps to BIGINT NOT NULL IDENTITY(1,1) PRIMARY KEY
I'm using BIGINT instead of INT in more and more tables these days -- especially for anything transactional.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.