[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    [sqlite] [ANN] SQLite Manager - Browser - Editor + Deep SQL
From:       "Me" <igiga () swbell ! net>
Date:       2006-07-31 17:52:01
Message-ID: 004901c6b4ca$06d76250$6401a8c0 () AMD64
[Download RAW message or body]

[ANN] SQLite Manager - Browser - Editor + Deep SQL

Windows/UTF-8 only.
www.sqlight.com

Four query views.
Transactions supported.

Table Edit
- complete editing flexibility. No limitation how a table is arranged for 
editing as long as Primary Key present.

- Lookup List
- Save Queries
- Save Defalut Query
- Ditto Columns
- Dupe Rows
- Save Table View Layout

Data Manager
Schema
- Tables
- Indexes
- Views
- Triggers
Tables
- Create
- Rename
- Drop
Index
- Create
- Rename
- Drop
Columns
- Add
- Drop
- Rename
- Reorder - change column order
- Redefine - completely redefine columns - (type, collate, default, not 
null, unique, check)


Blob Data
- Edit blobs as if a local file - Excel®, Word®, Photoshop®, etc...

Deep SQL
- BLOB-stored SQLite databases
Work on blob-stored SQLite databases - down to any level. DB stored in 
Row/Column of parent, that's stored in Row/Column of its parent, that's 
stored in Row/Column of its parent, etc... 
www.sqlight.com/features/deep-sql.html

This appears to be the only SQLite browser actually designed for editing 
tables.
Most (all the ones I've found) restrict you to editing tables in the 
original creation order.

SQLight supports editing any single table query (use WHERE, use ORDER BY) as 
long as the Primary Key is present.
"SELECT rowid,Cat,Sub,Item,Brand,Name,Dscrpt,Price,Sale,OnSale FROM Products 
WHERE OnSale='Y' AND Price>20 ORDER BY Cat,Sub,Item,Brand LIMIT 300"
This query can be edited.

www.sqlight.com

StanDurham
sd  (at)  sqlite DOT com

[prev in list] [next in list] [prev in thread] [next in thread]