DbAssistant Changelog
What's new in DbAssistant 3.0
Oct 25, 2011- Direct SQL queries support added (old query constructor is now called 'Query Wizard');
- Results of SQL queries are now handled by mysql_fetch_row() instead of mysql_fetch_array();
- Webpage code generation mechanism changed - 'code' property was added to WebPage. Now you control code generation by specifying page HTML layout in its 'code' and use special control tags in it to include PHP code of DbAssistant objects stored under this webpage;
- Added loadable modules (plugins) support: now the functionality of DbAssistant objects may be extended by them;
- Fixed bug with textareas in SqlForm;
- Fixed bug with FormField field_value property;
- Build Website dialog added - now its possible to choose and build code for several pages at once;
- Square brackets are allowed in FormField names;
- Program translation support added (Language tab in Global Preferences dialog);
- Several loadable components are developed & shipped with DbAssistant 3.0 release:
- DbAdmin - component that allows to create PHP scripts that affect MySQL database structure;
- DbAuth - component that allows to control user sessions & privileges;
- MQForm [Multiple Queries Form] - component that allows SqlForm to execute several SqlQueries adding data to several tables, controlling data integrity;
- PF [Parametrized Form] - component that allows SqlForm to accept data from request and show it to user before he will enter any data;
- PSD [Parametrized Sql Display] - component that allows SqlDisplay to perform conditional SQL queries, accepting conditions from request;
New in DbAssistant 2.0 RC1 (Sep 14, 2011)
- Improved help system: lightweight text browser is now used (based on QTextBrowser), help files are moved under doc/ directory and could be easily modified or replaced
- User interface now has translation support (Qt Linguist tools could be used)
- User interfase was entirely changed:
- program objects are distributed in tree structure with dynamic binding, using Qt's Signal/Slots mechanism
- A new object SqlDisplay was added to SiteBuilder module
- Forms became more flexible:
- Forms now can have pre-/post- processing PHP code
- HTML templates are replaced with more flexible row_format property
- Form fields are now can have Javascript handlers
- Unlimited databases may be created with unique connect options
- Query fields conditions became more flexible
- Queries functionality are now divided by three explicit types (SELECT, INSERT,
- UPDATE)
- Stand-alone DataSource object added
- Query separated as a stand-alone object and could be easily bound to other objects such as Form, SqlDisplay and DataSource and be used by them collaboratively
- Escaping MySQL input data is now controlled by 'mysql_escape_sctring' flag in Global Preferences and could be set/unset in any time