DBKiss - php database browser (mysql, postgresql)
DBKiss is a one-file PHP database browser that is easy to upload and use. It supports MySQL and PostgreSQL and features import/export of data, searching of the whole database or single tables, an advanced SQL editor, saving of templates, multi-query execution with pagination, and more.
Download
Version 1.06:
dbkiss.zip [28 KB] (2010-07-18) see changelog
License: BSD revised (free for any use)
Author: Cezary Tomczak ()
Subscribe to new releases: http://freshmeat.net/projects/dbkiss/
Did you know?
- That importing data from sql files is about x10 times faster than phpMyAdmin? I often had problems with executing sql larger than a few megabytes in phpMyAdmin, in most cases scripts hang up and makes it even impossible, using dbkiss you can do this in just seconds and it works.
- That dbkiss is compatible with mysql 3.23 through 5.x, so you can use it even on old servers with old mysql version? It also works on php4 and latest php 5.3 with most strict error reporting being set.
Notes
Some of the features in the SQL editor require creating 'dbkiss_sql' directory,
where history of queries is kept and other data. If the script has permission
it will create that directory automatically, otherwise you need to create that
directory manually and make it writable. At the top of dbkiss.php there is
defined constant called 'DBKISS_SQL_DIR', you can set it to empty '' string,
so the script won't try to create/use dbkiss_sql directory, but some of the
features in the sql editor will not work (templates, pagination).
Screenshot
Changelog
1.06 (2010-07-18)
- postgresql fix
1.05 (2010-05-21)
- export of all structure and data does take into account the table name filter on the main page, so you can filter the tables that you want to export.
1.04 (2010-02-20)
- exporting of all structure/data was fixed (ob_gzhandler flush bug)
- cookies are now set using httponly option
1.03 (2010-02-11)
- re-created array_walk_recursive for php4 compatibility
- removed stripping slashes from displayed content
- added favicon (using base64_encode to store the icon in php code, so it is still one-file database browser)
1.02 (2009-10-24)
- works with short_open_tag disabled
- code optimizations/fixes
- postgresql error fix for large tables
1.01 (2009-xx-xx)
- fix for mysql 3.23, which doesnt understand "LIMIT x OFFSET z"
1.00 (2009-02-10)
- bug fixes
- minor feature enhancements
- this release is stable and can be used in production environment
0.61 (2008-04-18)
- upper casing keywords in submitted sql is disabled (it also modified quoted values)
- sql error when displaying table with 0 rows
- could not connect to database that had upper case characters