gvwilson/sql-tutorial issues and pull requests

#50 - - Added makefile for generating .out files for psql

Pull Request - State: closed - Opened by kitsiosk 7 months ago

#49 - question: one page or many?

Issue - State: closed - Opened by gvwilson 8 months ago - 6 comments
Labels: help-wanted, discuss

#48 - rewrite Makefile to reflect restructuring

Issue - State: closed - Opened by gvwilson 8 months ago
Labels: in-infrastructure, request-change

#47 - Added instructions on how to setup PostgreSQL in macOS

Pull Request - State: closed - Opened by kitsiosk 9 months ago - 3 comments

#46 - Missing content

Issue - State: closed - Opened by kejcao 9 months ago
Labels: in-content, report-bug

#45 - Interactive code examples

Issue - State: closed - Opened by nalgeon 10 months ago - 2 comments
Labels: in-infrastructure, discuss

#44 - Clarify table names

Issue - State: closed - Opened by zkdan 10 months ago
Labels: in-content, request-change

#43 - Clarifying admin commands

Pull Request - State: closed - Opened by zkdan 10 months ago
Labels: in-content, contribute-change

#42 - Adding quit command for sqlite

Pull Request - State: closed - Opened by zkdan 10 months ago
Labels: in-content, contribute-change

#41 - changing data to db

Pull Request - State: closed - Opened by zkdan 10 months ago - 1 comment
Labels: in-content, contribute-change

#40 - Change data to db

Pull Request - State: closed - Opened by zkdan 10 months ago

#39 - addressed issues 36, 37, 38

Pull Request - State: closed - Opened by 2x2xplz 10 months ago - 1 comment
Labels: in-content, contribute-change

#38 - progress might be miscalculated?

Issue - State: closed - Opened by 2x2xplz 10 months ago
Labels: in-content, request-change, discuss

#37 - generated series too short

Issue - State: closed - Opened by 2x2xplz 10 months ago - 1 comment
Labels: in-content, report-bug, request-change

#36 - unspecified null handling

Issue - State: closed - Opened by 2x2xplz 10 months ago - 1 comment
Labels: in-content, report-bug, request-change

#35 - 53. Intersection

Issue - State: closed - Opened by KipperBush 10 months ago - 1 comment
Labels: in-content, request-change

#34 - Fix Typo in Update Rows (row(w) -> row(s))

Pull Request - State: closed - Opened by conor-f 10 months ago - 2 comments

#33 - Show ibis-framework example

Issue - State: closed - Opened by cpcloud 10 months ago - 3 comments

#32 - Example 22 arbitrary choice in aggregation is very specific to sqlite

Issue - State: closed - Opened by cpcloud 10 months ago - 1 comment
Labels: in-content, request-change

#31 - Example 31 statement about full outer joins being the same as cross joins is incorrect

Issue - State: closed - Opened by cpcloud 10 months ago
Labels: in-content, report-bug

#30 - blob section is missing the SELECT query

Issue - State: closed - Opened by simonw 10 months ago - 2 comments

#29 - docs: typo

Pull Request - State: closed - Opened by dpprdan 10 months ago

#28 - introduce & utilize duckdb

Issue - State: open - Opened by jenna-jordan 10 months ago - 7 comments
Labels: in-content, request-addition, help-wanted

#27 - Removing primary key from 040

Issue - State: closed - Opened by defuneste 10 months ago - 3 comments
Labels: in-content, request-change, discuss

#26 - count distinct

Issue - State: closed - Opened by Hasnabruzzn 10 months ago - 3 comments
Labels: in-content, request-change, discuss

#25 - feat: configure sqlfluff to check SQL code samples

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: in-infrastructure, request-addition, help-wanted

#24 - feat: add GIS examples in appendix

Issue - State: open - Opened by gvwilson 10 months ago
Labels: in-content, request-addition, help-wanted

#23 - fix: improve keyword detection

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: in-infrastructure, report-bug, help-wanted

#22 - feat: explain .command data import from CSV

Issue - State: closed - Opened by APHawkes 10 months ago - 2 comments
Labels: in-content, request-change

#21 - feat: replace use of head with custom script to add ellipses

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: in-infrastructure, request-change

#20 - feat: create downloadable starting point

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: in-infrastructure, request-addition

#19 - feat: show examples of permissions in PostgreSQL

Issue - State: closed - Opened by gvwilson 10 months ago - 1 comment
Labels: in-content, request-addition

#18 - feat: explain difference between database and database manager

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: request-addition

#17 - reconcile missing/unexpected SQL scripts

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: in-infrastructure, request-change

#16 - feat: use file inclusions + Makefile to regenerate/check examples

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: in-infrastructure, request-change

#15 - refactor: move scripts into subsidiary files

Pull Request - State: closed - Opened by gvwilson 10 months ago
Labels: in-infrastructure, contribute-change

#14 - feat: example of calculating weighted quantiles

Issue - State: open - Opened by zaneselvans 10 months ago
Labels: in-content, request-addition

#13 - feedback: add SQL best practices

Issue - State: closed - Opened by MSlobody 10 months ago
Labels: in-content, request-addition

#12 - feat: creating and using indexes

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: in-content, request-addition

#11 - feat: explain upsert

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: in-content, request-addition

#10 - feat: use "explain query plan" instead of "explain"

Issue - State: closed - Opened by SamHames 10 months ago - 1 comment
Labels: in-content, request-change

#9 - feat: explain aliases can be used for tables

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: in-content, request-change

#8 - feat: explain different possible behaviors of count()

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: in-content, request-addition

#7 - feat: apply condition to update and delete

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: in-content, request-change

#6 - feat: confusing aliases for table in comparison of individual and aggregate values

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: in-content, request-change

#5 - feat: autoincrement and primary key does not prevent person being duplicated

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: in-content, request-addition

#4 - refactor: cover inner and outer joins before cross join

Issue - State: closed - Opened by gvwilson 10 months ago - 1 comment
Labels: in-content, request-change

#3 - feat: modify query to show paging more clearly

Issue - State: closed - Opened by gvwilson 10 months ago
Labels: in-content, request-change

#2 - Fix typo typo

Pull Request - State: closed - Opened by rkern 10 months ago

#1 - feat: add ways to interact with the database from tidyverse / pandas / polars

Issue - State: closed - Opened by tomsing1 10 months ago
Labels: in-content, request-addition

GitHub / gvwilson/sql-tutorial issues and pull requests