SQLite Sorcerer

A small SQLite administration application
Download

SQLite Sorcerer Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Freeware
  • Publisher Name:
  • Arnaud FOUCAL
  • Operating Systems:
  • Windows 2K / XP / 2003 / Vista / Vista64 / 7 / 7 x64
  • File Size:
  • 766 KB

SQLite Sorcerer Tags


SQLite Sorcerer Description

The SQLite Sorcerer can help you to perform the main administration tasks on your SQLite database. Give QLite Sorcerer a try to fully assess its capabilities! Main features: Database: Create a new database from scratch Compact, analyze / deanalyse a database Encrypt and rencrypt using a password or an existing hashed key. Open recent databases by double-click or drag and drop from a list You can compare the structure of 2 databases! Just open a second database and the comparison is done! The result of the comparison is displayed in a datagrid with details Get the whole structure of the database: SQL or XML (highlighted code) Tables: Create, delete, rename, copy with or without data Edit the structure of a table (use the context menu or double click) Changing all attributes of fields is allowed, including default values Add, delete or rename fields Define conflict clauses View the highlighted SQL code and copy it into the clipboard Data: Add, delete or edit records directly in a data grid (double click then navigate in the grid) Filter data using keyword or regular expression View all data or use chunks to browse table content Empty tables Export data from tables or queries into CVS or TXT files (right-click on the grid) Import data from a CSV or TXT file Queries: Type your own sql and check the results Add fields or table names by double click or drag&drop in the SQL text area Save your query as a new view Re-execute your queries using the History Import a SQL file Your SQL code is highlighted ! The query panel can be detached from the application This allows you to work in the query panel while having a look on the database: structure, full data… Views / Triggers: Create new one Views can be created from a popup button or from the query panel Delete or rename existing ones View the corresponding SQL code and copy it into the clipboard


SQLite Sorcerer Related Software