Profile picture
Simon Willison
@simonw
, 7 tweets, 3 min read Read on Twitter
Slides from my Datasette presentation at #csvconf (@CSVConference) this afternoon speakerdeck.com/simon/datasette
Here's the (super-ugly) code I used to scrape the CSVConf schedule and create a database out of it nbviewer.jupyter.org/gist/simonw/1d…
... which I deployed to Google Cloud Run, allowing for this delightful SQL query to show now-and-next information csvconf-j7hipcg4aq-uc.a.run.app/csvconf-5ae783…
... which I used to build this Glitch app glitch.com/~csvconf-now-a…
... which will probably break now that the conference is over! Aah well, it was fun while it lasted - screenshots here:
Erk that was the wrong link! I meant this one speakerdeck.com/simon/datasett…
@speakerdeck bug report for you: I accidentally set the title of my talk to a title I had used for one last year and it reused the same URL for my new presentation!
Missing some Tweet in this thread?
You can try to force a refresh.

Like this thread? Get email updates or save it to PDF!

Subscribe to Simon Willison
Profile picture

Get real-time email alerts when new unrolls are available from this author!

This content 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!

Related hashtags

#csvconf

More from @simonw see all

Profile picture
Simon Willison
@simonw
There is so much great #SpiderVerse behind the scenes content on Twitter if you start following some of the artists who created the film
And the sound artists too
And here's the screenplay in full!
Read 28 tweets
Profile picture
Simon Willison
@simonw
This is one of the main benefits I see of a "service" abstraction - be it a networked microservice or just a class that encapsulates some core business logic. A lightweight layer for reading and writing the DB.
A big reason this is useful is that in any large system those updates are likely to be denormalized in some way - a write to the DB may also need to also invalidate a cache or refresh a separate search index. So all updates should share a codepath.
And for reads in a large system speed is crucial. It's much easier to avoid pathological query performance if reads are all made through some kind of getPostsByIDs method that knows how to efficiently batch queries and uses optimizations like Django's select_ and prefetch_related
Read 4 tweets
Profile picture
Simon Willison
@simonw
In important London news: 5 (five!) of the 43 surviving Imperial Fabergé Eggs are on display at two separate temporary exhibitions right now! You should totally go and see them.
The Science Museum's exhibition "The Last Tsar: Blood and Revolution" runs until 24th March 2019 and includes the Imperial Steel Easter Egg (one of my favourite eggs) and the Imperial Red Cross Fabergé Easter Egg
And across town at the Queen's Gallery the Royal Collection exhibition "Russia, Royalty & the Romanovs" has all three of the Queen's Fabergé eggs on public display! royalcollection.org.uk/collection/the…
Read 3 tweets

Related threads

Profile picture
Josh Constine
@JoshConstine
Here's a running list of all the big Facebook F8 announcements from Meet New Friends, to testing hiding Instagram Likes, to opening Dating to friends. 1/
Facebook hopes to revitalize its aging social graph by helping you meet new friends, not just reconnect with old ones techcrunch.com/2019/04/30/fac… 2/ tip @Techmeme
Instagram will try hiding Like counts from not only viewers but a post's creator too, starting in Canada. A huge step forward for decreasing envy & the popularity contest techcrunch.com/2019/04/30/ins…
Read 13 tweets
Profile picture
=Orange=
@LynwoodTalks
Here's a really good article from Apr. 3, talking about what actually went on behind the scenes and the two faces of @realDonaldTrump.

"But I couldn't get the press to accept it. They were off on their own toot."
Attorney John Dowd

Thank you, @ByronYork! washingtonexaminer.com/opinion/column…
Here's the full text:

"What was President Trump up to when he publicly attacked the work of Trump-Russia special counsel Robert Mueller?

What was going on behind the scenes between the White House and Mueller's office?
Was there cooperation?

A fight over privilege?

And just how mad was Trump at Attorney General Jeff Sessions and deputy Rod Rosenstein when the special counsel was appointed?
Read 64 tweets
Profile picture
Brian Cates
@drawandstrike
I'd say 'pray for him' but it's far too late.
When Jeff Sessions revealed in a letter to the Congress in March 2018 that DOJ Inspector General Michael E. Horowitz had been *assigned US Attorneys to work in concert with him* the real meaning of what this meant went right over the heads of people who should have seen it.
The *expected* process is that the IG does his investigation, *shows those results to the AG*, and then makes his report public & makes public referrals for prosecution. At that point, the AG *publicly* makes a decision & *publicly* assigns prosecutors to prosecute those referred
Read 23 tweets
Profile picture
F-Secure
@FSecure
Introducing...

THE HUNT: A Cyber Attack in the Process Industry

#cybersecurity #thehunt

blog.f-secure.com/cyber-security…
In manufacturing...

• 86% of cyber attacks are targeted

• 66% feature hacking

• Only 34% involve malware
In manufacturing, almost half – 47 percent – of breaches involve the theft of intellectual property to gain competitive advantage.

#cybersecurity #thehunt
Read 89 tweets
Profile picture
Echo Voice
@ReachEchoVoice
You have a big problem with your mansplaining thread. First, WE ALL KNOW Brennan setup a multi-agency task force and pressured a cointel op. Second, the FBI has a duty to inform the Trump campaign of federal investigations into ANY members [Manafort, Page, Papa], which they
did NOT. Third, look into who this Professor Mifsud is. You'll find some pretty damn interesting ties, like..to Alexander Downer. Downer was the Clinton protege who works for Hakluyt, an INTEL agency....See where this is going? Right back to Brennan, Clinton, Obama...
Ntm, Manafort was wearing a wire during the campaign..just as Papadop,
and Carter Page (I wonder if there's any relationship to FBI Lisa Page?) were monitored...Oh but we can't talk about that FISA, so let's move on to how Manafort was represented by the most corrupt, shady law
Read 102 tweets
Profile picture
Ｔａｙｌｏｒ Ｒｉｃｈｅｙ
@TheTaylorRichey
0s and 1s commonly create speech that courts use -- that means precedence is set. #Code is speech -- they're languages made of bits! Point being, ISPs shouldn't be allowed to deny computer speech from being seen by others. #NetNeutrality

Evidence in thread:
#NetNeutrality Evidence case 1: Bradley v. State: @Facebook evidence used to ID assailants and other witnesses. Its compelling because translated bits were used to ID people. It proves third party intermediary bits translated into media are used by courts. scholar.google.com/scholar_case?c…
#SaveNetNeutrality Evidence case 2: Homeland Security v. Twitter: @DHSgov seized data that was digitized and sent to intermediary @Twitter. Twitter sued its an ongoing investigation. Regardless, It appears consumer's translated bits were treated as speech? clearinghouse.net/detail.php?id=…
Read 11 tweets

Trending hashtags

#Ozark #RecordStoreDay #ItsHappening #ReadyPlayerOne #BeepBeep #FollowTheMoney #TrustThePlan #Windows95 #DoubleStandards #NotJealousAtAll #FoxNews #bullshit #MuellerInvestigation #EgyptStation #surprisemedicalbills #LookNow #yourewelcome #RecordStoreDay2019 #Demos #DeepState #9news #Wikileaks #ThoughtsAndPrayers #Banks #MeToo
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!