New features of DB and dsql planned for ATK 4.0

Wednesday, June 9th, 2010|Brainstorming, Version 4|by Romans|

Based on our current usage and user feedback we are preparing to start development on a new database layer. Thanks to new cool features in PHP (PDO) it’s going to be real easy. However we plan to add some exciting new features such as:

  • Rely on PDO, DSN format will change
  • Single-table dsql. You can still use joins, which will create multiple dsql instances and make them work together seamlessly.
  • Automatic alias management.
  • Database driver decides when to fetch data and how.
  • Clone-friendly
  • Multi-table update() and insert(). MySQL have some support for multi-table update, but this feature will take it to a whole new level.
  • Support for simple storage such as SimpleDB. Database engine will allow to compensate for missing [R]DB features.
  • dsql Implementation of Iterator, Countable, Seekable and more for nice syntactic sugar.
  • Much stricter towards field use. Do not allow developers to slip in any SQL logic.
  • Support for expression objects. Similar to $this->js(), this will allow you to build sql operators and functions dynamically
  • Proper support for sub-selects. Sub-select being another dsql query.
  • Better debugging
  • Automated tests
  • Transaction support.

Read more

Tags: ,

Symfony 2.0 vs Agile Toolkit 3.8 – part 4 – Bundles, Users, DB

Wednesday, May 19th, 2010|Misc|by Romans|

This post continues comparison of Agile Toolkit and Symfony 2.0. This post is based on features described in Quick tour – page 4
Read more

Tags: , ,