Share this page!

Simon Willison Profile picture
Twitter logo
11 Mar, 5 tweets, 2 min read
Built tableau-to-sqlite github.com/simonw/tableau…
github.com/bertrandmartel… by Bertrand Martel does all of the actual work, I just added a paper-thin wrapper around it that writes the resulting Pandas DataFrames out to a SQLite database
Here's version 0.2
Added a note to the README about combining it with sqlite-utils to get the data out as CSV or JSON if you want to use it to build a git scraper: github.com/simonw/tableau…
Here's a fantastically useful guide to scraping Tableau by @chipx86

• • •

Missing some Tweet in this thread? You can try to force a refresh
　

Keep Current with Simon Willison

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!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @simonw

Simon Willison Profile picture
10 Mar
Apple has gone to extraordinary lengths to make scroll bars invisible, and I hate it

Anyone seen a reliable pattern for having them appear in Safari / MobileSafari / Firefox / Chrome on macOS and iOS?

The ones on StackOverflow from a few years ago don't seem to work any more
To clarify: I want to have them visible for users of my web applications, so fixing this in macOS system preferences, while good for me, isn't the solution I'm after
I think I'm going to do the visual indication that there's more content offscreen thing - maybe with a shadow
Read 6 tweets
Simon Willison Profile picture
9 Mar
TIL that witches are traditionally associated with pointy hats, cauldrons and cats because that's what women who sold beer they brewed wore to the market - cauldrons to carry the beer, pointy hats for visibility and cats to keep the mice away from the grain
Here's a refutation (thanks, @AdamChainz) from a medieval historian and President and Founder of the Ladies Craft Beer Society of Ireland
It's long, well researched, neatly illustrated and brings copious citation footnotes. Here's the TLDR:

"TL;DR: Medieval or 16th century alewives were not the cause of the modern witch stereotype, which seems to have solidified in children’s chapbooks from the 18th century."
Read 5 tweets
Simon Willison Profile picture
9 Mar
If I have data with this location information:

"XCoord":"-95640011", "YCoord":"29737404"

And I know it to be somewhere in Houston TX, does anyone know tricks I can use to figure out what the co-ordinate system is that's being used there, and how to turn it into lat/lon?
I tried running them through this "State Plane Coordinate System" against the various Texas options in the menu for this tool earthpoint.us/stateplane.aspx and looking for something close to 29.8 ,-95.6 but I didn't see anything that looked like a match
I'd really love a tool where you plug in mystery co-ordinates along with a "should be somewhere near this point" indication and it brute-force runs them through every co-ordinate system it can think of and shows you the closest matches
Read 5 tweets
Simon Willison Profile picture
17 Jan
I found this profile really useful for helping me understand how so many people have been lost to the QAnon swamp
"Believing in QAnon tends to clear one’s social calendar, and Ms. Gilbert is no exception. She cut ties with her closest friends years ago, after arguing with them about Pizzagate. She is estranged from her sister, who tried and failed to stage an intervention over her Facebook"
It's all so sad. I check in on the QAnonCasualties subreddit occasionally and it's heart breaking reddit.com/r/QAnonCasualt…
Read 4 tweets
Simon Willison Profile picture
7 Jan
In a futile attempt to distract myself from doomscrolling I wrote about my latest weird Datasette plugin, datasette-css-properties - which lets you retrieve data from SQL queries as custom properties (aka variables) in a CSS stylesheet simonwillison.net/2021/Jan/7/css…
This plugin was inspired by @chriscoyier
A slightly concerning feature of this plugin is that it lets people reflect back as CSS any value they put in the querystring: latest-with-plugins.datasette.io/fixtures.css?s… - I'm currently on-the-fence as to if this constitutes an XSS security hole or not. Open issue: github.com/simonw/dataset…
Read 4 tweets
Simon Willison Profile picture
24 Dec 20
@chriscoyier you have a Canon T7i with a Cam Link right? This "Clean HDMI" thing has me stumped... I've got this far but there's still a frame border visible in the picture (I used the Info button to turn off the other overlays) chriscoyier.net/2020/04/06/the…
Researching how to do this is awful. I've had to sit through SO MANY YouTube "tutorials" on doing this which end up not answering my question :(
Urgh, looks like I might be out of luck
Read 4 tweets

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/month or $30/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!

Follow Us on Twitter!

Like this author's thread?

Get emails when @simonw has new unrolls!

Check out other threads from @simonw!

Read all threads by @simonw