Entries tagged projects, sql

Filters: Type: entry × projects × sql × Sorted by date

8 results

Joining CSV files in your browser using Datasette Lite

I added a new feature to Datasette Lite—my version of Datasette that runs entirely in your browser using WebAssembly (previously): you can now use it to load one or more CSV files by URL, and then run SQL queries against them—including joins across data from multiple files.

[... 546 words]

9:20 pm / 20th June 2022 / csv, projects, sql, datasette, webassembly, datasettelite

Django SQL Dashboard 1.0

Earlier this week I released Django SQL Dashboard 1.0. I also just released 1.0.1, with a bug fix for PostgreSQL 10 contributed by Ryan Cheley.

[... 629 words]

2:19 am / 6th July 2021 / django, postgresql, projects, sql, datasette, weeknotes, githubactions, djangosqldashboard

Joining CSV and JSON data with an in-memory SQLite database

The new sqlite-utils memory command can import CSV and JSON data directly into an in-memory SQLite database, combine and query it using SQL and output the results as CSV, JSON or various other formats of plain text tables.

[... 1507 words]

10:55 pm / 19th June 2021 / csv, json, projects, sql, sqlite, weeknotes, sqliteutils

Django SQL Dashboard

I’ve released the first non-alpha version of Django SQL Dashboard, which provides an interface for running arbitrary read-only SQL queries directly against a PostgreSQL database, protected by the Django authentication scheme. It can also be used to create saved dashboards that can be published or shared internally.

[... 2171 words]

3:39 pm / 10th May 2021 / databases, django, postgresql, projects, sql, datasette, weeknotes, djangosqldashboard

Weeknotes: tableau-to-sqlite, django-sql-dashboard

This week I started a limited production run of my new backend for Vaccinate CA calling, built a tableau-to-sqlite import tool and started working on a subset of Datasette for PostgreSQL and Django called django-sql-dashboard.

[... 792 words]

7:35 am / 14th March 2021 / django, projects, sql, weeknotes, vaccinateca, djangosqldashboard

Using SQL to find my best photo of a pelican according to Apple Photos

According to the Apple Photos internal SQLite database, this is the most aesthetically pleasing photograph I have ever taken of a pelican:

[... 1937 words]

7:16 pm / 21st May 2020 / photography, photos, projects, sql, sqlite, datasette, dogsheep, weeknotes, applephotos

sqlite-utils 2.0: real upserts

I just released version 2.0 of my sqlite-utils library/CLI tool to PyPI.

[... 1140 words]

6:48 am / 30th December 2019 / museums, projects, sql, sqlite, upsert, weeknotes, sqliteutils

Weeknotes: datasette-template-sql

Last week I talked about wanting to take ona a larger Datasette project, and listed some candidates. I ended up pushing a big project that I hadn’t listed there: the upgrade of Datasette to Python 3.8, which meant dropping support for Python 3.5 (thanks to incompatible dependencies).

[... 521 words]

10:29 pm / 18th November 2019 / projects, sql, datasette, weeknotes

Simon Willison’s Weblog