winget install --id PawelSalawa.SQLiteStudioAbout SQLiteStudio
SQLiteStudio is desktop application for browsing and editing SQLite database files. It is aimed for people, who know what SQLite is, or what relational databases are in general.
What's new in 3.4.21
- ADDED: #5466 Support foreign keys with implicit columns (proper values in FK combobox columns). - BUGFIX: #5472 Fixed updates cheking under Windows.
Version history
| Version | Updated | Notes |
|---|---|---|
| 3.4.21 | Unknown | - ADDED: #5466 Support foreign keys with implicit columns (proper values in FK combobox columns). - BUGFIX: #5472 Fixed updates cheking under Windows. |
| 3.4.20 | Unknown | Release notes |
| 3.4.19 | Unknown | - BUGFIX: #5443 Fixed data entering in Grid View after it has got broken in 3.4.18 (entering editing mode by starting to type jumped to wrong cell). - BUGFIX: #5447 Database object filtering improved - both speed (3x) an... |
| 3.4.18 | Unknown | - BUGFIX: #5308 Fixed handling true/false literals in expressions and on/off/yes/no literals in PRAGMA values. |
| 3.4.17 | Unknown | Release notes |
| 3.4.16 | Unknown | - ADDED: #5231 Added safe-mode command line option to bypass issues caused by corrupted session. - CHANGE: #5248 Database Export dialog has now Export Indexes and Export Triggers options, just like the Single Table Expor... |
| 3.4.15 | Unknown | - BUGFIX: #5218 Fixed Drag&Drop of items in the database list - a bug that was introduced in 3.4.14. - BUGFIX: #5216 Fixed Query Executor to use Smart Execution Method when there is a Virtual Table mentioned in the query... |
| 3.4.14 | Unknown | - ADDED: #5190 Added support for optional ORDER BY and LIMIT clauses in UPDATE and DELETE statements. - ADDED: #5190 Added support for AS clause in INSERT, UPDATE and DELETE statements. - CHANGE: #5187 Backported compila... |
| 3.4.13 | Unknown | - BUGFIX: #5183 Fixed completer proposals in the column names of the INSERT INTO statement. - BUGFIX: #5184 Fixed completer to show tables from implicitly attached database in case of 'SELECT other_database.' - BUGFIX: S... |
| 3.4.12 | Unknown | - BIGFIX: #5179 Fixed results returned from query joining the same table twice. - BIGFIX: #5179 Fixed smart execution when joining tables with USING clause, so the result metadata is extracted properly and results can be... |
| 3.4.11 | Unknown | Release notes |
| 3.4.10 | Unknown | Release notes |
| 3.4.9 | Unknown | - BUGFIX: #5148 Fixed executing queries that refer to tables with database prefix (i.e. dbName.tableName). - BUGFIX: #5149 Relaxed recent limitation on requiring Custom SQL Functions to have unique names, so that names c... |
| 3.4.8 | Unknown | - CHANGE: #5146 If user enters a relative file path to the database dialog, a warning will issued to the user pointing out actual resolved path for the relative path entered. - BUGFIX: #5145 Fixed Extensions Manager cras... |
| 3.4.7 | Unknown | - CHANGE: #5131 SQLite updated to 3.47.1 (except for SQLCipher, which is still on 3.46.1 at the moment). - BUGFIX: #5119 Fixed very bad performance of import() function executed from SQL Editor. - BUGFIX: #5124 Fixed Scr... |
| 3.4.6 | Unknown | Release notes |
| 3.4.5 | Unknown | - ADDED: #4974 Extension-based collations (like the ICU) can be now registered in databases using Collations Editor window. - ADDED: #5041 Added support for column list syntax in CREATE VIEW. - ADDED: #4774 Added checkin... |
| 3.4.4 | Unknown | - ADDED: #3488 SQLite ICU extension is boundled into binary packages (thanks to @tuffnatty). - ADDED: #4697 Added a 'Restore original hotkey' buttons at keyboard shortcuts page of configuration dialog. - ADDED: Added sql... |
| 3.4.1 | Unknown | - CHANGE: #4585 SQLite updated to 3.40.0 (except for SQLCipher, which has latest version 3.39.2). - BUGFIX: #4600 #4587 Fixed very slow loading of data in tables with foreign keys. - BUGFIX: #4549 Query executor column a... |