http://www.sqlight.com/
Complete Rewrite.
The only database manager for SQLite that allows query results to be edited
in a meaningful order!
Try editing the data returned from a simple query like this in any other
SQLite manager.
"SELECT rowid,Product,Name,Description,Price,SKU FROM Products WHERE
Price>29.99 ORDER BY Product,Name LIMIT 100"
Edit PhotoshopT, WordT and ExcelT documents stored as BLOBs in an SQLite
database.
Instant Query
- double-click table name
No Locks
- Queries never held open.
- The current value is retrieved when an item is clicked and changes
stored immediately
- the same table may be edited in various sort orders, simultaneously
Transactions supported
- BEGIN, COMMIT or ROLLBACK at any time
Four Query View Panels
- execute any SQLite query
- if a result is returned, it will be displayed
- any single table query with Primary Key may be edited
- Instant Query, double-click table name
- queries may be saved
- column view widths may be saved for table
Lookup List
- any Table/Column may serve as a lookup list
Dupes
- any row of the four query views may be marked for duplication
- Ctrl+D, dupe value from remembered row
- Ditto copies column above
External Text Editors Supported
- built-in text editor for editing column values
- any external Text or HTML editor may be used to edit text column values
- edit HTML with FrontPage - (tm)Microsoft
Blob
- Load and Save blob files
- any application may be use to view/edit a blob column value
- store and edit PhotoshopT documents in SQLite database
- store and edit WordT documents in SQLite database
- store and edit ExcelT documents in SQLite database
Schema Tool
- Schema Tool - Table
- view table creation SQL
- list columns in table - column definitions
- list all indexes associated with table - view SQL
- list all triggers associated with table - view SQL
- Schema Tool - Indexes
- view index creation SQL
- Schema Tool - Trigger
- view trigger creation SQL
- Schema Tool - View
- see View creation SQL
Table Tool
- Table Tool - Create
- select TYPE - edit list to suit
- text collation order
- Integer Primary Key
- Primary Key, ON CONFLICT, Order, Auto Increment
- set DEFAULT value
- set SQLite; CURRENT_TIME, CURRENT_DATE, CURRENT_TIMESTAMP
- NOT NULL constraint, select ON CONFLICT action
- UNIQUE constraint, select ON CONFLICT action
- define CHECK() constraint
- Table Tool - Rename Table
- Table Tool - Drop Table
- Table Tool - Clone Table
- clone another table's structure
- select columns to include
- Table Tool - Schema
- Table Tool - Indexes
- list associated indexes
- Table Tool - Triggers
- list associated triggers
Column Tool
- Column Tool - Add Column
- column Type - customize list
- text collation sequence
- set DEFAULT value
- select NOT NULL and ON CONFLICT action
- set CHECK() constraint
- Column Tool - Rename Column
- Column Tool - Drop Column
- Column Tool - Reorder Columns
- change column order in table
- Column Tool - Redefine Column
- completely change column definition
- change TYPE
- change text collation sequence
- set DEFAULT value
- set SQLite CURRENT_TIME, CURRENT_DATE, CURRENT_TIMESTAMP
- set NOT NULL constraint, select ON CONFLICT action
- set UNIQUE constraint, select ON CONFLICT action
- define CHECK() constraint
Index Tool
- Create
- unique constraint
- text collate
- sort order
- Drop
- Rename
- Edit SQL
- edit SQL statement and save changes
Trigger Tool
- Drop
- Rename
- Edit SQL
- edit SQL statement and save changes
View Tool
- Drop
- Rename
- Edit SQL
- edit SQL statement and save changes
File
- open SQLite Type 3 database
- open resent database
- create new database
- backup database
- VACUUM database
SQLite Version
- SQLite version may upgraded at any time by swapping SQLite DLL
Download 30-Day Trial
http://www.sqlight.com/
Purchase: $39.95
------------------------
Application Requirements
- Windows OS
- SQLite Type 3 database
------------------------
Not Supported
- Unicode
- UTF-16
- SQLite Type 2 database
------------------------
[EMAIL PROTECTED]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
