Archive
Pending release of CRUDDER
I’m currently still optimizing and debugging a fresh release of Crudder, e.t.a of this release will be somewhere around the midst of March.
Changes:
- Updates without any affected_rows will not trigger an error anymore, SQL-errors are still caught though
- MultiLinked fields _should_ work better on MSIE, but you never know; IE sucks at being any kind of predictable (and all other things a browser should do).
- Language-settings of the interface-texts actually work
- new feat: thouroughCheck; checks whether a table has non-nullable fields and will make those fields mandatory
- new feat: exporting data to CSV (currently the output with default-settings is suitable for openOffice)
- new feat: Advanced filtering / Querybuilder
Announing Crudder
I needed a simple, easy to implement and lightweight library to allow a customer to Create, Read, Update and Delete (CRUD) records in a databas
e. Nothing special here; i could have made a custom PHP-script for this, takes 2 to 3 hours of tedious and annoying work. Instead I googled for something that could do this with minimal configuration, has a small footprint and uses ajax. I ran into fullblown frameworks, with a lot of configuration, or small projects, written spaghetti-style, lot of them a PIA to implement without having to search/replace for paths & includes.
So; I decided to create something like this myself, without a large PHP-Framework, completely written OOP-style (including the Javascript) and when finished it should be able to run with approx. 4 lines of code (not counting the table-definition).
The idea is quite simple; the UI is generated from javascript, no PHP here, configuration is done by one XML file, which contains both controlling-values (theme, language, connectionstring) and the table-definition (which fields to display, what kind of editor to use).
What will you need to run Crudder?
- A LAMP-server (prolly work on IIS-PHP too)
- PHP compiled with DOM and XSL-t-extensions
What 3rdparty code will be used:
- Prototype.js
- ADODB5 (the lite-version will prolly work, I will test this)
- TinyMCE
Check out crudder.net
