Magento

Can someone explain to me how the DB is linked to the code
how do i retrieve data? and how do i insert data?

is there a class that does this?

Unfortunately not as easy as that.  At the very lowest level is the Zend Database Framework.  Varien abstracts that to implement it’s database functions.  On top of that are the various module’s and how they access it.  There is a resource model that holds functions to access the database that is specific to the XML configuration setup for each module.  Here is the code to run direct queries on the database.  Not the most correct way but it will work.

-Adam

thanx, this might be useful
but i wanted to understand the normal flow of the db communication

the one recommended and used by the magento team
so i can understand how to communication from my module

Since there hasn’t been a lot of communication about that and most of the community is struggling it’s way through it, it is tough to say.  The “correct” way is to create your new module and then using models implement the calls and functions you need and then as you said in your other post, use the get, set, has, uns naming to call what you need.

-Adam

but the set get dont reflect in the database
they store the data in the array _data

where and when does the sync happen between the db and the array? or it doesn’t sync?

Did you find anything about that?