update to handle motherduck

[matsonj]

No description provided.

[Alex-Monahan]

Woot! Following... 😄

[matsonj]

@Alex-Monahan can you poke internally for a key 😇

[Alex-Monahan]

@Alex-Monahan can you poke internally for a key 😇

Happy to ask! Did you already apply for an invite on our site? https://motherduck.com/

[matsonj]

Yes I am in the queue!

[Alex-Monahan]

Invite sent! Let me know if you have any questions or issues. Psyched to see what you build and happy to help along the way!

[matsonj]

Ok small issue, from the dbt-duckdb repo:

MotherDuck databases do not suppport transactions, so there is a new disable_transactions profile option that will be automatically enabled if you are connecting to a MotherDuck database in your path.

I am indeed using transactions to calculate ELO changes HOWEVER, it is deprecated and replaced in the "v2" version of this project. I suggest you follow along there, as I will handle it there.

[matsonj]

👀 👀

nba-monte-carlo/evidence/package-lock.json

Lines 3181 to 3199 in c34f53e

	"node_modules/duckdb": {
	"version": "0.8.1",
	"resolved": "https://registry.npmjs.org/duckdb/-/duckdb-0.8.1.tgz",
	"integrity": "sha512-a2SJDuvBVKy5muYFxXTANlqdNX1daF3NHzpqRdrk0Qx5n3Sh7BxL66O+WY9epaDFukiXEpz45sds5T1LaPaHog==",
	"hasInstallScript": true,
	"peer": true,
	"dependencies": {
	"@mapbox/node-pre-gyp": "^1.0.0",
	"node-addon-api": "*",
	"node-gyp": "^9.3.0"
	}
	},
	"node_modules/duckdb-async": {
	"version": "0.8.1",
	"resolved": "https://registry.npmjs.org/duckdb-async/-/duckdb-async-0.8.1.tgz",
	"integrity": "sha512-/g5/zxC5XXXeQVEs86AtWVnzOmS7FBgVm976sJ75Tvrovms+QC5V+0SLNOl6VJQUT55NvvlrwX1zQybQfa+48w==",
	"peer": true,
	"dependencies": {
	"duckdb": "0.8.1"