Sqliteman Manage your Sqlite3 databases with this tool.
Download

Sqliteman Ranking & Summary

Sqliteman Tags

generator generate manage database SQL script create SQL script SQLite3 SQLite3 API SQLite3 library trigger manager manage SQLite3 database SQLite3 database manager explore SQLite3 database SQLite3 database explorer manipulate SQLite3 database

Sqliteman Description

Sqliteman is a straightforward and effective software solution especially intended for database administrators and users who need to manage, organize and create SQLite tables, views and indexes. It is able to personalize SQL statements, generate triggers and views, as well as administer the database index statistics.Intuitive and simple interfaceThe application enables you to quickly open a new SQLite file or simply create a new one by using the proper options from the File menu. Being divided into three sections, the main window displays all of the created databases, the proper scripts for each selected column, index or view, as well as the necessary information concerning each created table along with its SQL script. The left panel, entitled ‘Database’ provides you with a hierarchical-tree view from where you can manage and organize all of the available tables and views, while the right panels allow you to view the scripts for each database object and full-detailed information about each selected database. Useful editors for creating views and tablesThe application provides you with two ways of creating several database objects, here referring to tables, indexes, views and triggers. Whether you right-click on the proper object and choose the available option, or manually input the right SQL scripts and press the ‘Run’ button. In case you want to create a new table automatically, using the built-in functions, you can easily insert as many columns as you want by specifying their type and name. The ‘Advanced (SQL)’ tab enables you to view the generated scripts, which can be easily modified if you know how to work with such SQL queries. As a database administrator, you surely know what views are designed for. Unlike a table, a view (also referred to as a virtual table) is stored in a database as a query object; therefore, a view is an object that gathers its data from one or more tables. By accessing the ‘Create View’ option from the context menu, you are able to choose the database you are interested in, specify its name, then press the ‘Create’ button. This action will automatically generate the proper SQL scripts with no interaction from your side. A practical and straightforward SQLite manager and organizerTo wrap it up, Sqliteman proves to be an efficient solution that comes in handy for users who need to master SQLite databases by creating new tables, indexes and views. Reviewed by Cristina Jitaru, last updated on February 24th, 2014

Sqliteman Related Software