Sqlite Web Master

PHP Scripts - Sqlite Web Master - CodeCanyon

Sqlite Web Master his title this type of PHPScripts/Miscellaneous This time I will review,made by ser-html, PHPScripts/Miscellaneous is sold at a price of $16 in CodeCanyon.

database // management // sql // sqlite //

Created	20 July 13
Last Update	20 July 13
Compatible Browsers	IE7, IE8, IE9, IE10, Firefox, Safari, Opera, Chrome
Software Version	PHP 5.3, PHP 5.4
High Resolution	No
Files Included	JavaScript JS, HTML, CSS, PHP

More Info...Sqlite Web Master ..

1. Instruction

SQLite Web Master is a full-featured database management system for SQLite 3.X. It’s web-based, so you can manage your databases from anywhere. It’s powerful and easy to use. You can use it to manage multiple databases, design schemas, edit contents.

2. Demo

The demo is readonly. You can view schemas, contents.

http://www.craph.com/demos/sqlite/

username: admin password: admin

3. Features

• Manage Databases
  • You can manage database files and database groups.
  • You can manage database settings(pragmas) easily.
  • You can vacuum and download database files if you need.
• Design Schemas
  • Design Tables
    • You can add/change/remove columns
    • You can even reorder columns.
    • You can add/change/remove any constraint(foreign key/combined unique/check).
    • You can add/change/remove indices of a table
    • You can add/change/remove triggers
    • And all of these are using the visual editor. And SQL statements are highlighted.
  • Design Views
    • You can add/change/remove views
    • You can add/change/remove triggers of a view.
• Manage Tables
  • You can rename/empty/reindex/drop a table.
  • You can move/copy any table to any database file
  • You can populate a table with mock data with a powerful tool.
• Manage contents.
  • You can filter contents easily.
  • You can use the inline editor to edit a field on the content list page.
  • You can sort contents by any column.
  • You can view BLOB field as an image on the content list page.
  • You can edit content and even change data type.
  • You can edit BLOB field as you want.
• Import/Export Contents and Schemas.
  • Import
    • You can import data from a file: xml – csv – sql (- mdb – xls, under windows platform).
    • You can import data into a table or create a new one.
  • Export
    • You can export data to: xml – csv – sql
    • You can use custom SQL to export data to csv format.
• Run SQL Commands
  • You can use snippets.
  • You can edit the snippet file, add your snippets.
  • The command is highlighted.

4. Requirements

1. You need a web server (such as Apache, IIS, Nginx…) to host this application.
2. And PHP version is 5.3.3 or higher, with sqlite3 extension. When you use import/export, xmlreader/xmlwriter, iconv extensions are needed.
3. If you want to import MDB/XLS files:
   1. The application must run under MS Windows XP (or later) Platform.
   2. The PHP extension com_dotnet must be loaded.
   3. MADE must be installed. ( http://www.microsoft.com/en-us/download/details.aspx?id=13255 )
4. To access this application you need a web browser with cookies and javascript enabled.

5. Others

If you have any problem, or suggestion. Please feel free to contact me.

Download Link
Sqlite Web Master - Co ..