What is the best approach for creating a DB.
Permalink
I am working on a website that will use a many blocks on many pages to create a Master Record Table and individual tables for client's accounts. I will be using Administrative pages with many blocks that will be used for managing and maintaining these tables, records, and accounts.
What would be the best overall approach to creating this database. If I created the database and Master Table with phpMyAdmin, is it possible to direct all queries using c5's methods to a database that exists outside of c5's database structure? Is there a better approach to this issue that allows c5 to create and manage the database on a global scale? What I have been reading, so far, in the documents is how to create the database when an individual block is installed for use with that block. If I do this with the first block I create, can the same database be accessed and manipulated across many blocks in many pages?
My mind is swimming with all the possibilities of how to do this so I am putting it out to the Forums to get input from veteran c5 coders with experience in database management. This should be a good discussion.
What would be the best overall approach to creating this database. If I created the database and Master Table with phpMyAdmin, is it possible to direct all queries using c5's methods to a database that exists outside of c5's database structure? Is there a better approach to this issue that allows c5 to create and manage the database on a global scale? What I have been reading, so far, in the documents is how to create the database when an individual block is installed for use with that block. If I do this with the first block I create, can the same database be accessed and manipulated across many blocks in many pages?
My mind is swimming with all the possibilities of how to do this so I am putting it out to the Forums to get input from veteran c5 coders with experience in database management. This should be a good discussion.
