Subscribe to our news:
Jacob Lyohne, Director of Development: "Regarding implementation, it is pretty self-explanatory and the SQLite Maestro manual is helpful for review and reference. We also found the on-line documentation useful and the software support staff readily available to answer our questions. Reports are very easy and quick to run and can be broken down into any number of statistical combinations".
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
You can select several database objects in the Object Manager of SQLite Maestro to perform the same operation upon all of them at a time.
SQLite Maestro provides you with Object Browser for sorting, filtering and grouping of database objects.