joebowbeer

-- Adapted from https://github.com/prrao87/kuzudb-study

-- Load vertices and edges

CREATE TABLE City AS SELECT * FROM
  'https://github.com/prrao87/kuzudb-study/raw/main/data/output/nodes/cities.parquet';
CREATE TABLE Country AS SELECT * FROM
  'https://github.com/prrao87/kuzudb-study/raw/main/data/output/nodes/countries.parquet';
CREATE TABLE Interest AS SELECT * FROM
  'https://github.com/prrao87/kuzudb-study/raw/main/data/output/nodes/interests.parquet';

joebowbeer

-- Adapted from https://docs.kuzudb.com/get-started/

-- Install and load SQL/PGQ extension
INSTALL duckpgq FROM community;
LOAD duckpgq;

-- City vertex table
CREATE TABLE City AS SELECT * FROM read_csv(
  'https://github.com/kuzudb/kuzu/raw/master/dataset/demo-db/csv/city.csv',
  names=[name, population]

joebowbeer

-- From https://motherduck.com/blog/duckdb-puppygraph-graph-model-on-motherduck/

install zipfs from community;
load zipfs;
load httpfs; -- TODO: autoload

CREATE TABLE account AS SELECT * FROM read_csv(
  'zip://https://snap.stanford.edu/data/twitch_gamers.zip/large_twitch_features.csv',
  types={mature: boolean, dead_account: boolean, affiliate: boolean}
);

joebowbeer

/// Receives MIDI events
function recv(evt) {
  var data = evt.data;
  var cmd = data[2] & 0xF0; // command
  var chn = data[2] & 0x0F; // channel
  var num = data[3]; // note or controller number
  var val = data[4]; // velocity or controller value
  switch(cmd) {
    case 0x80: // noteOff
    case 0x90: // noteOn

joebowbeer

import { Module } from '@nestjs/common';
import { MyLibModule } from './my-lib.module';

@Module({
  imports: [
    MyLibModule.register({ name: 'Enzo' }),
  ]
})
export class ImportingModule {}