Creating custom modules and database communication

[mattiaspiiri]

Hi!

I would like to start a discussion here about the best way to create a custom module and the best way to communicate with the database.

I am in the process of writing an AJAX-based module to store en fetch data, i.e calls and meetings, from the database. I figure the right approach is to use SugarBeans. However, I am not that familiar with SugarBeans and would appreciate some helpful hints to get things done the right way.

I´ve been reading in the forum and the developer guide about this and think this is a little defuse part.

Thanks in advance!

[andopes]

Please, clarify in details all features you want to accomplish.

Kind regards

[mattiaspiiri]

I´m developing a jQuery calendar that will be able to create data and fetch data from meetings and calls from the database. All necessary data that you´d like to se in the calendar.

I´ve created a module like it says in the Sugar Developer Guide under Custom Bean Files(http://developers.sugarcrm.com/docs/...r.html#9000205). Right now I´m using custom queries for retrieving data from the database, but this would probably be a problem when creating new meetings and calls. And I want the module to support all databases that are supported by SugarCRM. I would like to use jQuerys $.getJSON() and $.post(), to get data and post it with JSON.

Hope this is a better description!

Thanks!