Commits

Breadcrumbs

History for

onmain

User selector

All users

All time

Commit History

Commits on Feb 9, 2024

• refactor: generalize file inclusion

  gvwilson

  committed
  34a4459

  Copy full SHA for 34a4459

Commits on Feb 8, 2024

• refactor: get some of the SQL to pass SQLFluff checks

  gvwilson

  committed
  52dfb69

  Copy full SHA for 52dfb69

• feat: explain dot-command import of CSV data

  Show description for a1aa5c2
  gvwilson

  committed
  a1aa5c2

  Copy full SHA for a1aa5c2

Commits on Feb 7, 2024

• fix: reorganize primary key description

  Show description for 27abf5a
  gvwilson

  committed
  27abf5a

  Copy full SHA for 27abf5a

• fix: correct mistake in description of cross join vs. full outer join

  Show description for c71b8de
  gvwilson

  committed
  c71b8de

  Copy full SHA for c71b8de

Commits on Feb 6, 2024

• feat: show 'count distinct'

  Show description for 51803ad
  gvwilson

  committed
  51803ad

  Copy full SHA for 51803ad

• Merge branch 'main' of github.com:gvwilson/sql-tutorial

  gvwilson

  committed
  1b6584f

  Copy full SHA for 1b6584f

• fix: show 'select' used in blob example

  Show description for 1481ed0
  gvwilson

  committed
  1481ed0

  Copy full SHA for 1481ed0

• fix: populating work/job database at appropriate times

  gvwilson

  committed
  0f3d316

  Copy full SHA for 0f3d316

Commits on Feb 4, 2024

• fix: linting SQL with sqlfluff

  gvwilson

  committed
  8e59be2

  Copy full SHA for 8e59be2

Commits on Feb 3, 2024

• fix: switching to github.css highlighting to fix contrast errors

  gvwilson

  committed
  7edf5e7

  Copy full SHA for 7edf5e7

• refactor: clean up linting

  Show description for 269baef
  gvwilson

  committed
  269baef

  Copy full SHA for 269baef

• feat: explain upsert

  gvwilson

  committed
  a457e71

  Copy full SHA for a457e71

• feat: explain count(*) vs count(column)

  Show description for f7660a2
  gvwilson

  committed
  f7660a2

  Copy full SHA for f7660a2

• feat: explain indexes

  Show description for 08a2d98
  gvwilson

  committed
  08a2d98

  Copy full SHA for 08a2d98

• fix: use better table aliases and add explanation for comparison within groups

  Show description for 8ed60b1
  gvwilson

  committed
  8ed60b1

  Copy full SHA for 8ed60b1

• fix: explain that autoincrement doesn't prevent duplicate value

  Show description for 1ce86c0
  gvwilson

  committed
  1ce86c0

  Copy full SHA for 1ce86c0

• refactor: simplify Python start/end block markers

  gvwilson

  committed
  b9576a4

  Copy full SHA for b9576a4

Commits on Feb 2, 2024

• fix: improving linting

  Show description for 8757a6d
  gvwilson

  committed
  8757a6d

  Copy full SHA for 8757a6d

• fix: modify queries to show paging more clearly

  Show description for 3d360d9
  gvwilson

  committed
  3d360d9

  Copy full SHA for 3d360d9

Commits on Feb 1, 2024

• refactor: reorganize and document content

  gvwilson

  committed
  81e037a

  Copy full SHA for 81e037a

Loading