Hugoberry’s gists

Hugoberry / duckdb-RAG.py

Last active March 6, 2024 11:03

Bare-bones implementation of similarity search in DuckDB using Expression API

	import duckdb
	from duckdb import (
	ConstantExpression,
	ColumnExpression,
	FunctionExpression,
	StarExpression
	)
	conn = duckdb.connect(database='embed.ddb')

	text="Wooden floor"

Hugoberry / KMeansClustering.dax

Created January 18, 2024 12:56

A worked example of using the undocumented DAX function KMeansClustering

Hugoberry / customEdge.html

Created January 17, 2024 09:22 — forked from davidjgraph/customEdge.html

Custom edge example for mxGraph

	<!--
	$Id: markers.html,v 1.4 2013/10/28 08:44:55 gaudenz Exp $
	Copyright (c) 2006-2014, JGraph Ltd

	Demonstrates creating a custom edge in mxGraph
	-->
	<html>
	<head>
	<title>Custom edge example for mxGraph</title>

Hugoberry / mxGraphNarrativeChartsRewrite.js

Created December 14, 2023 22:25

	// Function to wrangle data into the required format
	function wrangle(data) {
	let charactersMap = {};

	// Helper function to get characters by ID
	function characterById(id) {
	if (!charactersMap[id]) {
	charactersMap[id] = data.characters.find(character => character.id === id);
	}
	return charactersMap[id];

Hugoberry / mxGraphNarrativeCharts.js

Last active December 14, 2023 22:17

	<head>
	<script type="text/javascript">
	mxBasePath = 'https://jgraph.github.io/mxgraph/javascript/src';
	</script>
	<script type="text/javascript" src="https://jgraph.github.io/mxgraph/javascript/src/js/mxClient.js"></script>
	<script type="text/javascript">
	function wrangle(data) {
	var charactersMap = {};
	return data.scenes.map(function(scene) {
	return {

Hugoberry / Combinatorics.pq

Last active November 2, 2023 12:23

	let
	Source = {"B", "F", "T"},
	n = List.Count(Source),
	combinations = Number.Power(2,n)-1,

	CreateCombination = (mask as number) as list =>
	List.Select(List.Transform(List.Positions(Source), (position) =>
	if Number.BitwiseAnd(mask, Number.Power(2, position)) <> 0 then Source{position} else null),
	each _ <> null),

Hugoberry / ABF_tabular_file_types.md

Last active September 6, 2023 15:20

ABF structure of files located under a datamodel file in PBIX. #PowerBI #tabular

{Table} ({TableID}).tbl folders contains the following

#.{Table} ({TableID}).Column ({ColumnID}).dictionary file for all the HASH encoded columns
#.H${Table} ({TableID})${Column} ({ColumnID}).hidx hash index files for all the VALUE encoded columns
{PartitionID}.prt partition folder with:
- #.{Table} ({TableID).{Column} ({ColumnID}).0.idf column data storage file
- #.{Table} ({TableID).{Column} ({ColumnID}).0.idfmeta column data storage metadata file

H${Table} ({TableID})${Column} ({ColumnID})$({SystemTableID}).tbl hierarchy folders

#.H${Table} ({TableID})$Column ({ColumnID}).{ID_TO_POS|POS_TO_ID}.0.idf Column Hierarchy Position–to–Identifier or Identifier–to–PositionFile

Hugoberry / DaxModel.json

Created August 22, 2023 09:21

VPAX VertiPaq Analyzer schema and example https://jsonhero.io/j/mFFhtpW86TFC and https://jsonhero.io/j/PS9LBqBTctw6

	{
	"$schema": "https://json-schema.org/draft/2020-12/schema",
	"type": "object",
	"properties": {
	"$id": {
	"type": "string"
	},
	"DaxModelVersion": {
	"type": "string"
	},

Hugoberry / CodeWindow.html

Created July 5, 2023 10:30

Tailwindcss play link https://play.tailwindcss.com/jJ7APsi5d8 ide window prime for embedding some code

	<section class="container mx-auto mt-8 w-full max-w-none md:mt-10 lg:mt-12 xl:max-w-screen-2xl xl:px-16">
	<div class="before:bg-marketing-gradient-brand before:-z-high after:z-high safari:before:will-change-transform xl:after:border-marketing-divider relative relative col-span-12 flex select-none font-sans will-change-transform before:pointer-events-none before:absolute before:inset-0 before:hidden before:rounded-[20%] before:opacity-[0.12] before:blur-3xl after:pointer-events-none after:absolute after:inset-0 after:rounded-[inherit] md:h-[min(70vw,90vh)] md:max-h-[600px] xl:max-h-[800px] xl:rounded-xl xl:before:block xl:after:border">
	<div class="xl:bg-marketing-surface-base relative flex flex-1 flex-col overflow-hidden xl:rounded-[inherit]">
	<div class="border-marketing-divider hidden h-12 flex-none grid-cols-[1fr_auto_1fr] border-b xl:grid">
	<div class="flex items-center gap-4 pl-4">
	<div class="group flex gap-2">
	<div class="h-3 w-3 rounded-full bg-white/10"></div

Hugoberry / d2-layout-pre.sql

Last active May 23, 2023 22:02

sqlite query to surface the relationships from metadata.sqlite in PowerBI

	with cte as (SELECT
	ta.name as ta , tb.name as tb
	FROM
	'relationship' rel
	join 'table' ta on rel.Fromtableid = ta.id
	join column ca on rel.fromcolumnid = ca.id
	join 'table' tb on rel.totableid = tb.id and tb.systemflags =0
	join column cb on rel.tocolumnid = cb.id)
	select ta from cte
	union select tb from cte

Igor Cotruta Hugoberry