Free dbi script

Requirements:

• DBD:mysql
• DBI

AxKit makes the separation of content and presentation a practical reality. The pipelining technique that AxKit uses allows content to be converted to a presentable format in stages, allowing certain platforms to see data differently to others. AxKit allows web designers to focus on web site design, content developers to work on a purely content basis, and webmasters to focus on their core competencies.

AxKit is based on components that are replaceable. This allows the web site developer to create a completely custom XML Application Server based around the AxKit API. AxKit can either automatically provide caching facilities, or you can create yThe toolkit also provides ability to build component based web sites, and dynamic content.

Database integration is fully supported, allowing either delivery of XML from a database, or XML generation from a database query. Dynamic web components can be built using the Perl language, making the possibilities as infinite as CGI scripts, without the potential mess that CGI programming can cause.

Major Features:

1. XSLT based pipelined XML transformations
2. Standards base stylesheet selection criteria
3. Output in more than 180 different character sets (although browser support means that only about 10 of those are useful).
4. XSP support for the Perl language, including Perl DBI based SQL taglib
5. Built in Perl interpreter no more CGI overhead
6. Plug-in API All components are replaceable with custom components.
7. Support for almost every platform around: Linux, Solaris, HPUX, AIX, Windows NT, BeOS, *BSD, VMS.
8. Intelligent caching technology means yDeliver to different media using the sames set of URLs for all media types. Media types supported are: Screen (web browsers), Handheld (such as palmtop computers and mobile phones), TV (for example Skys "Open", or Microsofts WebTV), braille, aural, print, projection and tty (for text-only browsers).
9. GZipped output encoding great for slower links

Major Features:

1. Sequel provides thread safety, connection pooling and a concise DSL for constructing database queries and table schemas.
2. Sequel also includes a lightweight but comprehensive ORM layer for mapping records to Ruby objects and handling associated records.
3. Sequel supports advanced database features such as prepared statements, bound variables, stored procedures, master/slave configurations, and database sharding.
4. Sequel makes it easy to deal with multiple records.
5. Sequel currently has adapters for ADO, Amalgalite, DataObjects, DB2, DBI, Firebird, Informix, JDBC, MySQL, ODBC, OpenBase, Oracle, PostgreSQL and SQLite3.
   

Enhancements

• Add Dataset #set_defaults and #set_overrides, used for scoping the values used in insert/update statements
• Allow Models to use the RETURNING clause when inserting records on PostgreSQL
• Raise Sequel:DatabaseError instead of generic Sequel:Error for database errors, dont swallow tracebacks
• Use INSERT ... RETURNING ... with PostgreSQL 8.2 and higher
• Make insert_sql, delete_sql, and update_sql respect the :sql option
• Default to converting 2 digit years, use Sequel.convert_two_digit_years = false to get back the old behavior
• Make the PostgreSQL adapter with the pg driver use async_exec, so it doesnt block the entire interpreter
• Make the schema generators support composite primary and foreign keys and unique constraints
• Work with the 2008.08.17 version of the pg gem
• Disallow abuse of SQL function syntax for types (use :type=>:varchar, :size=>255 instead of :type=>:varchar[255])
• Quote index names when creating or dropping indexes
• Dont have column accessor methods override plugin instance methods
• Allow validation of multiple attributes at once, with built in support for uniqueness checking of multiple columns
• In PostgreSQL adapter, fix inserting a row with a primary key value inside a transaction
• Allow before_save and before_update to affect the columns saved by save_changes
• Make Dataset#single_value work when graphing, which fixes count and paginate on graphed datasets