SQLite Developer 3.38

SQLite Developer 3.38 offers an effective tool which helps you to 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, utf8 and utf16 data encoding and decoding.
4. Customizable Data Type Mapping.
5. Execute multiple sql separated by semi colon.
6. SQL Monitor.
7. Visual Query Builder.
8. Visual tables ,views ,trigger and index management.
9. View and edit field as Text , Hex , HTML or bmp, jpeg, gif.
10. View and edit temporary tables, views and triggers.
11. Query plan.
12. LiveUpdate.
13. Export data to sql,csv,excel, word, html, xml.
14. Import / Export
    • Import data from csv, sqlite database and ado datasource.
    • Extract db schema and data.
    • Backup/Restore Database.(New)
15. Treeview style db explorer with smart filter
16. Attach and Detach databases
17. support encrypt and decrypt database  (encrypted databases are compatible with System.Data.SQLite )(New)
18. RTree and ICU support
19. Find in Database Schema
20. Cancel long-time query
21. Support loadable extension and virtual table
22. Multi Languages support(English, Japanese, Simple Chinese)

Enhancements:

• Add Data Tabsheet to View Editor - closed.
• No response after clicking the help button in options and create database form(regression of ver3.00) - closed.
• Add help button to import/export wizard - closed.
• Upgrade to sqlite 3.6.13 - closed.
• Add Field Node to DB Explorer - closed.
• Multi selection bug introduced in version 3.00 - closed.
• There were only 80 charecters( ANSI ) was imported successfully for each column when importing csv to db - closed.
•  There is no confirmation message popuped after clicking the close button after index edited was changed - closed.
• Add Page and FreeList Count display - closed.
•  Add node hint to Database Explorer - closed.
• Put sqlitedev.hql to application data folder to improve vista compatibility - closed.
• Add Max Page Count Setting - closed.
• Show row number in indicator of dbgrid - closed.
• Upgrade to sqlite 3.6.12 - closed.
•  Restore ansi Data Encoding support which was removed from version 3.00 - closed.
• EXCEPTION:Too many fields, or too many long string fields in this record.You must increase the internal record size of the csvDa - closed.
• Add hot backup and restore database wizard (sharpplus) - closed.
• Can't open encypted database - closed.
• Fileds types are lost when Importing northwind database from SQL Server 2005 - closed.
• After fixed the problem with performance, the filter was not worked as expected - closed.

Requirements: Wins