SQLite-Workshop

Database Manager for SQLite

See Issues for current status. I am interested in feedback :-).

SQLite Workshop has a wide range of features and capabilities including:

1. Create a database.
2. Browse tables and views in a database.
3. Edit data within a database.
4. Clone a database.
5. Backup a database.
6. Optimize a database.
7. Vacuum a database.
8. Encrypt a database.
9. Create a Table.
10. Create an Index.
11. Create a View.
12. Create a Trigger.
13. Add a new Column to an existing table.
14. Delete a new Column from an existing table (Experimental).
15. Modify a Column in an existing table (Experimental).
16. Rename a Column in an existing table (Experimental).
17. Delete (Drop) a Table.
18. Truncate a Table.
19. Create template SQL to Create, Drop, Browse (Select), Update and Insert to a database.
20. Create an Index.
21. Rebuild an Index.
22. Delete an Index.
23. Create a simple View.
24. Edit a View.
25. Delete a View.
26. Create a Trigger.
27. Edit a Trigger.
28. Delete a Trigger.
29. Import from comma-delimited Text, SQLite, SQL Server, MS Access, ODBC, MySql and Excel.
30. Export to comma-delimited text.
31. Explain and Explain Plan.
32. Multiple Windows to view many tables at once.
33. Example Sql templates for a variety of common activities.
34. Load/Save SQL capabilities.
35. Register database locations.
36. Perform an in-depth analysis of a database.

All in a user friendly interface.