What is mySiteMaker?
mySiteMaker is a collection of CGI tools written in Perl for rapidly creating web interfaces to MySQL database tables. The primary goal of this project is to make accessing data in database tables as easy, convenient and simple as possible.
mySiteMaker began as a "Lite" version of phpMyAdmin, which may sound silly and pointless because phpMyAdmin is such a great tool for administrators, BUT sometimes phpMyAdmin is overkill; especially when you want a web front end to a database and the intended users are the general public and not administrators. Since its initial release many new features have been added to mySiteMaker and it now offers functionality not found in phpMyAdmin.
mySiteMaker also provides a great way to create a rough sketch of a web interface to databases which can then be easily customized to your specific needs.
Latest News
2005-04-23
- mySiteMaker 4.6.1 was released on 2005-03-17. Missing files were added.
- Christopher is working on more goodies.
2005-03-16
- mySiteMaker 4.6 released. Stupid installation and new_site.cgi bugs have been fixed, and thanks to Christopher Zorn, there is now a REST interface. (See the documentation and the CHANGELOG).
2005-03-04
- mySiteMaker 4.5 released. Docs cleanup, translation files changed, cosmetics, bugfixes for hide_query, hidden columns, and menu creation code. CHANGELOG
2005-01-14
- mySiteMaker 4.3 release
- Fixed bug where 0 causes blank field output, and bugs in searching for null/empty fields.
- Better timeout messages, and internationalised. Translated most of the French phrases using google. Mon Francais est mauvais.
- File upload has been working since about 4.2 or 4.1.
- COLUMN_HEADERS might be fully implemented. Bug reports needed.
- RSS output module
- Basic access control-- removed roles. See CONF_MODS How-to in docs/
2004-10-29
- mySiteMaker 4.2 released.
- Fixed indirect relations bugs, removed debugging prints.
- Caching the statement handles and enabled searching for indirect relations
- Insert/delete/edit roles
- Fixed record counting code
2004-10-18
- mySiteMaker 4.1 released. See CHANGELOG on sourceforge.
2004-09-10
- mySiteMaker 4.0 final release -- it's just rc6.
2004-09-03
- mySiteMaker 4.0 rc6 has been released.
- Does file uploads again
- Fixed potential bug in Query->where()
- Available in CVS on sourceforge
2004-07-12
- mySiteMaker 4.0 rc4 has been released.
- Release candidate 4 has better documentation, minor bugfixes.
- Installation works
- Available in CVS on sourceforge
2004-04-16
- mySiteMaker 4.0 alpha has been released.
- Complete re-write except for the new site setup code.
- Better indirect relation support.
- Alpha TEST release. Do NOT use in production. This release has been minimally tested.
- New dependencies on various Perl modules.
- No CHANGELOG. Working towards better documentation and standardised package (CHANGELOGs, READMEs, docs, installers, possibly a .deb release -- coming up in 4.0 final, tentative release date: summer 2004).
- (2004-07-13) New maintainer: Satya
2003-08-15
- mySiteMaker 3.9 has been released.
- Bug fixed for proper URL encoding of values.
- Additional dependancy on Spreadsheet::WriteExcel::Simple
2003-03-25
- mySiteMaker 3.8 has been released.
- Changed install script to allow user to specify relative CGI and HTML directories.
- Added feature to limit access to "mysites" to a specific URI.
- Now uses relative URL's throughout.
- Improved transport of data from the database to your desktop
- Additional dependancy on Text::CSV_XS
2002-09-27
- mySiteMaker 3.7.1 has been released to fix a major bug in limit_fields.cgi.
2002-09-27
- mySiteMaker 3.7 has been released. Stylesheet support!
2002-03-07
- mySiteMaker 3.6 has been released. Check out the changelog.
2001-10-04
- 3.5 is available. Please see the Changelog for new features and changes.
2001-07-27
- I'm in the final stages of debugging the new version. So far so good. Look for it this coming monday (July 30th).
2001-07-13
- A few users have sent me a handful of bug fixes and, as usual, it seems I'm totally rewriting things... So, along with the bug fixes, I'm working on making it possible to join in columns from other tables (a popular demand) beyond the rudimentary mechanism used to allow data entry via a pulldown menu or radio buttons. Look for a new release before the end of the month.
2001-05-14
- 3.2, now available. We now have a Serbian language translation. I've added the ability to create canned queries, or pre-defined queries. I've also consolidated the code so that it is easier to maintain.
2001-05-14
- 3.1 is out! It's got the return results as XML feature and a handful of bug fixes. Checkout the changelog.
2001-05-08
- I've finally added the "Return results as XML" option. You will see this in the next version which is due in the next week or so or you can just grab the new stuff from the mySiteMaker CVS repository.
2001-05-01
- Version 3.0 is out! Check out the changelog for a full list of changes. Highlights include:
- Query Logging
- Support for PostgreSQL
- Support for more MySQL data types
2001-04-27
- Putting the final touches on version 3.0. Look for an official release this coming Monday.
Documentation
- README - General information about how to install and use mySiteMaker.
- CONF_MODS-HOWTO - Using additional configuration file parameters to customize your database interface.
- CANNED_QUERIES-HOWTO - Creating (pre-defined) queries for mySiteMaker.
- JOINING TABLES-HOWTO - How to join tables with mySiteMaker.
- SECURE SITE-HOWTO - How to limit access to a mySite.
- LOGGING-HOWTO - Obsolete.
Databases
mySiteMaker currently supports these databases:- MySQL
- PostgreSQL (legacy, may no longer work)
Multi-Lingual Support
mySiteMaker has multi-lingual support. The well maintained or recently translated languages are listed below. Feel free to help add additional languages. If you do, send me your changes and I'll include them with the next release!
- English
- Italian - Submitted by Marco Masini
- Serbian - Submitted by Branko Ivanovic
- Spanish - Submitted by Sandor Saiz
- German - Partially translated by Satya via Google
- French - Partially translated by Satya via Google
Links
- MySQL -- The database that mySiteMaker was originally based on.
- MySQL Import -- A simple web-based tool for importing data into MySQL database tables. It has the ability to create new databases and new tables on the fly. This is very useful for rapid prototyping.
- MySQL Users -- A simple web-based tool for creating new users and granting them privileges.
- MySQL Tool Suite -- A web page that combines MySQL Import, MySQL Users and mySiteMaker on a single page. It also describes how the three tools can be used to convert a spread sheet into an interactive web-site.
- IT-Lab@MUSC -- This is where mySiteMaker started out. The site hosts a number of other useful, web-based tools.
- Frank Starmer says it worked for him out of the box!
- FSF has a directory page which is slightly out of date.
- http://jmvanel.free.fr/db-cms/ thinks sitemaker can be used as a Content Management System. with the advent of 4.6.*, this is becoming a reality.
- Brian the binary nomad
Support
- mysitemaker-users: a list for users to discuss user issues and new features.
- mysitemake-devel: a list for mySiteMaker developers.
- Bug Reports: need to report a bug you've found?