Subscribe to our news:
Gianmarco Brundo: "I have purchased SQLite Mestro and SQLite Data Wizard, your products are very good".
Mario Figueiredo: "I can safely forget all I know about SQL when using SQLite Maestro. It is that easy and intuitive to use. It is also nicely drawn with an easy and appealing interface that makes the sometimes boring tasks of database maintenance and administration more endurable.
The decision to support the non-commercial use of your software with a lower price is absolutely worth mentioning. For that alone, I thank you. For everything else, I say keep up the good work".
Add your opinion
SQLite Maestro online Help
SQL Editor provides you with several variants of the query executing.
|•||To execute all statements of the text area with result data, click the Execute query item of the Navigation bar or use F5, F8, or F9 shortcuts. Statements of each tab of SQL Editor are executed together in a separate thread in order to continue your work with the software while the query is executing. |
|•||You can also execute query as script (Shift+F5, Shift+F8, Shift+F9). In this case the query does not return data. |
|•||To execute only a selected part of the query text, use Execute selected only or the Alt+F5, Alt+F8, Alt+F9 shortcuts.|
|•||There is also a possibility to execute a statement at the cursor position. For this purpose, use the Execute at cursor link at the Navigation bar or use the Ctrl+F5, Ctrl+F8, or Ctrl+F9 shortcuts.|
If the query text is correct, the query is executed, and if the query statement is supposed to return data (e.g. SELECT statement), the Result tab opens with the data returned by the query. If an error occurs while executing the query, execution stop is stopped and the appropriate error message is displayed in the Information tab.
The Result area displays the result data in grid. All principles of working with data you can find in Data Management section.
Nov 14, 2016
New version introduces support for FTS5 extension and expression-based indexes, new encryption algorithms in data grids, updated data export and data import tools, and some other useful things.
Jan 12, 2015
New version comes with support of user authentication and management, read-only database connections, colored tabs, and some other new features.
Mar 12, 2014
Features enhanced constraint management, support for various data storage modes and WITHOUT ROWID tables, updated Data Import and SQL Dump tools, nullable column checker, some performance and usability improvements, and a lot of other useful things.
Feature of the day
SQLite Maestro provides you with Object Browser for sorting, filtering and grouping of database objects.
SQLite Maestro: You can save frequently used queries to the database profile and use them as usual database objects.