´╗┐

SQLitespeed

SQLite Database Management Utility


File download:

  • Software Download Link:
      MS Windows┬« 32bit - Version 2.1.1.37 (~8MB)

  • Downloadable Installer (SQLc.exe) SHA256:
      166ac6a52c2f36b291bd4f39513538bd67a9e415005a6fe0e477a459d1d0da8b

  • Main Executable (SQLitespeed.exe) SHA256:
      3e2f60c66298b60c4bc9038e54ead87d8ad3fa3f66abd5786cf420d13b891e18

  • Included SQLite Source ID - SHA256:
      c7ee0833225bfd8c5ec2f9bf62b97c4e04d03bd9566366d5221ac8fb199a87ca
    (Check with Query: [ SELECT sqlite_source_id(); ])

  • Latest Release:
      Version 2.1.1.37 - August - 2018     Beta Release

  • Included SQLite binaries Release:
      Version 3.24.0 - 2018-06-04     sqlite.org/download


Compatibility

The software is Windows™ 32-Bit based* and should work on all compatible platforms but has only been tested on 32bit XP Pro, 32/64bit Win7, 64bit Win8/8.1, 64bit Win10. It is not compatible with Win 8 R/T 64bit, and some users reported that it runs perfectly well in Wine.
Please feel free to report back on compatibility quirks on other platforms.

*Microsoft, Windows, WinXP, Win7/8/10 and all similar references are all Registered Trademarks of Microsoft Corporation.


Disclaimer

This software is provided free of charge and free of any known malware, adware or any other 3rd-party software, but no official claims are made in this regard - please stay safe with up-to-date security and anti-virus software.

As a security-measure, File-Hashes are provided for the executable file downloads. The SQLite tools included can be verified (or re-downloaded) from www.sqlite.org/download.html.


Features & Release Log

  • New features in version 2.1.1:

    • Support standard SQLite functionality and changes up to version 3.24.0 - Backwards compatible with DLL's down to version 3.7.8.
    • Added a Schema-tree with all attached databases, Tables, Views and all connected database objects - all with redesigned context menus.
    • Re-designed existing quick-SQL functions and added many more, including the newly introduced "UPSERT" functionality.
    • Added a Schema-Analyzer in the Schema documentation interface which will report on possible Schema problems that sometimes go unnoticed, such as misspelled variable types, warnings where type affinities might not match intended types, mismatching parent-child affinities between foreign keys, invalid or type-incompatible default values, etc.
    • Table-values editor recording changes to SQL script which can be independently committed or copied to use elsewhere.
    • Enhanced Query Clipboard with multiple items and the ability to iterate through clips and add/replace them into the current query code (which makes running the same query multiple times with different values, much faster).
    • Several Table designer enhancements with the ability to handle some of the popular Virtual tables.
    • Several Editor enhancements such as inserting values via a calculator, block-commenting functions, and code-hinting on Views and View-columns.
    • Several speed enhancements, GUI enhancements and bug fixes - thanks to suggestions/reports from the SQLitespeed community.

  • New features in version 2.0.2:

    • Support standard SQLite functionality and changes up to version 3.9.2 - Backwards compatible with DLL's down to version 3.7.8.
    • Export Query results to SQL (INSERT / REPLACE) with formatting for any of SQLite/PostGres/MySQL/MSSQL compatible flavours. (Most other engines will read one of those formats).
    • Improved Schema documentation (Now with working HTML linking).
    • Script Engine Improvements - Automatic-add query lines; Use external editor; Improved results formatting.
    • Improved Databse management, Search and find all valid SQLite3 databases in folders. (Can copy-paste results)
    • Improved click-to-add Keys, Indices and Triggers in visual Table designer.

  • New features in version 2.0.1:

    • Automated Schema documentation for all Database objects (with SQL and HTML exports).
      Documentation   Example 1    Example 2
    • Script Engine and Script editor to design and run / debug (step-through) SQL scripts. (Allows parameters when used within SQLitespeed)
    • Visual editors for all Table-constraints (Foreign Key, CHECK constraints, Primary keys and Unique keys).
    • Test and debug schema changes to Tables or Views before implementing them.
    • Visual Themes - many different themes to ensure everyone will find a look that is comfortable to work with.

  • New features in version 2.0:

    • Access databases from an overview control panel and group them into Projects for easy access of multiple related databases.
    • Search files among your projects, or anywhere on your computer for Databases or even specific database objects (Tables, Triggers, Indices, etc.).
      See: File and DB object Searches
    • Double-click Database links in a Project to open the Database. Links may now also point directly to a specific table to open.
    • View core SQLite-specific Database Information from the overview panel. File listings indicates database validity, presence and accessibility.
    • Drop in your own compiled sqlite.dll and use loadable extensions on the fly (Previously used extensions are remembered for easy future loading).
    • View, select or manage Views from the menu. Create new Views from your query results.
    • Export Queries to SQL in addition to all previously supported formats (CSV, JSON, XML, Spreadsheet).
    • Support all new SQLite functionality, pragmas and conventions up to version 3.8.11

  • Other features Include:

    • Complete Visual designers for tablesprimary/unique keyscheck constraintsforeign keystriggers and  indices.
    • Alter tables and columns with adjustment of all table objects.
    • Create new tables using other tables as templates - including their triggers and indices.
    • Quick-backup (to automatic files) and full custom backups with restores confirming data version date and time before commencing.
    • Compare tables - highlighting differences in structure and data.
    • Easy-reading graphical interpreter of Database statistics (Via Analyzer output).
    • Query stats for Time taken through different phases and Memory usage.

Right to copy 2018