Subscribe to our news:

 Partners
 Testimonials
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".
Mark Worsnop: "By the way I wanted to say thank you for a good software package. It's a pleasure to work with Maestro as it "just works" and makes my job that much easier".
More
Add your opinion
 Customers
|
SQLite Maestro online Help
Data Management
Query results and table data are displayed on the Data or Result tabs of Table Editor, SQL Editor or Visual Query Builder.
Data are displayed as a grid (or as info cards) which provide a lot of useful features such as editing, grouping, sorting, filtering, etc. See Data View for details.
Navigation bars of these tabs as well as popup menus of their working areas places at your disposal the following functions for managing data:
• | Export Data allows you to export data to various formats, including MS Excel, MS Access, RTF, HTML, PDF and more. |
• | Get SQL Dump exports data to the SQL script as a number of INSERT statements. |
• | Import Data provides you with possibility to import data from MS Excel, MS Access, DBF, XML, TXT, and CSV. |
• | Edit BLOB allows you to view and edit the content of BLOB and TEXT fields. |
|
 Company news 
May 5, 2021
New version introduces new database encryption algorithms, support for generated columns, support for renaming and dropping columns using ALTER TABLE statement, and some other enhancements.
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.
 Feature of the day
Data Analysis tool allows you to quickly analyze SQLite tables data that has been summarized into multidimensional views and hierarchies.
All editors of SQLite Maestro provide a customizable ability to divide text into logical parts (regions). Each part can be collapsed and extended.
|