Subscribe to our news:
Ephraim Stevens : "I just wanted to re-iterate what a wonderful job your developers have done and what a wonderful product SQLite Maestro is. There are so many great things to say about it that I won't go into here. It saves an end user a lot of time on repetitive tasks. Keep up the excellent work over there".
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".
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.
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 allows you to view and edit BLOB data in several different representations.
SQLite Maestro provides an ability to export your data to any of 14 available data formats.