SQLiteManager is a comprehensive database management system which allows you to work with a wide range of databases and helps you perform basic operations such as create and edit tables, triggers and many more.
SQLiteManager is a "next generation" GUI database manager for SQLite databases, it combines an incredible easy to use interface with blazing speed and advanced features.
SQLiteManager allows you to open and work with sqlite 2.x, sqlite 3.x, in memory databases and REALSQL Server databases. It allows you to create and browse tables, views, triggers and indexes. It enables you to insert, delete and updates records in a very intuitive way and it supports you arbitrary SQL commands.
SQLiteManager's report generation system is flexible enough to let you generate reports in just about any format you can imagine (report generation can actually be used to export data in just about any format you need). You create the report templates using a report template language and then generate reports by pouring SQL query results into the templates.
Here are some key features of "SQLiteManager":
· 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.
· Common operations like create a View a Index or a Trigger are made easy with a powerful and easy to use GUI.
· When inline editing is not enough you can choose to use the powerful record editor.
· 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.
· Detailed Analyzer
· Database Attachments
Limitations:
· Queries, Import and Export will be limited to maximum 20 rows
· Print limited
· Nag screen
What's New in This Release: [ read full changelog ]
· Fixed a vertical scrollbar issue.
· Fixed an import issue into a new table where first row was not properly converted to column names.
· Fixed an issue with new rows in Record Editor.
· Updated sqlite to the latest 3.7.16.1 version.
· Added UNICODE61 tokenizer.
· MacOS X version now requires 10.7 or higher.