SQLite Expert Professional 5.4.62.606 Portable

Download Now

SQLite Expert is a powerful tool designed to simplify the development of SQLite3 databases. It is a feature rich administration and development tool for SQLite designed to answer the needs of all users from writing simple SQL queries to developing complex databases.

Features SQLite Expert Professional:

• Visual SQL Query Builder
  – Build complex SQL queries with ease.
  – Formatted SQL query text layout.
  – Powerful means of SQL query parsing and analysis.
  – Advanced SQL editor with syntax highlighting and code completion.
• Data editing
  – Edit data in the grid using powerful in-place editors.
  – Image editor currently supporting JPEG, PNG, BMP, GIF and ICO image formats.
  – Visualize and modify BLOB fields using the integrated Hex editor.
• Powerful restructure capabilities
  – Visual editors for table columns, indexes, foreign keys, triggers, unique and check constraints.
  – Restructure any complex table without losing data.
  – Any restructure operation is wrapped in a nested transaction which is rolled back if any errors occur when applying changes.
  
• Import and Export data
  – Import data from ADO data source, CSV files, SQL script or SQLite.
  – Export data to CSV files, SQL script, Excel or SQLite.
  – Copy tables between SQLite databases using drag and drop operations.
  – Export data to Excel via clipboard.
• Other features
  – Full Unicode support.
  – Support for attached databases.
  – Supports SQLite extensions and third-party SQLite libraries.
  – Lua and Pascal scripting support.

SQLite Expert Professional Version 5.3

• Added support for UPSERT clause.