Email or username:

Password:

Forgot your password?
Simon's posts Post Back to profile
Simon Willison

Have you ever used SpatiaLite on Windows? If so, how did you install it?

The MS Windows Binaries on 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

MS Windows binaries Current stable version: x86 32 bit, amd64 64 bit Previous stable version: x86 32 bit, amd64 64 bit Latest version supporting spatialite GUI: x86 32 bit, amd64 64 bit That's six different links, one for each of those versions and architectures
Apache directory listing Index of /gaia-sins/windows-bin-×86 mod spatialite-5.1.0-win-×86.7z 2023-08-05 13:42 10M spatialite-tools-5.1.0a-win-x86.7z 2023-08-13 16:44 118M
16 August at 2:19 | Open on fedi.simonwillison.net
18 comments
Simon Willison

I'm not very Windows literate these days. Am I right in thinking that Windows doesn't include the ability to open .7z files by default, so you need extra software? What extra software do people generally use for that?

16 August at 2:20 | Open on fedi.simonwillison.net
Simon Willison

Do Windows users generally know which out of the x86 and amd64 options they should pick? If people aren't sure, is there a command I can suggest they run or a program they can look in to figure out which one they should use?

(Earlier on I was trying to do this in a GitHub Actions workflow and I wasn't sure how to tell if it was x86 or amd64)

16 August at 2:21 | Open on fedi.simonwillison.net
Reilly Wood

@simon Many people won’t know off the top of their head, but vanishingly few users will be on 32-bit. Think you can safely recommend amd64 to most people.
16 August at 2:44 | Open on mastodon.social
Paul Hennell • Dev

@simon Honestly despite being a techy person and now a programmer, I've never been good knowing what download option to pick. Doesn't help you need to know if your system is 32 or 64 to choose between 86 and 64 🙄

These days most windows are 64 bit though, so unless your target audience is "people/businesses with very old machines" just heavily recommended the 64 (and have a clear error installer for people who need the 32!)

16 August at 7:26 | Open on phpc.social
DJ Tent Mode

@simon Yes. Because it’s a trick question. There really aren’t enough AMD64 architecture Windows devices in the marketplace for it ever to be the right option. And while people like you and I are chatting about it here, most people aren’t getting software off of git. We are the corner case of this thought experiment.

16 August at 15:10 | Open on mstdn.party
Andrei Kucharavy

@simon pretty much all modern computers are amd64 - x86 is provided as legacy version, and will still work, but not benefit from modern cpu power.

16 August at 15:54 | Open on mastodon.social
peter sibley

@simon i think that’s now included in win11

16 August at 2:23 | Open on mastodon.social
Adriano

@simon 7zip has long been my alternative

16 August at 2:24 | Open on lile.cl
Snooze Button Connoisseur
Matt Cengia

@simon Windows 11, at least, now has native support: tomshardware.com/news/windows-
But yes 7zip is the alternative I think.

16 August at 2:53 | Open on aus.social
Ben Keith

@simon Since 2023, Windows 11 has included native support for 7-zip, rar, gz, and anything else supported by libarchive: blogs.windows.com/windowsdevel

I expect people would install 7-zip (or a spyware clone) to get that support if they're on an older build of Windows.

16 August at 14:57 | Open on newsie.social
Andrei Kucharavy
Mihai Christodorescu
Simon Willison

@mihai right, but I want to know what software people who frequently use Windows use for that - I can Google for it, but that's not the same thing as learning what the "assumed default" is for the purpose of writing documentation

16 August at 2:48 | Open on fedi.simonwillison.net
Mihai Christodorescu

@simon 7zip.org is the reference implementation for 7z, I believe it is safe to point people that way.

16 August at 3:47 | Open on ioc.exchange
Simon Willison

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 gaia-gis.it/gaia-sins/windows- 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 gaia-gis.it/gaia-sins/windows- 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?

17 August at 1:21 | Open on fedi.simonwillison.net
haliphax 👾

@simon `set PATH=%PATH%;c:\new\folder` was always my go to, but I'll admit I haven't used Windows in at least a few years

17 August at 1:35 | Open on hachyderm.io
Alex Hudson

@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.

17 August at 16:14 | Open on c.im
Go Up