Simon Willison simonw

## sql_replace_in_django_orm.py
from django.db.models import F, Func, Value
from myapp.models import MyModel

# Annotation
MyModel.objects.filter(description__icontains='\r\n').annotate(
    fixed_description=Func(
        F('description'),
        Value('\r\n'), Value('\n'),
        function='replace',
    )

## python-in-wasm.md

      
              1 file
            
          
              0 forks
            
          
              7 comments
            
          
              3 stars
            
          
                simonw
                / python-in-wasm.md
            
            
              Created
              May 10, 2023 17:35
            
          
    What I want from a run-Python-in-WASM solution

I want to be able to use WebAssembly as a sandbox to safely run Python code from untrusted sources, within my existing Python applications.
I'd like to be able to:

Pass in an untrusted string of Python code and have that evaluated
Maybe also pass in initial variables to be used in the code - though hard-coding them would work OK too
Have the code run in a sandboxed environment, with a timeout and memory limit
The sandbox disallows network access and disk access - it can only access the variables passed in


## loading_data.js
jQuery.get('https://api.github.com/gists/3a065d804c44b0149eac', function(data) {
  console.log(data.files['file1.txt'].content)
});

## single-file-web-component.html
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="UTF-8" />
    <title>Single File Web Component</title>
    <style>
      body {
        background-color: #eee;
        font-family: Helvetica, sans-serif;
      }

## how-to.md

      
              1 file
            
          
              10 forks
            
          
              12 comments
            
          
              87 stars
            
          
                simonw
                / how-to.md
            
            
              Last active
              March 26, 2024 23:21
            
              
                How to create a tarball of a git repository using "git archive"
              
          
    git archive --format=tar.gz -o /tmp/my-repo.tar.gz --prefix=my-repo/ master

More detailed version: https://til.simonwillison.net/git/git-archive

  
## README.md

      
              3 files
            
          
              0 forks
            
          
              0 comments
            
          
              4 stars
            
          
                simonw
                / README.md
            
            
              Created
              May 3, 2022 18:11
            
              
                Simple declarative schema migration for SQLite
              
          
    A backup copy of the code from https://david.rothlis.net/declarative-schema-migration-for-sqlite/
Code is MIT licensed, written by William Manley, copyright © 2019-2022 Stb-tester.com Ltd

  
## 338.quickjs.js
"use strict";(self.webpackChunk=self.webpackChunk||[]).push([[338],{578:(e,t,r)=>{e.exports=r.p+"7cf7ced34f0a1ece31b4.wasm"},338:(e,t,r)=>{var n;r.r(t),r.d(t,{default:()=>a});const a=(n="file:///private/tmp/node_modules/@jitl/quickjs-wasmfile-release-sync/dist/emscripten-module.browser.mjs",function(e={}){var t,a,o=e;function i(e){e={log:e||function(){}};for(const t of i.za)t(e);return o.quickJSEmscriptenExtensions=e}o.ready=new Promise(((e,r)=>{t=e,a=r})),i.za=[],o.quickjsEmscriptenInit=i,i.za.push((e=>{e.getWasmMemory=function(){return Q}}));var _,u=Object.assign({},o),l="./this.program",s="object"==typeof window,f="function"==typeof importScripts,S="";(s||f)&&(f?S=self.location.href:"undefined"!=typeof document&&document.currentScript&&(S=document.currentScript.src),n&&(S=n),S=0!==S.indexOf("blob:")?S.substr(0,S.replace(/[?#].*/,"").lastIndexOf("/")+1):"",f&&(_=e=>{var t=new XMLHttpRequest;return t.open("GET",e,!1),t.responseType="arraybuffer",t.send(null),new Uint8Array(t.response)}));var c,T=o.print||con

## weasel-names-llama-13b.md

      
              1 file
            
          
              0 forks
            
          
              2 comments
            
          
              5 stars
            
          
                simonw
                / weasel-names-llama-13b.md
            
            
              Created
              August 22, 2023 20:19
            
          
    2023-08-22T20:18:12    conversation: 01h8fec5xgr78z9pyfmdgnwy33

Model: mlc-chat-Llama-2-13b-chat-hf-q4f16_1
Prompt:

Five cute names for a pet weasel
Response:


## ubuntu-python-upgrade.md

      
              1 file
            
          
              0 forks
            
          
              12 comments
            
          
              3 stars
            
          
                simonw
                / ubuntu-python-upgrade.md
            
            
              Created
              March 28, 2020 19:45
            
              
                How to run Python 3.7 on Ubuntu 16.04
              
          
    How to run Python 3.7 on Ubuntu 16.04

This is based on Method 2 in https://websiteforstudents.com/installing-the-latest-python-3-7-on-ubuntu-16-04-18-04/
First, you need to install Python 3.7 (you will currently have Python 3.5.2):
sudo apt update
sudo apt install software-properties-common
sudo add-apt-repository ppa:deadsnakes/ppa

sudo apt update

  
## METADATA
Metadata-Version: 2.1
Name: testcontainers-postgres
Version: 0.0.1rc1
Summary: PostgreSQL component of testcontainers-python.
Home-page: https://github.com/testcontainers/testcontainers-python
Requires-Python: >=3.7
Description-Content-Type: text/x-rst
Requires-Dist: testcontainers-core
Requires-Dist: sqlalchemy
Requires-Dist: psycopg2-binary
	from django.db.models import F, Func, Value
	from myapp.models import MyModel

	# Annotation
	MyModel.objects.filter(description__icontains='\r\n').annotate(
	fixed_description=Func(
	F('description'),
	Value('\r\n'), Value('\n'),
	function='replace',
	)
	jQuery.get('https://api.github.com/gists/3a065d804c44b0149eac', function(data) {
	console.log(data.files['file1.txt'].content)
	});
	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8" />
	<title>Single File Web Component</title>
	<style>
	body {
	background-color: #eee;
	font-family: Helvetica, sans-serif;
	}
	Metadata-Version: 2.1
	Name: testcontainers-postgres
	Version: 0.0.1rc1
	Summary: PostgreSQL component of testcontainers-python.
	Home-page: https://github.com/testcontainers/testcontainers-python
	Requires-Python: >=3.7
	Description-Content-Type: text/x-rst
	Requires-Dist: testcontainers-core
	Requires-Dist: sqlalchemy
	Requires-Dist: psycopg2-binary