RFP - sqlean-sqlite-extensions

[qqii]

Checklist

• The package I am requesting does not already exist on https://community.chocolatey.org/packages;
• There is no open issue for this package;
• The issue title starts with 'RFP - ';
• The download URL is public and not locked behind a paywall / login;

Package Details

Software project URL : https://github.com/nalgeon/sqlean
Direct download URL for the software / installer : https://github.com/nalgeon/sqlean/releases/tag/0.17.1 and https://github.com/nalgeon/sqlean/releases/tag/incubator
Software summary / short description: Various extensions to SQLite that are not build as part of the binary.

Ideally dll files would be put into C:\ProgramData\chocolatey\bin or something like C:\ProgramData\chocolatey\bin\sqlite3-ext.

[github-actions]

Package Request Validation

We have finished some basic validation of this request. The result of this validation can be found below:

Request Notices

We found some issues we could not fully validate without user input, or by human review. Please make any necessary changes when appropriate.

• We were unable to find a supported binary file in the download URL. Please make sure that the download URL is correct.

File Validation Output

TrID/32 - File Identifier v2.24 - (C) 2003-16 By M.Pontello
Definitions found:  15077
Analyzing...

Collecting data from file: C:\Users\RUNNER~1\AppData\Local\Temp/software.tmp

Warning: file seems to be plain text/ASCII
         TrID is best suited to analyze binary files!

       Unknown!

Please note that this check is currently in alpha, and may not be able to detect everything correctly.
Humans may also be able to detect other issues with this request.

[dgalbraith]

I will pick this up.

Point to note - the extensions are compiled as 64-bit so are not compatible with the existing distributions / packages containing the sqlite command line shell (SQLite or sqlite.shel).

Until the main distribution is updated with a 64-bit version of the command line shell these extensions will need the unofficial 64-bit version of the command line shell provided by the editor of the extensions package Anton Zhiyanov

Any thoughts on this being bundled with the extensions or packaged separately with the extensions having a dependency?

[qqii]

I think packaging them together makes the most sense, since the unofficial 64-bit version already toggles some sqlite extensions.

[pauby]

@dgalbraith this doesn't look to have been submitted yet?

[dgalbraith]

A few packages have been pushed covering this request:

• sqlean - the sqlean extensions
• sqlean-shell - a custom sqlite shell with the sqlean extensions embedded
• sqlite-shell-x64 - a 64-bit sqlite shell build for the stand-alone sqlean extensions which require a 64-bit process

Packages are now in moderation.

[dgalbraith]

Moderation complete and the packages are now available in the community repository.