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".
Ron D.: "I'm still very happy with SQLite Maestro and Data Wizard; makes my HTPC database much easier to manage".
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.
We're happy to grant you a 20% discount for all our products and bundles till September 4.
Say good-bye to summer with great savings on high-quality DBA tools!
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.
Nov 26, 2012
New version features enhanced FTS table management, support for XML and GUID data types, redesigned start page, improved SQL Editor and data grids, 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.
Data Analysis tool allows you to quickly analyze SQLite tables data that has been summarized into multidimensional views and hierarchies.