Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,116 results
«« first
« previous
page 70 / 104
next »
last »»
Release
db-to-sqlite 1.4
— CLI tool for exporting tables or queries from any SQL database to a SQLite file
Release
xml-analyser 1.2
— Simple command line tool for quickly analysing the structure of an arbitrary XML file
Release
datasette-upload-csvs 0.6.1
— Datasette plugin for uploading CSV files and converting them to database tables
Release
xml-analyser 1.1
— Simple command line tool for quickly analysing the structure of an arbitrary XML file
TIL
Exporting Amplitude events to SQLite
— [Amplitude](https://amplitude.com/) offers an "Export Data" button in the project settings page. This can export up to 365 days of events (up to 4GB per export), where the export is a zip file containing `*.json.gz` gzipped newline-delimited JSON.
TIL
Building a Markdown summary of Django group permissions
— [Django SQL Dashboard](https://django-sql-dashboard.datasette.io/) can display rendered markdown generated by a SQL query.
TIL
Finding CSV files that start with a BOM using ripgrep
— For [sqlite-utils issue 250](https://github.com/simonw/sqlite-utils/issues/250) I needed to locate some test CSV files that start with a UTF-8 BOM.
TIL
Running Docker on an M1 Mac
— *TLDR: Use `platform: linux/amd64` in `docker-compose.yml` and your containers will probably work!*
TIL
Docker Compose for Django development
— I had to get Docker Compose working for a Django project, primarily to make it easier for other developers to get a working development environment.
TIL
Finding duplicate records by matching name and nearby distance
— I wanted to find potentially duplicate records in my data, based on having the exact same name and being geographically located within 500 meters of each other.
TIL
Switching between gcloud accounts
— I have two different Google Cloud accounts active at the moment. Here's how to list them with `gcloud auth list`:
TIL
Django data migration using a PostgreSQL CTE
— I figured out how to use a PostgreSQL CTE as part of an update statement in a Django data migration. The trick here is mainly understanding how to combine CTEs with a PostgreSQL update - here's the pattern for that:
TIL
KNN queries with SpatiaLite
— The latest version of SpatiaLite adds KNN support, which makes it easy to efficiently answer the question "what are the X closest records to this point".
«« first
« previous
page 70 / 104
next »
last »»