| |||||
SQLiteManager is a GUI database manager designed for sqlite databases featuring an intuitive interface and powerful processing capabilities.
SQLiteManager gives you the possibility to open and work with sqlite 2, sqlite 3, AES 128 encrypted databases, in memory databases and REAL Server databases.
SQLiteManager can be used to create and browse tables, views, triggers and indexes. You can easily insert, delete and updates records and it also supports your arbitrary SQL commands.
SQLiteManager also has a flexible report generator whereby you can create virtually any text report (including HTML and XML) using a powerful template language.
NOTE: To buy SQLiteManager via the App Store an Apple account is required.
Here are some key features of "SQLiteManager":
· SQLite2 and SQLite3 support.
· Browse tables, views, and indexes.
· Add and drop columns from existing tables.
· Create new tables, views, indexes.
· Drop tables, views, indexes.
· Manage tables by inserting, editing, and deleting records.
· Type arbitrary SQL and see the results of queries.
· Save SQL.
· Ability to convert SQLite 2 databases to SQLite 3.
· ReportGenerator classes you can add to your project.
· Create reports with flexible report templates.
· Report generation can actually be used to export data in just about any format you can imagine.
· Import and export data to/from CSV and tab-delimited formats.
· Powerful GUI - The true power of SQLiteManager is its simple and intuitive interface, all the main features are just a click away and most of the time very complicated command line commands are wrapped inside a simple button. The same interface is used in both the MacOS X and Windows version and you can also purchase a multiplatform license in order to better work with your multiplatform databases.
· Bug Reporting - SQLiteManager has a built-in bug reporter that automatically appears each time a crash bug will occurs in the application. In this way we can be notified in real time of the possible application bugs and we can fix them very soon.
· Print Preview - Thanks to a new and powerful print engine you can now customize and preview all your prints. BLOB images are automatically recognized and printed and all the print engine is driven by simple SQL queries that you can customize in any time. Built-in PDF exporting capabilities on both MacOS X and Windows is a must.
· Database Recovery - Instead of typing complicated command line commands, SQLiteManager allows you easily check the integrity of your databases and it can also summarize all the issues encoutered during the check. At the same time with just a click the database can be recovered or dumped to a brand new file if the issue is particulary serious.
· Chart Panel - The new Chart Panel allows you to easily visualize your data with Line Chart, Bar Chart, Pie Chart, Venn Chart, Scatter, Radar, Map and even QR Code. Just type a simple sql query and you can plot your data in 2D and 3D!
· Print Options - Powerful and easily accessible print options allows you to completely customized your pages in order to obtain stunning reports based on very simple sql queries.
· Scripting Language - A built-in scripting language based on RBScript (a Basic like scripting language) enables you to write plugins and to automate repetitive tasks inside SQLiteManager. You can also share your plugins with others SQLiteManager's users. Please note that it also supports dynamic loading of native sqlite extensions!
Limitations:
· Maximum rows returned by a query: 50.
· Maximum columns: 5.
· No database conversion.
· Import and export disabled.
What's New in This Release: [ read full changelog ]
· Application has been rewritten from scratch.
Universal Binary