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".
Johnattan Badden, Manager: "The software is easy to work with and most importantly, report management is extremely easy, even for a novice like me! I am able to create and edit my databases with a few clicks and easily maintain them afterwards. I highly recommend SQLite Maestro to educational institutions: it's easy and flexible, it is exactly what can be good for using in schools and colleges".
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.
Get a 20% discount for all our products and bundles till August 3!
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.
Feb 28, 2012
Peter Falkenberg Brown, one of Significatojournal.com editors, posted a review of SQLite Maestro.
Feature of the day
SQLite Maestro allows you to view SQLite data as charts with a possibility to export it to an image file.
You can make a copy of a database object by dragging it from one database to another in SQLite Maestro.