SQLite Forum

Get SQLite via `winget` on Windows
Login

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