SQLite Developer 3.43

SQLite Developer 3.43 presents a powerful database manager that will manage sqlite3 database!

Major Features:

1. Power SQL Editor
   • Sqlite Sql Syntax Highlight
   • Sql history
   • Sql keyword autocomplete
   • Parenthesis matching
     
   • Table/View/Field Autocomplete
     
   • Live Sql Syntax Check
     
   • Unicode support
     
2. SQL Formatter
   
3. Supports ansi, unicode data encoding and decoding.
4. Customizable Data Type Mapping.
5. Execute multiple sql separated by semi colon.
6. Execute sql script with parameters.
7. Master Detail Browser.
8. SQL Monitor.
9. Visual Query Builder.
10. Visual tables ,views ,trigger and index management.
11. View and edit field as Text , Hex , HTML or bmp, jpeg, gif.
12. View and edit temporary tables, views and triggers.
13. Memory Database support
    
14. Query plan.
15. LiveUpdate.
16. Export data to sql,csv,excel, word, html, xml.
17. Import / Export
    
    • Import data from csv, sqlite database and ado datasource.
    • Extract db schema and data.
    • Backup/Restore Database.
18. Treeview style db explorer with smart filter
19. Attach and Detach databases
20. support encrypt and decrypt database  (encrypted databases are compatible with System.Data.SQLite )
21. RTree and ICU support 
22. Find in Database Schema
23. Cancel long-time query
24. Support loadable extension and virtual table
25. Multi Languages support(English, Japanese, Simple Chinese)

Enhancements:

• [DBA] Updated: support quick check command
• [DBA] Updated:Add view support to Master Detail Browser
•  [DBA] Add view support to master detail browser - closed.
• [DBA] Add quick check support - closed.
• [DBA] Master-Detail Table Browser - closed.
• [DBA] upgrade to sqlite 3.6.14.2 - closed.
• [DBA] execute paramerize query with $ parameter will report no such column error - closed.
• [DBA] upgrade to sqlite 3.6.14 - closed.
• [SQL Editor] Allow input parameter in sql - closed.
• [SQL Editor] live syntax check does not report error for some sql - closed.
• [SQL Editor] Display Modified line on Gutter - closed.
• [Unicode] restore ansi table name and field name support which was removed from version 3.00 - closed.
• [GUI] show different icon for key field - closed.
• [DBA] open db as memory database - closed.