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). No administrator rights are required.ĭo 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). Just download the package, decompress and run.

Can be compiled from sources on other, less common platforms (like FreeBSD.). Works on all 3 major platforms - Windows, MacOS X, Linux. You can Drag & Drop objects (tables, indexes.) between databases in order to copy or move them, with or without data. 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. You need that query you executed 2 weeks ago? No problem. algorithms for comparing 2 values, that could be used in ORDER BY clause, etc). You can implement your own collation sequences (i.e. There is repository of ready-to-use scripts on the wiki page. You can implement your own SQL functions (scalar & aggregate) using JavaScript, Python or Tcl. 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. You can Ctrl+click on table mentioned in SQL query to open that table (or index, or trigger, or view).Ĭurrently supported encrypted, password-protected SQLite variations are: SQLCipher, WxSQLite3 and . The SQL Editor window assists user with SQL syntax hints & highlighting, provides pretty-print code formatter, marks syntax errors. It's safe, as anyone can review source code. It's free of charge for everybody, for any purpose (including commercial). SQLiteStudio is desktop application for browsing and editing SQLite database files.

Pdf highlighter for windows