Simple CRUD

Yes Studio has a code generator: CodeCharge. Similar to the .NET stuff (so I’m told). It gives you the ability to generate classes, forms, validations, etc. for around $150.

You ever wanted to edit your own tables and want to use TV-inputs for your table-fields?

Use richtext-TVs, dropdowns, image-TVs and so on or also custom-tv-input-types in your custom-table-Editor-Forms with xdbedit:

http://modxcms.com/forums/index.php/topic,56636.0.html

This looks like a really cool framework: XataFace (formerly known as “DataFace”). Its goals are much the same as SimpleCrud. It uses Smarty Templating to format data, and it can do reverse mapping of existing MySQL databases to generate its ORM files. It uses YAML style configuration files for easy editing. You can define validation for any field, and it handles foreign relationships fairly easily.

Kudos to the author! This is a nice project!

I came across an interesting article on HTML Sanitisation. This is a key component in any web application to help prevent malicious users from posting nasty data.

The “winner” seems to have been HTML Purifier, but it does require a lot of RAM and CPU. Here’s the list of the libraries evaluated:

• HTML Purifier
• Kses
• HTML_Safe
• htmLawed

Business Catalyst was purchased by Adobe and it is now their flagship CMS which requires integrated hosting. It uses a flexible templating system very similar to MODx: you can use any HTML/CSS you want or you can code templates for use with Flash sites. It’s not restrictive in this regard. The User Interface reminds me quite a bit of Expression Engine, although Business Catalyst seems to have approached custom URLs in a more sensible manner (EE has the sometimes awkward “Template Groups”).

The major disadvantage to Business Catalyst is that it is software as a service and therefore it restricts all types of custom coding. From the forums:

“We do not support php coding or any other custom code on our platform.”

This is prohibitive, to say the least. If you end up supporting a Business Catalyst site and need to do customizations, chances are good that you’ll be doing a lot of JavaScript coding, simply because that’s the only language left to you.

This is a framework relying on PHP 5′s PDO layer: PDO Crud. It looks pretty clean. There are some
examples for how to use this framework for CRUD interactions.

Here’s yet another PHP scaffold site: phpScaffold.com. You use their online page to generate 4 files per table, plus a config file.

Mongo is a document database — imagine a persistent way of retrieving any object you had stored in a PHP $_SESSION and you’ll have some idea of the flexibility of Mongo. There is an interactive shell, but it takes some patience to learn the query format — it doesn’t compare with the easy to remember pseudo-English commands used by MySQL, for example.

There are a few GUI’s being developed for Mongo — it’s tricky because there is no enforcement that says that one record must look like another in a collection. In the 2d world of relational databases, this is like saying that each row can have different columns. It’s a head trip.

http://blog.timgourley.com/post/453680012/tuesday-night-tech-mongodb-ui-edition

I found “the newest kid on the block”: PHP Fever. It’s a PHP 5.3+ Framework that uses namespaces (yes, namespaces). It implements ActiveRecord for database access.

Here’s a blurb that’s a bit easier to read: Intro to Fever.

I just found this: Evolutility.org. It’s a program that builds lightweight web applications ASP.net frameworks for CRUD access to MySQL and SQL server databases. They tout this as “dynamic scaffolding” or “metadata-driven MVC” that generates all web pages at run-time, and can be modified by editing metadata (screen definitions and database mapping) instead of code. So it sounds like a CRUD-centric framework.