Tweet

https://twitter.com/kevinroose/status/1350829581993820162

This Thread may be Removed Anytime!

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

More from @simonw

Simon Willison

@simonw

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…

@chriscoyier

This plugin was inspired by @chriscoyier

https://twitter.com/chriscoyier/status/1346504050313990157

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

@simonw

24 Dec 20

@chriscoyier

@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 :(

https://twitter.com/motdde/status/1233535219262726145

Urgh, looks like I might be out of luck

https://twitter.com/motdde/status/1233535219262726145

Read 4 tweets

Simon Willison

@simonw

22 Dec 20

https://twitter.com/dhh/status/1341420143239450624

I'm excited to dig into this. Turbolinks has always appealed to me for skipping fill page reloads without going all-in on client-side-rendering, and the new turbo frames thing looks like a very useful extension to that concept

https://twitter.com/dhh/status/1341420143239450624

https://twitter.com/sstephenson/status/1341050306277339136

Simon Willison

@simonw

21 Dec 20

Having decent test coverage for a software project turns out to be the single biggest boost to programming productivity that I know of

It lets you drop in to a project, make a change, commit and release it and then forget EVERYTHING you know about that project again

When I think about the amount of programming time I've wasted in the past because a project didn't have tests, so any changes at all involved first having to understand everything about how it was built and what it was supposed to do (entirely undocumented, of course)

Read 5 tweets

Simon Willison

@simonw

12 Oct 20

Notes, links and notebook from my #JupyterCon2020 session on Datasette and sqlite-utils this morning: gist.github.com/simonw/656c21b… - I live-coded a SQLite database containing earthquakes from last week using data from USGS

Here's a Datasette instance showing the database of earthquakes I built in that notebook - facet by type shows that there were 17 ice quakes, 1 mine collapse and 1 chemical explosion in the past week! jupytercon-earthquakes-demo.vercel.app/earthquakes/qu…

Looks like this is the mine collapse: triblive.com/local/westmore…

Read 4 tweets

Simon Willison

@simonw

12 Oct 20

Built a tool to load Evernote exported notes (ENEX files) into a SQLite database - so now I can load them into Datasette and see all of my notes on a map! github.com/dogsheep/evern…

ENEX is a slightly tricky format - each note is CDATA XML embedded in a larger XML document, plus base64 attachments (usually images).

All of my notes exported at once result in an XML file that's 2.6GB!

One neat detail is that the output of Evernote's cloud OCR system (run automatically against every image embedded in a note) is available in the XML. evernote-to-sqlite extracts out these OCR strings and uses them to populate a SQLite full-text search table.