Profile picture
, 3 tweets, 2 min read
My Authors
Read all threads
Hiring process for @AdHocTeam is really interesting: pick some assignments from homework.adhoc.team/assignments/ (depending on your role), your submissions are then anonymously reviewed by members of the team
The assignments are extremely well designed - here's one for testing JavaScript/API knowledge homework.adhoc.team/fetch/ - and here's one testing SRE skills building Docker containers and configuring nginx homework.adhoc.team/containerize/
They wrote about why they do this here: it's to allow them to hire for their remote-first team without needing to conduct in-person technical interviews adhocteam.us/2018/02/26/why…
Missing some Tweet in this thread? You can try to force a refresh.

Keep Current with Simon Willison

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 @simonw see all

Profile picture
Simon Willison
@simonw
@zzxiv @andrewparker @datasetteproj That was one of my first use-cases for twitter-to-sqlite! I have it running on a cron every ten minutes that fetches the most recent 50 tweets that I've favourited

*/10 * * * * run-one twitter-to-sqlite favorites /home/simon/twitter.db -a /home/simon/auth.json --stop_after=50
@zzxiv @andrewparker @datasetteproj Then I can use Datasette to search my favorites - I have 23,993 favorited tweets in the index now
@zzxiv @andrewparker @datasetteproj I'm not yet fetching the content of the linked articles, but I've thought about doing that - I could have a separate DB table with URLs and article contents which is also setup for full-text search pretty easily
Read 5 tweets
Profile picture
Simon Willison
@simonw
SQL is a better API language than GraphQL. Convince me otherwise!
To counter some obvious arguments...

You don't have to expose your entire schema, instead expose carefully designed SQL views (so you can refactor your tables without breaking your API)

Read-only, obviously!

Use time limits to cut off expensive queries (GraphQL needs this too)
(I haven't quite convinced myself yet that SQL is a great language for update APIs, but I'm working on it)
Read 13 tweets
Profile picture
Simon Willison
@simonw
It's crazy that providing URLs that can be used to link to content is somehow an advanced technique in this weird SPA-infested world we live in these days
Like the ability to link to things is a stretch goal now
We still get to make fun of help pages that tell you to "go to menu X, then option Y, then scroll to Z" rather than just linking to the thing they're talking about, right?
Read 7 tweets

Embed code for your website

×
Follow Us on Twitter!

Did Thread Reader help you today?

Support us! We are indie developers!

This site is made by just two 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!