CINXE.COM
SQLiteStudio
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <meta name="description" content=""> <meta name="author" content=""> <title>SQLiteStudio</title> <link rel="icon" href="https://sqlitestudio.pl/img/sqlitestudio.png"> <link href="https://sqlitestudio.pl/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet"> <link href="https://sqlitestudio.pl/vendor/bootstrap/css/bootstrap-glyphicons.min.css" rel="stylesheet"> <link rel="stylesheet" href="https://cdn.metroui.org.ua/v4/css/metro-icons.min.css"> <link rel="stylesheet" href="https://cdn.metroui.org.ua/v4/css/metro-animations.min.css"> <link href="https://sqlitestudio.pl/app/app.min.css?v=1686122883" rel="stylesheet"> </head> <body onload="initAfterLoad()"> <div id="overlay" onclick="closeOverlay()"> <img id="overlay-img" src=""> </div> <div class="page-contents"> <nav class="navbar navbar-expand-lg navbar-dark bg-dark fixed-top"> <div class="container"> <a class="navbar-brand" href="/"> <img src="https://sqlitestudio.pl/img/sqlitestudio.png" class="header-logo"> SQLiteStudio </a> <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false" aria-label="Toggle navigation"> <span class="navbar-toggler-icon"></span> </button> <div class="collapse navbar-collapse" id="navbarResponsive"> <ul class="navbar-nav ml-auto"> <li class="nav-item s-dropdown"> <a href="https://sqlitestudio.pl/" class="nav-link">Home</a> <div class="s-dropdown-content bg-dark"> <a href="https://sqlitestudio.pl/about/">About</a> <a href="https://sqlitestudio.pl/donate/">Donate</a> <a href="https://sqlitestudio.pl/contact/">Contact</a> </div> </li> <li class="nav-item"> <a href="https://sqlitestudio.pl/news/" class="nav-link">News</a> </li> <li class="nav-item s-dropdown"> <a href="https://sqlitestudio.pl/gallery/" class="nav-link">Gallery</a> <div class="s-dropdown-content bg-dark"> <a href="https://sqlitestudio.pl/features/">Features</a> </div> </li> <li class="nav-item"> <a href="https://github.com/pawelsalawa/sqlitestudio/releases" class="nav-link">Download</a> </li> <li class="nav-item s-dropdown"> <a href="https://github.com/pawelsalawa/sqlitestudio" class="nav-link">GitHub</a> <div class="s-dropdown-content bg-dark last"> <a href="https://github.com/pawelsalawa/sqlitestudio/discussions">Discussions</a> <a href="https://github.com/pawelsalawa/sqlitestudio/wiki">Wiki</a> <a href="https://github.com/pawelsalawa/sqlitestudio/issues">Bugs & Ideas</a> <a href="https://github.com/pawelsalawa/sqlitestudio/blob/master/ChangeLog.md">ChangeLog</a> </div> </li> </ul> </div> </div> </nav> <div class="container"> <div class="row mt-4"> <div class="col-md-12 col-lg-6 mb-4 feature-card"> <div class="card h-100 bg-light"> <span class="card-icon feature glyphicon glyphicon-gift text-secondary" aria-hidden="true"></span> <h4 class="card-title">Free & open source</h4> <p class="card-text">It's free of charge for everybody, for any purpose (including commercial). It's safe, as anyone can review source code.</p> </div> </div> <div class="col-md-12 col-lg-6 mb-4 feature-card"> <div class="card h-100 bg-light"> <span class="card-icon feature glyphicon glyphicon-console text-secondary" aria-hidden="true"></span> <h4 class="card-title">Advanced SQL code editor</h4> <p class="card-text">The SQL Editor window assists user with SQL syntax hints & highlighting, provides pretty-print code formatter, marks syntax errors. You can Ctrl+click on table mentioned in SQL query to open that table (or index, or trigger, or view).</p> </div> </div> <div class="col-md-12 col-lg-6 mb-4 feature-card"> <div class="card h-100 bg-light"> <span class="card-icon feature glyphicon glyphicon-lock text-secondary" aria-hidden="true"></span> <h4 class="card-title">Encrypted databases</h4> <p class="card-text">Currently supported encrypted, password-protected SQLite variations are: <a href="https://www.zetetic.net/sqlcipher/">SQLCipher</a>, <a href="https://github.com/utelle/wxsqlite3">WxSQLite3</a> and <a href="https://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki">System.Data.SQLite</a>.</p> </div> </div> <div class="col-md-12 col-lg-6 mb-4 feature-card"> <div class="card h-100 bg-light"> <span class="card-icon feature glyphicon glyphicon-random text-secondary" aria-hidden="true"></span> <h4 class="card-title">Multiple databases seamlessly</h4> <p class="card-text">You can execute SQL statements that refer to multiple databases within single query, thanks to transparent database attaching mechanism built into the SQL Editor of SQLiteStudio.</p> </div> </div> <div class="col-md-12 col-lg-6 mb-4 feature-card"> <div class="card h-100 bg-light"> <span class="card-icon feature glyphicon glyphicon-cog text-secondary" aria-hidden="true"></span> <h4 class="card-title">Custom SQL functions</h4> <p class="card-text">You can implement your own SQL functions (scalar & aggregate) using JavaScript, Python or Tcl. There is repository of ready-to-use scripts on <a href="https://github.com/pawelsalawa/sqlitestudio/wiki/Scripts_repository">the wiki page</a>.</p> </div> </div> <div class="col-md-12 col-lg-6 mb-4 feature-card"> <div class="card h-100 bg-light"> <span class="card-icon feature glyphicon glyphicon-sort-by-attributes text-secondary" aria-hidden="true"></span> <h4 class="card-title">Custom collation sequences</h4> <p class="card-text">You can implement your own collation sequences (i.e. algorithms for comparing 2 values, that could be used in ORDER BY clause, etc).</p> </div> </div> <div class="col-md-12 col-lg-6 mb-4 feature-card"> <div class="card h-100 bg-light"> <span class="card-icon feature glyphicon glyphicon-time text-secondary" aria-hidden="true"></span> <h4 class="card-title">SQL & DDL history</h4> <p class="card-text">You need that query you executed 2 weeks ago? No problem. SQL Editor has a "History" tab. You need to upgrade production database the same way you did locally with SQLiteStudio? Use DDL History window - it has all DDL statements as executed by SQLiteStudio.</p> </div> </div> <div class="col-md-12 col-lg-6 mb-4 feature-card"> <div class="card h-100 bg-light"> <span class="card-icon feature glyphicon glyphicon-transfer text-secondary" aria-hidden="true"></span> <h4 class="card-title">D&D between databases</h4> <p class="card-text">You can Drag & Drop objects (tables, indexes, ...) between databases in order to copy or move them, with or without data.</p> </div> </div> <div class="col-md-12 col-lg-6 mb-4 feature-card"> <div class="card h-100 bg-light"> <span class="card-icon feature glyphicon glyphicon-modal-window text-secondary" aria-hidden="true"></span> <h4 class="card-title">Cross-platform</h4> <p class="card-text">Works on all 3 major platforms - Windows, MacOS X, Linux. Can be compiled from sources on other, less common platforms (like FreeBSD, ...).</p> </div> </div> <div class="col-md-12 col-lg-6 mb-4 feature-card"> <div class="card h-100 bg-light"> <span class="card-icon feature glyphicon glyphicon-compressed text-secondary" aria-hidden="true"></span> <h4 class="card-title">Portable distribution</h4> <p class="card-text">There is a portable distribution. No need to install it. Just download the package, decompress and run. No administrator rights are required.</p> </div> </div> <div class="col-md-12 col-lg-6 mb-4 feature-card"> <div class="card h-100 bg-light"> <span class="card-icon feature glyphicon glyphicon-save text-secondary" aria-hidden="true"></span> <h4 class="card-title">Data populating</h4> <p class="card-text">Do you need to test your application quickly with some pre-generated data? SQLiteStudio can populate tables for you with various strategies (constant, sequence, random number, random text, dictionary-based text, script code generated).</p> </div> </div> <div class="col-md-12 col-lg-6 mb-4 feature-card"> <div class="card h-100 bg-light"> <span class="card-icon feature glyphicon glyphicon-share text-secondary" aria-hidden="true"></span> <h4 class="card-title">Importing/exporting</h4> <p class="card-text">SQLiteStudio can import data from various formats (currently CSV or any text file using Regular Expression), or export to various formats (SQL statements, CSV, HTML, XML, PDF, JSON).</p> </div> </div> <div class="col-md-12 col-lg-6 mb-4 feature-card"> <div class="card h-100 bg-light"> <span class="card-icon feature glyphicon glyphicon-edit text-secondary" aria-hidden="true"></span> <h4 class="card-title">Scripting</h4> <p class="card-text">The application currently supports JavaScript, Python and Tcl scripting languages. Scripts can be used as generators for data populating, custom SQL functions, custom collation sequences).</p> </div> </div> <div class="col-md-12 col-lg-6 mb-4 feature-card"> <div class="card h-100 bg-light"> <span class="card-icon feature glyphicon glyphicon-th text-secondary" aria-hidden="true"></span> <h4 class="card-title">Plugins</h4> <p class="card-text">SQLiteStudio supports plugins of several categories. For example another scripting language can be added with plugin. Another import or export format, another table data populating strategy, another SQLite database format, SQL code formatter, code highlighter, table cell value representation renderer - all of these can be exteded with plugins.</p> </div> </div> </div> </div> </div> <footer class="py-2 bg-dark"> <div class="container"> <p class="m-0 text-center text-white"><a href="https://sqlitestudio.pl/about/" class="text-white"><u>Copyright © sqlitestudio.pl 2020</u></a></p> </div> </footer> <script src="https://sqlitestudio.pl/vendor/jquery/jquery.min.js"></script> <script src="https://sqlitestudio.pl/vendor/bootstrap/js/bootstrap.bundle.min.js"></script> <script src="https://sqlitestudio.pl/vendor/purify.min.js"></script> <script src="https://sqlitestudio.pl/vendor/marked.min.js"></script> <script src="https://sqlitestudio.pl/vendor/jquery.jscroll.min.js"></script> <script src="https://sqlitestudio.pl/vendor/clipboard.min.js"></script> <script src="https://sqlitestudio.pl/app/app.min.js?v=1592690948"></script> </body> </html>