Skip to content

mdmadonna/SQLite-Workshop

Repository files navigation

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.