Are you not thrilled about how difficult it is to process SQLite databases? Don’t you just wish there were a graphic user interface utility that could handle all SQLite database management issues quickly and easily? If the answer to either of these questions is “Yes”, then you should download a free trial version of SQLite Analyzer. This tool is a comprehensive SQLite database processor that allows editing or modifying SQLite tables visually without any risk of losing data. Plus, there are no table size restrictions! Add tree-like database structure display, easy database navigation, syntax highlighting, instant script generation and you will understand why SQLite professionals are switching to SQLite Analyzer in droves. In addition, SQLite Analyzer is capable of connecting to multiple databases simultaneously and displaying multiple record sets. The program also manages triggers and indexes. Importantly, the program is fully customizable. You can choose font and color properties for the sql editor and the result grid, save and load SQL scripts to/from files, view query result in the grid or in the text.
SQLite Analyzer is incredible easy to learn and use. Any person familiar with SQL can start operating the program right away without special training or wasting time reading manuals. SQLite Analyzer is very affordable, priced at only 99 US Dollars (volume buyers receive significant discounts).
- Support SQLite 2.x and 3.x versions.
- Support of all SQLite commands. It is possible to execute all SQL operators and commands of SQLite. On win32 platforms, SQLite Analyzer is a complete alternative for the console utility sqlite.exe and provides all the advantages of graphical interface at the same time: syntax highlighting, font and color customization, clipboard support, multilevel undo system, visual result display…
- Visual database management. It is not longer necessary to write long scripts to create (edit, delete) tables, indexes, triggers. All these and other operations can be performed with a few mouse clicks.
- Import data from other databases. It is possible to import data from other databases via OLE DB providers.
- Registration of frequently used databases in SQLite Analyzer. To work with SQLite, you have to specify the path to the database. This approach is not convenient when you often work with some database. SQLite Analyzer makes it possible to specify the path just once when you are registering the database. It will always be available afterward.
- Displaying the database structure in the form of a tree. The object structure in registered databases is displayed in the form of a tree: the list of tables and views; column names, data types, default values; triggers, indexes.
- Quick generation of INSERT, UPDATE, DELETE, SELECT scripts for the selected object. Such a script can be either placed onto the clipboard or opened in a new window for execution.
- Visual creation and modification of table structures without losing already existing data. SQLite does not support the ALTER TABLE command that is why when you modify the structure of a table (add a new column, for example), you have to delete the existing table and create a new one after that. SQLite Analyzer will automatically delete the old table, create a new one and move the data.
- Editing data in tables of any size.
- Managing indexes and triggers. All properties of indexes and triggers are specified with a few mouse clicks.
- Using its own «sqlite.dll» libraries. SQLite Analyzer has one of the last sqlite.dll versions included in it. Nevertheless, if you need to use your own sqlite.dll version, it is enough just to copy your sqlite.dll version to the working folder of SQLite Analyzer.
- Displaying the query results in the form of a table or text. It is often necessary to run debugging scripts in the process of developing and debugging an application. SQLite Analyzer allows you to execute several SQLite commands at a time, including several SELECT operators. In this case several query results will be displayed. The query result can be presented in the form of a table or text. No matter in which form the results are presented, it is always possible to copy them onto the clipboard and save them to a file.
- Executing scripts in a separate thread. SQLite commands are executed in a separate thread. This makes it possible to run several scripts at a time. You can interrupt a script that is executed for too long.
- OS: Windows 98/NT/2000/XP/2003;
- SQLite - sqlite.dll version
2.x or 3.x.