Subscribe to our news:

 Partners
 Testimonials
Ron D.: "I'm still very happy with SQLite Maestro and Data Wizard; makes my HTPC database much easier to manage".
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".
More
Add your opinion
 Customers
|
SQLite Maestro online Help
Input SELECT query
To get an OLAP cube, enter SELECT query as a snowflake schema, represented by centralized fact tables (with numeric data) which are connected to multiple dimensions (the numeric data to be categorized by). Input the query text in the SQL Editor area directly or use "drag-n-drop" operation SQL Editor or Visual Query Builder areas and the Query tab of Data Analisis.

|
 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
SQLite Maestro provides you with Object Browser for sorting, filtering and grouping of database objects.
You can make a copy of a database object by dragging it from one database to another in SQLite Maestro.
|
|