SQLite Expert Professional 3.0

Features and Benefits

• Edit tables and views visually, without writing a line of SQL. Easily restructure fields, indexes, constraints, triggers without losing data already existing in the tables.
• Build SQL scripts and generate views visually using the integrated Query Builder.
• Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) databases.
• Easily transfer data between SQLite databases, import data from SQL scripts or ADO data sources, or export to SQL scripts.
• Display and edit data in the grid, including BLOB and image fields. Currently supports BMP, JPG and PNG image formats. BLOB fields can be edited with the integrated hex editor.
• Execute SQL queries and display results in the grid or as text.
• Generate HTML reports from data displayed in the grid.

New in 3.0: printing support A recent feature introduced in version 3.0 is printing support. The content of any grid can be sent to the printer or exported to a PDF file.

Customize look and feel using skins Also introduced in version 3.0 is the ability to customize the look and feel of the application using skins. Currently 27 different skins are available. Note that the printing system is aware of the current look and feel.

SQL Query Builder If you are not an SQL expert but want to create complex queries visually, you can use the integrated Query Builder to generate SQL SELECT queries in a visual interface.

Executing SQL Queries SQLite Expert allows users to easily execute SQL scripts and display the results in the grid or as text. The result set is also editable if all columns in the selection query are from one table. SQLite Expert supports syntax highlighting, saving and loading scripts to/from files, SQL history, and interrupting the execution of long running queries.

Displaying and editing data in the grid SQLite Expert allows users to insert, delete and edit the table data in the grid. You can just click a grid cell and modify its value. Clicking on the "Post" button in the navigator panel will save the data to database. You can use Up, Down, PageUp and PageDown keys to traverse the grid cells.

Displaying data as text You can also display a table or a query result set in text format.

Table design: Field editor SQLite Expert allows restructuring tables without losing data already existing in the tables. Restructuring a table is wrapped in a nested transaction which is rolled back if any error occurs when applying changes to the table.

Table design: Index editor Indexes can be added, deleted, modified and renamed visually. SQLite Expert supports index field collation and reordering, primary, unique and autoincrement indexes and conflict clause editing.

Table design: Foreign key editor SQLite introduced full support for foreign keys in version 3.6.19. Beginning with version 2.2, SQLite Expert allows editing of foreign keys visually. Foreign keys can be added, deleted and modified.

Table design: Trigger editor Triggers can be added, deleted, modified and renamed visually.

Table design: Check constraint editor Check constraints can be added, deleted, modified and renamed visually.

Table design: Unique constraint editor Unique constraints can be added, deleted, modified and renamed visually.

View design Views can be added, deleted, modified and renamed visually. Temporary views are supported.

Image editor If a column holds an image, it can be opened in an Image Editor as shown in the screenshot. Currently supports BMP, PNG, JPG, GIF and ICO formats.

Hex editor The content of any field can be displayed and edited in a hex editor.

Importing and exporting data SQLite Expert currently supports the following methods for importing and exporting data: Import data from SQLite, SQL script, ADO data source using the Data Transfer Wizard. Import data from text files (CSV, TSV). Export data to SQLite, SQL script using the Data Transfer Wizard. Export data to text files(CSV, TSV), XML, HTML or Excel. Transfer tables between SQLite databases using drag and drop. Transfer records between SQLite tables or to Excel via clipboard.

Manage SQLite Extensions Load and unload SQLite extensions. Auto extensions are supported in the Professional Edition. SQLite Expert offers the unique feature to display the functions and collations installed by any SQLite extension.

Table design: Record editor A recent feature is the record editor, very useful for tables with a large number of columns.

• Edit on unlimited tracks with frame accuracy in HD and/or advanced stereoscopic 3D
• Create eye-popping effects with Red Giant Filmmaker’s Toolkit and Motion Graphics Toolkit
• Add excitement with over 2000 2D/3D additional effects
• Includes green screen for shooting with superimposition in mind
• Create Dolby® 5.1 surround Blu-ray™/DVD discs and export to your favorite digital devices and formats
• Organize, tag, and rate your favorite clips and music with the built-in media library
• Enhance and correct movies, photos and audio right inside the media library
• Preview timeline and source clips simultaneously
• Use the trim editor to set source clip in/out points, then drag trimmed clips to the timeline for perfect cuts—just like the pros
• Import clips and movie projects from Pinnacle Studio for iPad²
• Quickly learn to make great videos using the included video tutorial DVDs
• Storyboard quick first drafts—even create movies automatically
• Layer animations and titles easily with included Montage templates
• Create custom-fit soundtracks with Scorefitter
• Share HD and 3D videos on Facebook®, YouTube®, and Vimeo® with one click
• Store projects and clips in the cloud to access anywhere, anytime—includes 50 GB³ of cloud access free from Box
• Zip through projects via 64-bit, NVIDIA® CUDA™, and Intel® Quick Sync Video optimization
• Access video and photos from HD camcorders and digital devices—even 3D
• Easily archive and restore your work with Project Packages

 

 

• Compatible with Windows® 8
• Import, edit and export videos in AVCHD™ 2.0 Progressive (50p/60p) format
• Slow & fast motion effects
• Optimized for 16:10 & 16:9 widescreen displays
• Hundreds more easy-to-use creative effects (design templates, effects, disc menus…)
• Express and Advanced editing modes
• Export videos faster with GPGPU hardware acceleration
• Output videos faster with SmartEncoding
• Easily make Hollywood-quality Blu-ray Discs™ or DVD-Video™ discs with menus, navigation, graphics & text
• Easily find and manage your videos, photos and music, and playback virtually all file formats and DVDs with Nero Kwik Media included with Nero Video 12
• Stream your movies throughout your home network with Nero Kwik Media 

Features