Notices: This section not yet converted to new layout. Download stats are rolling back out.

SQLite Studio (Portable)

3.1.1

Package test results are passing.

Private CDN cached downloads available for licensed customers. Never experience 404 breakages again! Learn more...

This package is likely a meta/virtual (*) or an installer (*.install) or portable (*.portable) application package.
  • Meta/virtual (*) - has a dependency on the *.install or the *.portable package - it is provided for discoverability and for other packages to take a dependency on.
  • Portable (*.portable/*.commandline (deprecated naming convention)/*.tool (deprecated naming convention)) - usually zips or archives that require no administrative access to install.
  • Install (*.install/*.app (deprecated naming convention)) - uses native installers, usually requires administrative access to install.
Learn more about chocolatey's distinction of installed versus portable apps and/or learn about this kind of package.

This package was approved by moderator flcdrg on 2/18/2017.

SQLiteStudio is a SQLite database manager with the following features:
* Portable - no need to install or uninstall. Just download, unpack and run.
* Intuitive interface,
* Powerful, yet light and fast,
* All SQLite3 and SQLite2 features wrapped within simple GUI,
* Cross-platform - runs on Windows 9x/2k/XP/2003/Vista/7, Linux, MacOS X and should work * on other Unixes (not tested yet).
* Exporting to various formats (SQL statements, CSV, HTML, XML, PDF, JSON),
* Importing data from various formats (CSV, custom text files [regular expressions]),
* Numerous small additions, like formatting code, history of queries executed in editor * windows, on-the-fly syntax checking, and more,
* Unicode support,
* Skinnable (interface can look native for Windows 9x/XP, KDE, GTK, Mac OS X, or draw widgets to fit for other environments, WindowMaker, etc),
* Configurable colors, fonts and shortcuts.
* Open source and free - Released under GPLv3 license.

To install SQLite Studio (Portable), run the following command from the command line or from PowerShell:

C:\> choco install sqlite-studio.portable

To upgrade SQLite Studio (Portable), run the following command from the command line or from PowerShell:

C:\> choco upgrade sqlite-studio.portable

Files

Hide
  • tools\chocolateyInstall.ps1 Show
    $ErrorActionPreference = 'Stop'
    
    $packageName  = 'sqlite-studio.portable'
    $url          = 'https://sqlitestudio.pl/files/sqlitestudio3/complete/win32/sqlitestudio-3.1.1.zip'
    $checksum     = 'ddcaae8f6579de62174337f50e3a64a6f2112b8189796a7902933dd1bbe140ac'
    $checksumType = 'sha256'
    $toolsPath    = Split-Path -parent $MyInvocation.MyCommand.Definition
    
    $packageArgs = @{
        packageName    = $packageName
        url            = $url
        checksum       = $checksum
        checksumType   = $checksumType
        unzipLocation  = $toolsPath
    }
    
    Install-ChocolateyZipPackage @packageArgs
    
    $files = Get-ChildItem "$toolsPath" -Include *.exe -Exclude "SQLiteStudio.exe" -Recurse
    foreach ($file in $files) {
    	New-Item "$file.ignore" -Type file -Force | Out-Null
    }
    
  • update.ps1 Show
    Import-Module au
    
    function global:au_SearchReplace {
    	@{
    		'tools\chocolateyInstall.ps1' = @{
    			"(^[$]url\s*=\s*)('.*')"          = "`$1'$($Latest.URL32)'"
    			"(^[$]checksum\s*=\s*)('.*')"     = "`$1'$($Latest.Checksum32)'"
    			"(^[$]checksumType\s*=\s*)('.*')" = "`$1'$($Latest.ChecksumType32)'"
    		}
    	}
    }
    
    function global:au_GetLatest {
    	$page = Invoke-WebRequest -Uri "https://sqlitestudio.pl/files/sqlitestudio3/complete/win32/?C=N;O=D"
    	$zip = $page.Links | Where-Object innerText -Match "sqlitestudio-\d+(\.\d+){0,2}.zip" | Select-Object -First 1 -ExpandProperty innerText
    	$version = $zip.Substring($zip.LastIndexOf("-") + 1, $zip.Length - $zip.LastIndexOf(".zip") + 1)
    	$url = "https://sqlitestudio.pl/files/sqlitestudio3/complete/win32/$zip"
    	$Latest = @{
    		Version = $version;
    		URL32 = $url;
    	}
    	return $Latest
    }
    
    Update-Package
    

Virus Scan Results

In cases where actual malware is found, the packages are subject to removal. Software sometimes has false positives. Moderators do not necessarily validate the safety of the underlying software, only that a package retrieves software from the official distribution point and/or validate embedded software against official distribution point (where distribution rights allow redistribution).

Chocolatey Pro provides runtime protection from possible malware.

Dependencies

This package has no dependencies.

Package Maintainer(s)

Software Author(s)

  • SalSoft Pawel Salawa

Tags

Release Notes

https://sqlitestudio.pl/index.rvt?act=changelog

Version History

Version Downloads Last updated Status

Discussion for the SQLite Studio (Portable) Package

Ground rules:

  • This discussion is only about SQLite Studio (Portable) and the SQLite Studio (Portable) package. If you have feedback for Chocolatey, please contact the google group.
  • This discussion will carry over multiple versions. If you have a comment about a particular version, please note that in your comments.
  • The maintainers of this Chocolatey Package will be notified about new comments that are posted to this Disqus thread, however, it is NOT a guarantee that you will get a response. If you do not hear back from the maintainers after posting a message below, please follow up by using the link on the left side of this page or follow this link to contact maintainers. If you still hear nothing back, please follow the package triage process.
  • Tell us what you love about the package or SQLite Studio (Portable), or tell us what needs improvement.
  • Share your experiences with the package, or extra configuration or gotchas that you've found.
  • If you use a url, the comment will be flagged for moderation until you've been whitelisted. Disqus moderated comments are approved on a weekly schedule if not sooner. It could take between 1-5 days for your comment to show up.

comments powered by Disqus
Chocolatey.org uses cookies to enhance the user experience of the site.
Ok