I have a Mac. If I want to test something on the kind of Windows machine that developers who use Windows would use (so I guess Windows 11 and not Windows Server?) what are my best options for doing that? Any good online providers where I can spend a few dollars on the ability to remote-desktop into a Windows machine?
I tried using Azure for this earlier and got to the bit with this checkbox and noped right out of there:
@simon BrowserStack , basically it is OS and/or browser on a cloud mainly used for testing. Not sure how much you can install it though... and quite pricey.
Have you ever used SpatiaLite on Windows? If so, how did you install it?
The MS Windows Binaries on https://www.gaia-gis.it/gaia-sins/ give you the options in the first screenshot, linking to the files in the second screenshot
Which of mod spatialite-5.1.0-win-×86.7z or spatialite-tools-5.1.0a-win-x86.7z did you download, what software did you use to decompress it and what did you do with the files inside those .7z files?
Asking because I want to bulk up Datasette's SpatiaLite installation documentation
Have you ever used SpatiaLite on Windows? If so, how did you install it?
The MS Windows Binaries on https://www.gaia-gis.it/gaia-sins/ give you the options in the first screenshot, linking to the files in the second screenshot
Which of mod spatialite-5.1.0-win-×86.7z or spatialite-tools-5.1.0a-win-x86.7z did you download, what software did you use to decompress it and what did you do with the files inside those .7z files?
Giving this another bump: I still want to hear from Windows users who have successfully installed SpatiaLite
As far as I can tell you download the mod_spaitalite 7z file from http://www.gaia-gis.it/gaia-sins/windows-bin-amd64/ then place its content somewhere on your PATH - but I’m stuck on that step, what’s the recommended way of putting files on the PATH?
I’ve found instructions that involve right clicking on things, but I’m running windows-latest in GitHub Actions so I need to do it entirely through powershell or bash
Giving this another bump: I still want to hear from Windows users who have successfully installed SpatiaLite
As far as I can tell you download the mod_spaitalite 7z file from http://www.gaia-gis.it/gaia-sins/windows-bin-amd64/ then place its content somewhere on your PATH - but I’m stuck on that step, what’s the recommended way of putting files on the PATH?
@simon in theory, winget should be able to handle a .zip install and get the path right (I think it installs to user profile by default). It doesn't handle .7z, but it knows how to install 7zip and in principle converting the file format should be straightforward... I don't know if you need to write a local manifest though, or whether it can figure it all out itself.
Miscellaneous thought about Python development environment usability: maybe a good focus could be ensuring that developers don’t have to understand the concept of their $PATH in order to debug problems with their environment
I’m not sure how that could be achieved, but it’s an interesting angle to think about the problem
New feature from Anthropic today: you can ask their Claude API to cache parts of your prompt, resulting in a large price discount and performance boost provided your app reuses the same prompt at least once every five minutes.
@simon This is an exciting evolution! DeepSeek started offering this as well in the last couple of weeks, though there's no cost for storage and you just get a lower charge based on any hits in the cache https://platform.deepseek.com/api-docs/news/news0802/ This has advantages, but of course leaves your cache hit rate dependent on how long DeepSeek choose to keep the cache around.
For individual personal usage I'd probably prefer the DeepSeek "do your best and don't make me think about it" pricing model.
@simon This is an exciting evolution! DeepSeek started offering this as well in the last couple of weeks, though there's no cost for storage and you just get a lower charge based on any hits in the cache https://platform.deepseek.com/api-docs/news/news0802/ This has advantages, but of course leaves your cache hit rate dependent on how long DeepSeek choose to keep the cache around.
Some notes on mlx-whisper - it's now really easy to run transcriptions through an Apple Silicon (and GPU) optimized Whisper model using Python on macOS https://simonwillison.net/2024/Aug/13/mlx-whisper/
@simon I've been using the new Datasette 1.0 JSON Write API for a small labeling website and I'm amazed by its simplicity. Thanks for adding it!
A brief description of my usage: https://madflex.de/using-datasette-json-write-api/
@simon I find LLMs useful for assisting with a few things, but like you’re saying, any suggestion that they can do this on their own is utterly misguided
That will take a Twitter ID and return HTML and CSS for you to embed in your website with no calling back to Twitter.
Features:
🗣 Avatars inlined as Base64 WebP
📸 All attached photos inlined
🎥 Video poster inline, <video> to original source
🔗 Hyperlinks don't use t.co
#️⃣ Hashtags and @ mentions linked
🕰 Semantic time
♥ and 🗨 counts
That will take a Twitter ID and return HTML and CSS for you to embed in your website with no calling back to Twitter.
Features:
🗣 Avatars inlined as Base64 WebP
📸 All attached photos inlined
🎥 Video poster inline, <video> to original source
🔗 Hyperlinks don't use t.co
#️⃣ Hashtags and @ mentions linked
🕰 Semantic time
♥ and 🗨 counts
@simon I believe you invented the term “slop” right 😁 my question is, if “slop” is “unwanted AI-generated content” why is this called “slop” when it’s obviously getting a ton of engagement? Is the claim that all the likes are bots? If it’s actually hundreds of thousands of people liking AI-generated images then isn’t it … not unwanted?
I spent some time reading the newly released GPT-4o System Card - it's a fascinating document, with all kinds of interesting new-to-me details in there. I've posted my highlights here: https://simonwillison.net/2024/Aug/8/gpt-4o-system-card/
Google announced a major price drop for their Gemini 1.5 Flash model today - it's now the cheapest of the mainstream cheap-and-fast models, and it can also handle PDF files, audio and video as well as images and text.
Here's an example shared transcript, in which I start by asking for advice on breeding spiders to catch flies and then keep on escalating until Claude is frantically advising me not to attract any bears to deal with the mountain lions that have surrounded my house: https://gist.github.com/simonw/95abdfa3cdf755dbe6feb5ec4e3029f4
Here's an example shared transcript, in which I start by asking for advice on breeding spiders to catch flies and then keep on escalating until Claude is frantically advising me not to attract any bears to deal with the mountain lions that have surrounded my house:
I've released a new reusable Django app - django-http-debug - which makes it easy to quickly setup a debugging HTTP endpoint that returns a canned response and logs full details of any incoming requests, great for the initial stages of implementing things like OAuth or incoming webhooks.
As part of working on this I figured out (with more help from Claude) a good pattern for writing automated tests for a reusable Django app like this that can live in the same repository and spin up a minimal Django project, just enough for the tests to run. I wrote that up in detail as this TIL: https://til.simonwillison.net/django/pytest-django
Your regular reminder to never build a LLM-based chat interface with access to privileged information that can render Markdown images targetting external domains, if you don't want a prompt injection attack to be able to instantly exfiltrate that private data
Your regular reminder to never build a LLM-based chat interface with access to privileged information that can render Markdown images targetting external domains, if you don't want a prompt injection attack to be able to instantly exfiltrate that private data
@simon I guess I don't understand how this is an attack. The malicious prompt came from the attacker, but so did everything else. So the attacker already has access to the "exfiltrated" data, right?
> Walz also says maps help implement the nitty-gritty details of otherwise abstract policy. “You have to have a plan” for “how we’re doing power and economic justice and environmental justice,” he said. “The tools for that plan are GIS.” Those tools “transfer a vision of a fair society into one that actually has results.” #HarrisWalz2024
> Walz also says maps help implement the nitty-gritty details of otherwise abstract policy. “You have to have a plan” for “how we’re doing power and economic justice and environmental justice,” he said. “The tools for that plan are GIS.” Those tools “transfer a vision of a fair society into one that actually has results.” #HarrisWalz2024
OpenAI announced "Structured Outputs in the API" today, which is a lot more exciting than it sounds and also came with a huge price drop (50% cheaper) for a new GPT-4o model - which makes it their new cheapest model for image inputs, since GPT-4o-mini is priced the same for image inputs as the previous, more expensive GPT-4o
@simon I did quite a bit of testing tonight I was surprised that structured outputs also worked with GPT-4o-mini. I didn’t crunch the numbers but I was already using it to parse text to json and I noticed an immediate improvement. I assumed we had to use the new model for pydantic support but it just worked.
@simon BrowserStack , basically it is OS and/or browser on a cloud mainly used for testing. Not sure how much you can install it though... and quite pricey.
@simon Get a Windows 11 key off eBay, then click that checkbox…
@simon I use https://shadow.tech/en-GB for nerdery and gaming