Get SQLite via `winget` on Windows
(1) By ddevienne on 2021-08-24 11:53:31 [source]
Microsoft is finally releasing an official CLI package manager, at last.
Would be nice to easily get the SQLite CLI tools using it.
From the little I read, the integration looks doable. FWIW.
There are other ecosystems too, of course, like Chocolatey and others,
but with winget being bundled by default with Windows soon, and pushed by
Microsoft itself, would seem natural to support it. My $0.02.
There does not appear to exist a package for SQLite yet:
C:\Users\ddevienne> winget search sqlite
Name Id Version Match
-------------------------------------------------------------------------------------------
Kangaroo Taozuhong.Kangaroo 1.10.1.210731 Tag: sqlite
TablePlus TablePlus.TablePlus 4.2.8 Tag: SQLite
DataGrip (EAP) JetBrains.DataGrip.EarlyAccess 212.4746.58 Tag: sqlite
DataGrip JetBrains.DataGrip 212.4746.86 Tag: sqlite
DBeaver dbeaver.dbeaver 21.1.5 Tag: SQLite
DB Browser for SQLite DBBrowserForSQLite.DBBrowserForSQLite 3.12.2 Tag: sqlite
Beekeeper Studio beekeeper-studio.beekeeper-studio 1.13.2 Tag: sqlite
PremiumSoft Navicat Premium PremiumSoft.NavicatPremium 15.0.26 Tag: sqlite
While one can get PostgreSQL on Windows that way it seems:
C:\Users\ddevienne> winget search postgresql
Name Id Version Match
------------------------------------------------------------------------------------
PostgreSQL PostgreSQL.PostgreSQL 13
DBeaver dbeaver.dbeaver 21.1.5 Tag: PostgreSQL
pgAdmin PostgreSQL.pgAdmin 5.6
...
(2) By Nejat Günaydın (NJT145) on 2023-08-27 14:26:06 in reply to 1 [link] [source]
At this moment, I can see SQLite.SQLite on winget as a portable package. Here is what I get: PS C:\Users\nejat> winget show SQLite.SQLite Found SQLite [SQLite.SQLite] Version: 3.42.0 Publisher: SQLite Publisher Url: https://sqlite.org Publisher Support Url: https://sqlite.org/support.html Author: Dwayne Richard Hipp Description: SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. Homepage: https://sqlite.org License: Public Domain Copyright Url: https://sqlite.org/copyright.html Documentation: FAQ: https://sqlite.org/faq.html Tags: sqlite sqlite3 Installer: Installer Type: portable (zip) Installer Url: https://sqlite.org/2023/sqlite-tools-win32-x86-3420000.zip Installer SHA256: 5321c55bfb548ca1b27a972f3ecfd8269b0c8ce0bcbeac2f9d43162a4bb89710 Release Date: 2023-05-16 PS C:\Users\nejat> So, SQLite is on winget now, but because it is added by community, it is updated by community as well. So, can SQLite developers please take cotrol of these updates and automate its update when a new update is released? And can this installation method be added to the downloads page as well? Plus, I don't know how to install SQLite via apt on linux. We need to have command line installation methods documented on Downloads page of https://www.sqlite.org/ , we should see those options at page https://www.sqlite.org/download.html .
(3) By Chris Locke (chrisjlocke1) on 2023-08-27 15:25:04 in reply to 2 [link] [source]
I don't know how to install SQLite via apt on linux
https://letmegooglethat.com/?q=how+do+you+install+SQLite+via+apt+on+linux
Its super easy - barely an inconvenience.
(4) By Nejat Günaydın (NJT145) on 2023-08-27 19:10:12 in reply to 3 [link] [source]
It is easy, okay, but not for someone new at linux. So, it can be better to write some possibilities on the download page, right?
(5) By Warren Young (wyoung) on 2023-08-27 21:09:13 in reply to 4 [link] [source]
That's a bottomless well of a wish. We could end up documenting the entirety of Linux chasing logic like that.
The rest of the web exists for a reason.
(6) By Nejat Günaydın (NJT145) on 2023-08-28 09:12:31 in reply to 5 [link] [source]
So, the only officially supported method is downloading from downloads page, and the rest is not officially supported? If it is not mentioned on the downloads page, that means that it is not under control of your company and is not supported anyway, right? that goes to this result...