.devcontainer/devcontainer.json DELETED
@@ -1,32 +0,0 @@
1
- {
2
- // This file is only used in Codespaces. If you are developing locally, you can remove the .devcontainer directory without consequences
3
-
4
- "image": "mcr.microsoft.com/devcontainers/javascript-node:0-18-bullseye",
5
-
6
- "hostRequirements": {
7
- "cpus": 4,
8
- "memory": "4gb",
9
- "storage": "32gb"
10
- },
11
-
12
- // Use 'postCreateCommand' to run commands after the container is created.
13
- "postCreateCommand": "mkdir .evidence/template && echo '{\"database\":\"duckdb\",\"credentials\":{\"filename\":\"needful_things.duckdb\",\"gitignoreDuckdb\":null}}' > .evidence/template/evidence.settings.json && rm .vscode/extensions.json && rmdir .vscode",
14
- // Configure tool-specific properties
15
- "customizations": {
16
- "vscode": {
17
- "extensions": [
18
- // "GitHub.codespaces",
19
- "evidence.evidence-vscode",
20
- "svelte.svelte-vscode"
21
- ]
22
- },
23
- "codespaces": {
24
- "openFiles": [
25
- "pages/index.md"
26
- ]
27
- }
28
- }
29
- // "forwardPorts": [3000]
30
- }
31
- // For format details, see https://aka.ms/devcontainer.json. For config options, see the
32
- // README at: https://github.com/devcontainers/templates/tree/main/src/python
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
.evidence/customization/.profile.json DELETED
@@ -1 +0,0 @@
1
- {"anonymousId":"29ab84d2-7ae9-4bd3-a7ef-c4344f4deb66","traits":{"projectCreated":"2024-11-06T20:50:46.832Z"}}
 
 
.evidence/customization/custom-formatting.json DELETED
@@ -1,4 +0,0 @@
1
- {
2
- "version": "1.0",
3
- "customFormats": []
4
- }
 
 
 
 
 
.gitattributes CHANGED
@@ -34,4 +34,3 @@ saved_model/**/* filter=lfs diff=lfs merge=lfs -text
34
  *.zip filter=lfs diff=lfs merge=lfs -text
35
  *.zst filter=lfs diff=lfs merge=lfs -text
36
  *tfevents* filter=lfs diff=lfs merge=lfs -text
37
- *.duckdb filter=lfs diff=lfs merge=lfs -text
 
34
  *.zip filter=lfs diff=lfs merge=lfs -text
35
  *.zst filter=lfs diff=lfs merge=lfs -text
36
  *tfevents* filter=lfs diff=lfs merge=lfs -text
 
.github/workflows/azure-static-web-apps-thankful-hill-01fbff51e.yml DELETED
@@ -1,59 +0,0 @@
1
- name: Azure Static Web Apps CI/CD
2
-
3
- on:
4
- push:
5
- branches:
6
- - main
7
- pull_request:
8
- types: [opened, synchronize, reopened, closed]
9
- branches:
10
- - main
11
-
12
- jobs:
13
- build_and_deploy_job:
14
- if: github.event_name == 'push' || (github.event_name == 'pull_request' && github.event.action != 'closed')
15
- runs-on: ubuntu-latest
16
- name: Build and Deploy Job
17
- permissions:
18
- id-token: write
19
- contents: read
20
- steps:
21
- - uses: actions/checkout@v3
22
- with:
23
- submodules: true
24
- lfs: false
25
- - name: Install OIDC Client from Core Package
26
- run: npm install @actions/core@1.6.0 @actions/http-client
27
- - name: Get Id Token
28
- uses: actions/github-script@v6
29
- id: idtoken
30
- with:
31
- script: |
32
- const coredemo = require('@actions/core')
33
- return await coredemo.getIDToken()
34
- result-encoding: string
35
- - name: Build And Deploy
36
- id: builddeploy
37
- uses: Azure/static-web-apps-deploy@v1
38
- with:
39
- azure_static_web_apps_api_token: ${{ secrets.AZURE_STATIC_WEB_APPS_API_TOKEN_THANKFUL_HILL_01FBFF51E }}
40
- action: "upload"
41
- ###### Repository/Build Configurations - These values can be configured to match your app requirements. ######
42
- # For more information regarding Static Web App workflow configurations, please visit: https://aka.ms/swaworkflowconfig
43
- app_location: "/" # App source code path
44
- api_location: "" # Api source code path - optional
45
- output_location: "/build" # Built app content directory - optional
46
- app_build_command: "npm run sources && npm run build"
47
- github_id_token: ${{ steps.idtoken.outputs.result }}
48
- ###### End of Repository/Build Configurations ######
49
-
50
- close_pull_request_job:
51
- if: github.event_name == 'pull_request' && github.event.action == 'closed'
52
- runs-on: ubuntu-latest
53
- name: Close Pull Request Job
54
- steps:
55
- - name: Close Pull Request
56
- id: closepullrequest
57
- uses: Azure/static-web-apps-deploy@v1
58
- with:
59
- action: "close"
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
.gitignore DELETED
@@ -1,8 +0,0 @@
1
- .evidence/template
2
- .svelte-kit
3
- build
4
- node_modules
5
- .DS_Store
6
- static/data
7
- *.options.yaml
8
- .vscode/settings.json
 
 
 
 
 
 
 
 
 
.npmrc DELETED
@@ -1,3 +0,0 @@
1
- loglevel=error
2
- audit=false
3
- fund=false
 
 
 
 
.vscode/extensions.json DELETED
@@ -1,5 +0,0 @@
1
- {
2
- "recommendations": [
3
- "evidence.evidence-vscode"
4
- ]
5
- }
 
 
 
 
 
 
README.md DELETED
@@ -1,56 +0,0 @@
1
- # Evidence Template Project
2
-
3
- Welcome to Evidence. Use this project template to get started.
4
-
5
- ## Get Started from VS Code
6
-
7
- The easiest way to get started is using the [VS Code Extension](https://marketplace.visualstudio.com/items?itemName=evidence-dev.evidence), which copies this template.
8
-
9
- 1. Install the extension from the VS Code Marketplace
10
- 2. Open the Command Palette (Ctrl/Cmd + Shift + P) and enter `Evidence: New Evidence Project`
11
- 3. Click `Start Evidence` in the bottom status bar
12
-
13
- ## Get Started using the CLI
14
-
15
- ```bash
16
- npx degit evidence-dev/template my-project
17
- cd my-project
18
- npm install
19
- npm run sources
20
- npm run dev
21
- ```
22
-
23
- Check out the docs for [alternative install methods](https://docs.evidence.dev/getting-started/install-evidence) including Docker, Github Codespaces, and alongside dbt.
24
-
25
-
26
- ## Codespaces
27
-
28
- If you are using this template in Codespaces, click the `Start Evidence` button in the bottom status bar.
29
-
30
- Alternatively, use the following commands to get started:
31
-
32
- ```bash
33
- npm install
34
- npm run sources
35
- npm run dev -- --host 0.0.0.0
36
- ```
37
-
38
- See [the CLI docs](https://docs.evidence.dev/cli/) for more command information.
39
-
40
- **Note:** Codespaces is much faster on the Desktop app. After the Codespace has booted, select the hamburger menu → Open in VS Code Desktop.
41
-
42
- ## Connection Issues
43
-
44
- If you see `✗ orders_by_month Missing database credentials`, you need to add the connection to the demo database:
45
-
46
- 1. Open the settings menu at [localhost:3000/settings](http://localhost:3000/settings)
47
- 2. select `DuckDB`
48
- 3. enter `needful_things`
49
- 4. select `.duckdb` and save
50
-
51
- ## Learning More
52
-
53
- - [Docs](https://docs.evidence.dev/)
54
- - [Github](https://github.com/evidence-dev/evidence)
55
- - [Slack Community](https://slack.evidence.dev/)
56
- - [Evidence Home Page](https://www.evidence.dev)
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
degit.json DELETED
@@ -1,6 +0,0 @@
1
- [
2
- {
3
- "action": "remove",
4
- "files": [".devcontainer"]
5
- }
6
- ]
 
 
 
 
 
 
 
evidence.plugins.yaml DELETED
@@ -1,41 +0,0 @@
1
-
2
- components:
3
- # This loads all of evidence's core charts and UI components
4
- # You probably don't want to edit this dependency unless you know what you are doing
5
- "@evidence-dev/core-components": {}
6
-
7
- # Loading a plugin:
8
- # your-component-plugin: {}
9
- #
10
- # Adding aliases:
11
- # your-component-plugin:
12
- # aliases:
13
- # SomeLongComponent: Alias
14
- #
15
- # Adding overrides:
16
- # your-component-plugin:
17
- # aliases:
18
- # SomeLongChartComponent: BarChart
19
- # overrides:
20
- # - BarChart
21
- #
22
- # Adding normal Svelte component library:
23
- # your-svelte-component-library:
24
- # provides:
25
- # - SomeComponent
26
- # - SomeOtherComponent
27
- #
28
- # For more info: https://docs.evidence.dev/plugins/using-plugins/
29
- datasources:
30
- # You can add additional datasources here by adding npm packages.
31
- # Make to also add them to `package.json`.
32
- "@evidence-dev/bigquery": { }
33
- "@evidence-dev/csv": { }
34
- "@evidence-dev/databricks": { }
35
- "@evidence-dev/duckdb": { }
36
- "@evidence-dev/mssql": { }
37
- "@evidence-dev/mysql": { }
38
- "@evidence-dev/postgres": { }
39
- "@evidence-dev/snowflake": { }
40
- "@evidence-dev/sqlite": { }
41
- "@evidence-dev/trino": { }
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
package-lock.json DELETED
The diff for this file is too large to render. See raw diff
 
package.json DELETED
@@ -1,36 +0,0 @@
1
- {
2
- "name": "my-evidence-project",
3
- "version": "0.0.1",
4
- "scripts": {
5
- "build": "evidence build",
6
- "build:strict": "evidence build:strict",
7
- "dev": "evidence dev --open /",
8
- "test": "evidence build",
9
- "sources": "evidence sources",
10
- "preview": "evidence preview"
11
- },
12
- "engines": {
13
- "npm": ">=7.0.0",
14
- "node": ">=18.0.0"
15
- },
16
- "type": "module",
17
- "dependencies": {
18
- "@evidence-dev/bigquery": "^2.0.8",
19
- "@evidence-dev/core-components": "^4.9.0",
20
- "@evidence-dev/csv": "^1.0.13",
21
- "@evidence-dev/databricks": "^1.0.7",
22
- "@evidence-dev/duckdb": "^1.0.12",
23
- "@evidence-dev/evidence": "^39.2.1",
24
- "@evidence-dev/mssql": "^1.1.1",
25
- "@evidence-dev/mysql": "^1.1.3",
26
- "@evidence-dev/postgres": "^1.0.6",
27
- "@evidence-dev/snowflake": "^1.2.1",
28
- "@evidence-dev/sqlite": "^2.0.6",
29
- "@evidence-dev/trino": "^1.0.8"
30
- },
31
- "overrides": {
32
- "jsonwebtoken": "9.0.0",
33
- "trim@<0.0.3": ">0.0.3",
34
- "sqlite3": "5.1.5"
35
- }
36
- }
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
pages/+layout.svelte DELETED
@@ -1,10 +0,0 @@
1
- <script>
2
- import '@evidence-dev/tailwind/fonts.css';
3
- import '../app.css';
4
- import { EvidenceDefaultLayout } from '@evidence-dev/core-components';
5
- export let data;
6
- </script>
7
-
8
- <EvidenceDefaultLayout {data} hideBreadcrumbs hideSidebar githubRepo=https://github.com/archiewood/archie-evidence>
9
- <slot slot="content" />
10
- </EvidenceDefaultLayout>
 
 
 
 
 
 
 
 
 
 
 
pages/index.md DELETED
@@ -1,137 +0,0 @@
1
- ---
2
- title: Archie Sarre Wood
3
- hide_title: true
4
- ---
5
-
6
- <img src="https://avatars.githubusercontent.com/archiewood" alt="Archie" class="rounded-full w-24 h-24 mb-4">
7
-
8
- ## Archie Sarre Wood
9
-
10
- <div style="display: flex; flex-direction: row; gap: 10px;">
11
- <a href="https://www.linkedin.com/in/archiesarrewood/"><img src="https://img.shields.io/badge/-0077B5?style=for-the-badge&logo=linkedin&logoColor=white" alt="LinkedIn"></a>
12
- <a href="https://x.com/archieemwood"><img src="https://img.shields.io/badge/-000000?style=for-the-badge&logo=x&logoColor=white" alt="Twitter"></a>
13
- <a href="https://bsky.app/profile/archie.sarrewood.com"><img src="https://img.shields.io/badge/-00A0DC?style=for-the-badge&logo=bluesky&logoColor=white" alt="Bluesky"></a>
14
- <a href="https://github.com/archiewood"><img src="https://img.shields.io/badge/-181717?style=for-the-badge&logo=github&logoColor=white" alt="GitHub"></a>
15
- </div>
16
-
17
- <LineBreak lines=1/>
18
-
19
- Building and growing developer tools. Working on [Evidence](https://evidence.dev), an open-source business intelligence tool.
20
-
21
- ## Projects
22
-
23
-
24
- ```sql projects
25
- select
26
- 'DuckDB GSheets' as name,
27
- 'https://duckdb-gsheets.com/' as url,
28
- 'https://github.com/evidence-dev/duckdb_gsheets' as source_code,
29
- 'Connect Google Sheets to DuckDB' as description,
30
- 87 as stars
31
- union all select
32
- 'DuckDB SQLTools',
33
- 'https://github.com/evidence-dev/sqltools-duckdb-driver',
34
- 'https://github.com/evidence-dev/sqltools-duckdb-driver',
35
- 'SQLTools extension for DuckDB',
36
- 20 as stars
37
- union all select
38
- 'BigQuery SQLTools',
39
- 'https://github.com/evidence-dev/sqltools-bigquery-driver',
40
- 'https://github.com/evidence-dev/sqltools-bigquery-driver',
41
- 'SQLTools extension for BigQuery',
42
- 40 as stars
43
- union all select
44
- 'GoSQL',
45
- 'https://github.com/archiewood/gosql',
46
- 'https://github.com/archiewood/gosql',
47
- 'A simple SQL database implemented in Go',
48
- 150 as stars
49
- union all select
50
- 'Pure CSS Site',
51
- 'https://pure-css-site.netlify.app/',
52
- 'https://github.com/archiewood/pure-css-site/blob/master/index.css',
53
- 'A site built with only CSS',
54
- 16 as stars
55
- union all select
56
- 'Baby Tracker',
57
- 'https://baby-tracker.evidence.app/',
58
- 'https://github.com/archiewood/baby-tracker',
59
- 'A data viz app to track baby''s feed and sleep',
60
- 10 as stars
61
- ```
62
-
63
- <DataTable data={projects} link=url>
64
- <Column id=name/>
65
- <Column id=description/>
66
- <Column id=stars/>
67
- <Column id=source_code contentType=link linkLabel="GitHub &rarr;"/>
68
- </DataTable>
69
-
70
- <BarChart
71
- data={projects}
72
- title="GitHub Stars by Project"
73
- x=name
74
- y=stars
75
- swapXY
76
- yAxisLabels=false
77
- yGridlines=false
78
- labels=true
79
- />
80
-
81
-
82
-
83
- ## Experience
84
-
85
- ### Community and Growth @ Evidence
86
- *Apr 2022 - Present | Toronto / London*
87
-
88
- Leading community engagement and growth initiatives for Evidence, an open-source business intelligence platform that enables code-driven analytics. Responsibilities span:
89
- - Technical documentation and developer experience
90
- - Community management (GitHub Issues & PRs)
91
- - Content creation (Blog, Social Media)
92
- - Developer relations and conference speaking
93
- - Product strategy and development
94
-
95
- ### BI Team Manager & Chief of Staff @ Patch Plants
96
- *Jan 2021 - Sep 2021 | London, UK*
97
-
98
- Led data strategy and operations for fast-growing e-commerce startup (194% growth in 2020):
99
- - Managed BI stack (Fivetran, Snowflake, dbt, Looker) and data team
100
- - Executive team member driving strategic planning and OKRs
101
- - Led special projects including geographic expansion and Brexit planning
102
- - Board observer
103
-
104
- ### Strategy Manager @ Patch Plants
105
- *Aug 2019 - Dec 2020 | London, UK*
106
-
107
- - Led £2.4m equity crowdfunding round with 3,000+ investors
108
- - Drove initiatives improving order contribution by 34%
109
- - Managed UK-wide expansion project
110
-
111
- ### Consultant @ OC&C Strategy Consultants
112
- *2016 - 2019 | London, UK*
113
-
114
- Led strategy projects across retail, consumer goods, and B2B services:
115
- - Customer segmentation and market sizing
116
- - Operational transformation
117
- - Commercial due diligence
118
- - Team leadership of 2-5 consultants
119
-
120
-
121
-
122
- ## Education
123
-
124
- **University of Cambridge**
125
- - MSci Physics (First Class Honours) | 2014 - 2015
126
- - BA Natural Sciences - Physics (First Class Honours) | 2011 - 2014
127
-
128
- ## Awards & Achievements
129
-
130
- - Cambridge University Lightweight Rowing Blue (2015)
131
- - British Physics Olympiad Gold Award
132
-
133
- ## Volunteer Work
134
-
135
- **Physics Tutor | The Access Project**
136
- *2020 - 2022*
137
- Tutoring Physics to students from disadvantaged backgrounds
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
sources/needful_things/connection.yaml DELETED
@@ -1,5 +0,0 @@
1
- # This file was automatically generated
2
- name: needful_things
3
- type: duckdb
4
- options:
5
- filename: needful_things.duckdb
 
 
 
 
 
 
sources/needful_things/needful_things.duckdb DELETED
@@ -1,3 +0,0 @@
1
- version https://git-lfs.github.com/spec/v1
2
- oid sha256:e7b039bbf18e5d003cf66f1397f76c8bde0384336039d25c3944cf84735b5c3d
3
- size 1323008
 
 
 
 
sources/needful_things/orders.sql DELETED
@@ -1 +0,0 @@
1
- select * from orders