Simonwillison.net

healthkit-to-sqlite

WebA few days ago I stumbled across the “Export Health Data” button in the iOS Health app, and it turns out it creates a zip file containing XML with a full dump of the data collected …

Actived: 5 days ago

URL: https://simonwillison.net/2019/Jul/22/healthkit-sqlite/

Trying to end the pandemic a little earlier with VaccinateCA

WebIt provides a full dump of collected location data, plus information on county policies and large-scale providers (pharmacy chains, health care providers). The system …

Category:  Health Go Health

Weeknotes: COVID-19 numbers in Datasette

WebWeeknotes: COVID-19 numbers in Datasette. 11th March 2020. COVID-19, the disease caused by the novel coronavirus, gets more terrifying every day.Johns …

Category:  Coronavirus Go Health

Talking to a PostgreSQL service container from inside a Docker

WebThe key insight was that Docker containers (at least on Linux) have a magic IP address, 172.17.0.1, which can be used to access their host environment - and …

Category:  Health Go Health

Running tests against PostgreSQL in a service container

WebRunning tests against PostgreSQL in a service container. I wanted to run some Django tests - using pytest-django and with Django configured to pick up the …

Category:  Health Go Health

Weeknotes: Covid-19, First Python Notebook, more Dogsheep, …

WebWeeknotes: Covid-19, First Python Notebook, more Dogsheep, Tailscale. 1st April 2020. My covid-19.datasettes.com project publishes information on COVID-19 …

Category:  Health Go Health

Personal Data Warehouses: Reclaiming Your Data

WebThe health data is manual: the iOS Health app has an export button which generates a zip file of XML which you can then AirDrop to a laptop. I then run my …

Category:  Health Go Health

Constructing GeoJSON in PostgreSQL Simon Willison’s TILs

WebConstructing GeoJSON in PostgreSQL. In order to efficiently generate a GeoJSON representation of a vast number of locations, I'm currently experimenting with …

Category:  Health Go Health

Cleaning Up Your Postgres Database

WebCleaning Up Your Postgres Database Craig Kerstiens provides some invaluable tips on running an initial check of the health of a PostgreSQL database, by …

Category:  Health Go Health

Simon Willison on machinelearning

WebHe just posted a multi-paragraph comment on Hacker News explaining the term and describing some of the recent innovations in that space. “TinyML means running …

Category:  Health Go Health

Thoughts on AI safety in this era of increasingly powerful open …

WebThoughts on AI safety in this era of increasingly powerful open source LLMs. 10th April 2023. This morning, VentureBeat published a story by Sharon Goldman: With …

Category:  Health Go Health

Limited JSON API for Google searches using Programmable …

WebYou can then use their JSON API to run searches. It's quite limited: Maximum of 10 results per page, and you can only paginate up to 10 times so 100 …

Category:  Health Go Health

Datasette—an ecosystem of tools for working with small data

WebDatasette—an ecosystem of tools for working with small data. This is the transcript and video from a talk I gave at PyGotham 2020 about using SQLite, Datasette …

Category:  Health Go Health

Google Health Advertising Blog: My opinion and Google's

WebGoogle Health Advertising Blog: My opinion and Google's A follow up to the post I linked to earlier. Posted 1st July 2007 at 9:22 pm. Recent articles. Weeknotes: a Datasette …

Category:  Health Go Health

Adding GeoDjango to an existing Django project

WebAdding GeoDjango to an existing Django project. 3rd May 2021. Work on VIAL for Vaccinate The States continues.. I talked about matching last week. I’ve been …

Category:  Health Go Health

How to set up world-class continuous deployment using free …

WebIt turns out Heroku has basic support for continuous deployment baked in, and it’s trivially easy to set up. You can tell Heroku to deploy on every commit to GitHub, …

Category:  Health Go Health

Introducing LiteFS

WebIntroducing LiteFS LiteFS is the new SQLite replication solution from Fly, now ready for beta testing.It’s from the same author as Litestream but has a very …

Category:  Health Go Health

Weeknotes: Getting my personal Dogsheep up and running again

WebInstall Python 3 and NGINX and SQLite: apt-get install python3 python3-venv nginx sqlite -y. Use letsencrypt to get an HTTPS certificate for it: apt-get update and then …

Category:  Health Go Health

rev=canonical bookmarklet and designing shorter URLs

WebI’ve watched the proliferation of URL shortening services over the past year with a certain amount of dismay. I care about the health of the web and try to ensure that …

Category:  Health Go Health

How to implement Q&A against your documentation with GPT3, …

WebRun a text search (or a semantic search, described later) against your documentation to find content that looks like it could be relevant to the user’s question. Grab extracts of that …

Category:  Health Go Health

Refactoring databases with sqlite-utils extract

WebRefactoring databases with sqlite-utils extract. 23rd September 2020. Yesterday I described the new sqlite-utils transform mechanism for applying SQLite table …

Category:  Health Go Health

Simon Willison on sqlite

WebI’m writing a new vector search SQLite Extension.Alex Garcia is working on sqlite-vec, a spiritual successor to his sqlite-vss project. The new SQLite C extension will have zero …

Category:  Health Go Health