Profile picture
, 3 tweets, 1 min read
My Authors
Read all threads
working on a tiny website that runs SQL queries in small steps to make them easier to understand
sql-steps.netlify.com/duplicates.html
if there's a kind of query you'd like to see broken down into steps I'd love to hear what it is!
here's a LEFT JOIN query in 5 steps (though I think I maybe need one more) sql-steps.wizardzines.com/left-join.html
Missing some Tweet in this thread? You can try to force a refresh.

Enjoying this thread?

Keep Current with 🔎Julia Evans🔍

Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

Twitter may remove this content at anytime, convert it as a PDF, save and print for later use!

Try unrolling a thread yourself!

how to unroll video

1) Follow Thread Reader App on Twitter so you can easily mention us!

2) Go to a Twitter thread (series of Tweets by the same owner) and mention us with a keyword "unroll" @threadreaderapp unroll

You can practice here first or read more on our help page!

More from @b0rk see all

Profile picture
🔎Julia Evans🔍
@b0rk
put together some links to bookstores where you can buy the box set of my first 7 zines: jvns.ca/blog/2019/10/2…
A couple of the sites I link to selling the box set say they do free worldwide shipping which is cool
updated the title to clarify that this is a box set of all my free zines (since a few people were confused)
Read 5 tweets
Profile picture
🔎Julia Evans🔍
@b0rk
the steps in a left join
even more than usual these steps aren't *actually* what happens (it would be way too slow) but this is an accurate way to understand what results the join will return
(what actually usually happens is that you'll do the join on a column that's indexed so it'll be able to figure out all the matches much faster by using the index)
Read 4 tweets
Profile picture
🔎Julia Evans🔍
@b0rk
this evening I'm giving away 750 copies of my Bite Size Command Line zine to folks who can't afford the $10 it costs: gumroad.com/l/bite-size-co…
(I'm a bit behind on giving away 1 free copy of that zine for every person who's bought it so I'm catching up :))
as usual this works on the honour system, if you want the zine and can afford it, you can buy it here: wizardzines.com/zines/bite-siz…
Read 3 tweets

Related threads

Profile picture
Anthony Sanders
@IJSanders
1. Georgia (the state not the country) has had ten different constitutions. If this was a trial, we could call them an expert *state*. Get it? Anyway, today, we’re exploring the constitutional history of the Peach State. #50Weeks50Constitutions.
2. Our first stop is the baby constitution, better known as the Rules and Regulations of the Colony of Georgia which governed the revolutionary colony from April 1776 to February 1777. It also had nothing to do with bulldogs.
3. It named the people as the sole source of power & declared that the government was for their benefit. It set up a unicameral assembly which appointed the chief executive for a term of 6 months, set up a Privy Council to advise him, & established a small court system.
Read 21 tweets
Profile picture
Crypto Voices
@crypto_voices
1/ Here is the @crypto_voices 2019 Q3 release on the global monetary base. This is the only comparable money supply with Bitcoin's 21 million. #Bitcoin is currently the🔥11th largest money in the world. To dig deeper on what it all means, follow on below. This is installment #6👇
2/ Gold & silver is base money of the past. Government fiat is base money today. It comprises both physical cash… and a digital cash component! Bitcoin may be base money of the future. Before we get to the charts, it's important to clarify a few common misconceptions in money.
3/ The first is everyone looking to value Bitcoin always jumps to the "narrow" or "broad" money supplies (M1/M2/M3). This is incorrect. The reason is those money supplies represent "claims" on something else. What is that something else? Answer: the base money supply.
Read 59 tweets
Profile picture
Crypto Voices
@crypto_voices
1/ Here is the @crypto_voices 2019 Q2 release on the global monetary base. This is the only comparable money supply with Bitcoin's 21 million. #Bitcoin is currently the 🔥11th largest money in the world. To dig deeper on what it all means, follow on below. This is installment #5.
2/ Gold & silver is base money of the past. Government fiat is base money today. It comprises both physical cash… and a digital cash component! Bitcoin may be base money of the future. Before we get to the charts, it's important to clarify a few common misconceptions in money.
3/ The first is everyone looking to value Bitcoin always jumps to the "narrow" or "broad" money supplies (M1/M2/M3). This is incorrect. The reason is those money supplies represent "claims" on something else. What is that something else? Answer: the base money supply!!
Read 51 tweets
Profile picture
Crypto Voices
@crypto_voices
1/ Here is the @crypto_voices 2019 Q1 release on the global monetary base. This is the only comparable money supply with Bitcoin's 21 million. #Bitcoin is currently the 12th largest money in the world. To dig deeper on what it all means, follow on below. 👇This is installment #4.
2/ Gold & silver is base money of the past. Government fiat is base money today. It comprises both physical cash… and a digital cash component! Bitcoin may be base money of the future. Before we get to the charts, it's important to clarify a few common misconceptions in money.
3/ The first is everyone looking to value Bitcoin always jumps to the "narrow" or "broad" money supplies (M1/M2/M3). This is incorrect. The reason is those money supplies represent "claims" on something else. What is that something else? Answer: the base money supply!!
Read 50 tweets
Profile picture
Richard James
@RichJamesBits
I have reached a whole new level of #PISSEDOFF.

I didnt think such a #dark and #scary state, or level, could be reached. It may top 12-14-17's causation. It's. That. Bad. So, I've prepared a statement...

docs.google.com/document/d/1_J…

#PascoSheriff #HaveYouAllNoShame @CigarCityBeer
Dear @FBI,
I must implore you ask your colleauges in @FBITampa to help research this new level of #PISSEDOFFNESS. As locals, they may offer a special indepth knowledge of this new level I have reached. This is not fair & law enforcement must #investigate. No one deserves this.
This is my #apogee of #Pissedoffness.
If #motherfuckers & #tears werent a noticable level.
If #HUSH or #INTIMIDATION tactics being deployed didnt strike a chord.
If #EVIDENCE, PROOF, or 30k Bonds didnt #WOW YOU.
If posting mom with no shred of investigatable value wasnt enough...
Read 463 tweets
Profile picture
michael_nielsen
@michael_nielsen
Open access is often argued about in the abstract. I want to talk about a specific case study where I have detailed data - usage patterns for my (open access) online book/monograph "Neural Networks and Deep Learning" neuralnetworksanddeeplearning.com/chap1.html
In so doing I'm going to violate conventional modesty norms. I've internalized those norms, so feel awkward about it (thus this tweet). I also think those norms often really should be ignored.
I released the book chapter-by-chapter from November 2013 until
completion in July 2015. It's received 14 million page views from 3.5
million users.
Read 26 tweets

Trending hashtags

#Multimedia #JustSaying #Music #HUSH #dharma #SREcon #CLASSY #Achara #crimescene #RICO #ALF #backdoor #XenophobiaAttack #SquadGoals #codabr18 #notes #COVERUP #HaveYouAllNoShame #DIRTYCOPS #PeakTV #EveningTroll #Unmissable #Check #bankrecords #LargeGroups
Follow Us on Twitter!

Did Thread Reader help you today?

Support us! We are indie developers!

This site is made by just three indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!