Sunny R. Juneja sunnyrjuneja

## types.markdown

      
              1 file
            
          
              53 forks
            
          
              81 comments
            
          
              966 stars
            
          
                garybernhardt
                / types.markdown
            
            
              Last active
              September 8, 2023 21:02
            
          
    This document has moved!

It's now here, in The Programmer's Compendium.
The content is the same as before, but being part of the compendium means that it's actively maintained.

  
## dc_2017_biblio.md

      
              1 file
            
          
              6 forks
            
          
              5 comments
            
          
              59 stars
            
          
                BaseCase
                / dc_2017_biblio.md
            
            
              Last active
              January 23, 2020 05:13
            
              
                List of resources recommended or mentioned by the speakers at Deconstruct 2017
              
          
    Deconstruct 2017 Bibliography

Here are all of the resources mentioned by Deconstruct 2017 speakers, along with who recommended what. Please post a comment if I missed something or have an error!
DC 2017 Speakers' Choice Gold Medalist


Seeing Like a State by James Scott

Books


Public Opinion by Walter Lippmann (Evan Czaplicki)
A Pattern Language by Christopher Alexander (Brian Marick)
Domain Driven Design by Eric Evans (Brian Marick)


## neat postgres topics.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                abevoelker
                / neat postgres topics.md
            
            
              Last active
              May 30, 2017 18:16
            
          
Constraints - super important for ensuring data integrity (bad data can't get into the DB)

UNIQUE indexes to ensure a record is unique on one or more column values
CHECK constraints allow some basic logic you can use (https://www.postgresql.org/docs/current/static/ddl-constraints.html)
FOREIGN KEY (FK)'s - very important for ensuring referential integrity. Lets the database knows about relations between tables, and what to do if a record is deleted or updated (how related tables should change) - e.g. should related records be deleted (ON DELETE CASCADE)
Anything more complicated than the above, you'll need to write a TRIGGER (https://www.postgresql.org/docs/current/static/sql-createtrigger.html)

Learning/using PL/pgSQL will be very important here (https://www.postgresql.org/docs/9.6/static/plpgsql.html). Although you can write triggers in other languages w/ extensions, such as Python or JavaScript, but usually you only do that if you need a specific library or something.


Indexes - i


## arel_cheatsheet_on_steroids.md

      
              1 file
            
          
              29 forks
            
          
              1 comment
            
          
              176 stars
            
          
                ProGM
                / arel_cheatsheet_on_steroids.md
            
            
              Last active
              April 19, 2024 04:06
            
              
                Arel cheatsheet on Steroids
              
          
    Arel Cheatsheet on Steroids

A (more) complete cheatsheet for Arel, including NamedFunction functions, raw SQL and window functions.
Tables

posts = Arel::Table.new(:posts)
posts = Post.arel_table # ActiveRecord
Table alias


## Dockerfile
FROM ruby:3.0-alpine

RUN apk add --no-cache --update \
ack \
bash \
build-base \
curl \
git \
htop \
less \
	FROM ruby:3.0-alpine

	RUN apk add --no-cache --update \
	ack \
	bash \
	build-base \
	curl \
	git \
	htop \
	less \