SQLiteManager Features Overview
SQLiteManager has a lot of powerful features not listed in this summary page:
- SQL syntax highlighting and autocompletion.
- Add, remove and/or change encryption on the fly.
- Load external sqlite extensions.
- Ability to open hidden files or bundles under OSX.
- Full-text search support.
- PDF exporting capabilities.
- Real-time BLOB preview.
- and much more!
Index, View and Trigger
Common operations like create a View a Index or a Trigger are made easy with a powerful and easy to use GUI. The same is true for the DROP sql statement. SQLiteManager will allow you to edit existing structs without the need to drop or re-create, most of the time.
When inline editing is not enough you can choose to use the powerful record editor. It contains many options to interact with your data, plus the ability to load and save values to a file. Record editor also has a built-in BLOB preview and loader.
cubeSQL is a powerful and fully featured SQL server built upon SQLite 3 database technology. SQLiteManager can easily connect to a remote server and provide you with access just like you would expect with local database files. Version 4 SSL connections with custom SSL certificates are supported.
Database Recovery enables you to perform an integrity check of the entire database. It looks for out-of-order records, missing pages, malformed records, and corrupt indices. If any problems are found, then detailed descriptions about the issues are reported. If the problem is serious you can consider using our SQLiteDoctor in order to repair and fully restore your corrupted databases.
Virtual Machine Disassembler
In order to execute an SQL statement, the SQLite library first parses the SQL, analyzes the statement, then generates a short program to execute the statement. The program is generated for a "virtual machine" implemented by the SQLite library. In order to have an in depth knowledge about what happens under the hood, SQLiteManager enables you to disassemble any SQL statement and a built-in inline description helps you to understand every single instruction.
From SQL to Chart
The Chart Panel allows you to easily visualize your queries in fully exportable PNG charts. Many charts are supported like Line Chart, Bar Chart, Pie Chart, Venn Chart, Scatter, Radar and even QR Code. Create an sql query which returns numbers and you can plot your data in 2D and 3D! Starting from version 4 charts are fully customizables.
Every time an sql statement is executed, SQLiteManager automatically records the statement within a separate log panel, allowing you to take a look and understand precisely what has happened to the data within your database.
Database Setting lets you inspect and change some internal database behaviour. It is just a shortcut to common PRAGMA commands like Auto Vacuum mode, Journal mode, Cache Size plus some more.
Importing capabilities are a very important aspect for any database management system. We have developed this feature to be flexible enough to satisfy all of your needs while maintaining an easy to use interface which can be setup within a matter of seconds.
SQLiteManager allows you to export data in several commonly used formats. The formats currently supported are CSV, SQL, tab-delimited and custom separator delimited. You can choose which tables / options to export and even apply a RegEx search/replace filter to every row before data is written to disk.
With this option SQLiteManager analyzes the internal database structure and reports how the data is physically distributed within the sqlite database. It reports very useful information which can help you decide whether a VACUUM is required in order to rearrange data and speed up queries.
Attachments made easy! With a dedicate attachments pane you can easily attach and detach all the databases you need!
SQLiteManager has a new built-in SQLite and Lua scripting language inline help.
A note is basically a way to add comments and information to a database. You can optionally decide to automatically display the new note each time the database is opened by SQLiteManager.