Does anyone know of a good book covering how to work with databases and drupal?
Thanks Tony
Not sure what you mean here. Are you talking about writing code using the drupal database API db_query, etc.? If so Drupal Pro Development is a good start. Perhaps you’re talking about using working with external non-drupal databases? Or something else?
Dave
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Tony Sent: Monday, January 13, 2014 3:37 PM To: support@drupal.org Subject: [support] Databases
Does anyone know of a good book covering how to work with databases and drupal? Thanks Tony
--
Anthony Stefan Maciejowski
Drupal 7 Module Development has a couple of good chapters on developing modules that create and use entities, and there is another book out there on Drupal 7 Entities that I have yet to tackle. I would also love to see something that shows how to implement "No SQL" high demand Databases like Mongo or Cassandra. While I know I'm missing lot's on these newer flavors of database systems, I can't help but wonder if Drupal will ever run on a "No SQL" platform, or if that is where we are all headed. First glance suggests that perhaps Entity Classes will provide the keys to transitioning.
On Mon, Jan 13, 2014 at 3:38 PM, Metzler, David metzlerd@evergreen.eduwrote:
Not sure what you mean here. Are you talking about writing code using the drupal database API db_query, etc.? If so Drupal Pro Development is a good start. Perhaps you’re talking about using working with external non-drupal databases? Or something else?
Dave
*From:* support-bounces@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *Tony *Sent:* Monday, January 13, 2014 3:37 PM *To:* support@drupal.org *Subject:* [support] Databases
Does anyone know of a good book covering how to work with databases and drupal?
Thanks
Tony
--
*Anthony Stefan Maciejowski*
*http://about.me/TonyMac http://www.about.me/TonyMac*
-- [ Drupal support list | http://lists.drupal.org/ ]
There's a module for MongoDB:
https://drupal.org/project/mongodb
And CHX has been working hard on Mongo for D8. Here's his sandbox:
https://drupal.org/sandbox/chx/1831048
Getting Drupal to run on No SQL really isn't all that bad. That big thing will be getting all the contributed modules out there to do their queries in a way that can easily be translated over to No SQL. You start throwing things like map reduce and aggregation into the mix, and that is enough to put off some module maintainers.
Jamie Holly http://hollyit.net
On 1/13/2014 6:52 PM, Warren Vail wrote:
Drupal 7 Module Development has a couple of good chapters on developing modules that create and use entities, and there is another book out there on Drupal 7 Entities that I have yet to tackle. I would also love to see something that shows how to implement "No SQL" high demand Databases like Mongo or Cassandra. While I know I'm missing lot's on these newer flavors of database systems, I can't help but wonder if Drupal will ever run on a "No SQL" platform, or if that is where we are all headed. First glance suggests that perhaps Entity Classes will provide the keys to transitioning.
On Mon, Jan 13, 2014 at 3:38 PM, Metzler, David <metzlerd@evergreen.edu mailto:metzlerd@evergreen.edu> wrote:
Not sure what you mean here. Are you talking about writing code using the drupal database API db_query, etc.? If so Drupal Pro Development is a good start. Perhaps you're talking about using working with external non-drupal databases? Or something else? Dave *From:*support-bounces@drupal.org <mailto:support-bounces@drupal.org> [mailto:support-bounces@drupal.org <mailto:support-bounces@drupal.org>] *On Behalf Of *Tony *Sent:* Monday, January 13, 2014 3:37 PM *To:* support@drupal.org <mailto:support@drupal.org> *Subject:* [support] Databases Does anyone know of a good book covering how to work with databases and drupal? Thanks Tony -- */Anthony Stefan Maciejowski/* */http://about.me/TonyMac <http://www.about.me/TonyMac>/* -- [ Drupal support list | http://lists.drupal.org/ ]
Exactly the first scenario.I have that book but it doesn't really go into the detail I need. As you say it is a good start. But I need a good finish.
I have created a module with a form which should CRUD (can one say that?) to a table I have defined in the install file. If I could just find some sample code... How to insert (I know db_insert etc but what about the return codes and messages etc etc) .
Thanks
On Jan 13, 2014 3:39 PM, "Metzler, David" metzlerd@evergreen.edu wrote:
Not sure what you mean here. Are you talking about writing code using the drupal database API db_query, etc.? If so Drupal Pro Development is a good start. Perhaps you’re talking about using working with external non-drupal databases? Or something else?
Dave
*From:* support-bounces@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *Tony *Sent:* Monday, January 13, 2014 3:37 PM *To:* support@drupal.org *Subject:* [support] Databases
Does anyone know of a good book covering how to work with databases and drupal?
Thanks
Tony
--
*Anthony Stefan Maciejowski*
*http://about.me/TonyMac http://www.about.me/TonyMac*
-- [ Drupal support list | http://lists.drupal.org/ ]
I could probably do it a different way as far as the module is concerned but I just wanted to practice basic DB ops. Another topic of discussion would be "when do I need to write code to access the DB"? Not having had too much experience in that area I may be posing a superfluous question.
Tony
On Mon, Jan 13, 2014 at 4:06 PM, Tony tony@tony-mac.com wrote:
Exactly the first scenario.I have that book but it doesn't really go into the detail I need. As you say it is a good start. But I need a good finish.
I have created a module with a form which should CRUD (can one say that?) to a table I have defined in the install file. If I could just find some sample code... How to insert (I know db_insert etc but what about the return codes and messages etc etc) .
Thanks
On Jan 13, 2014 3:39 PM, "Metzler, David" metzlerd@evergreen.edu wrote:
Not sure what you mean here. Are you talking about writing code using the drupal database API db_query, etc.? If so Drupal Pro Development is a good start. Perhaps you’re talking about using working with external non-drupal databases? Or something else?
Dave
*From:* support-bounces@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *Tony *Sent:* Monday, January 13, 2014 3:37 PM *To:* support@drupal.org *Subject:* [support] Databases
Does anyone know of a good book covering how to work with databases and drupal?
Thanks
Tony
--
*Anthony Stefan Maciejowski*
*http://about.me/TonyMac http://www.about.me/TonyMac*
-- [ Drupal support list | http://lists.drupal.org/ ]
Check out the DBTing part of the examples module:
https://drupal.org/project/examples
Jamie Holly http://hollyit.net
On 1/13/2014 7:06 PM, Tony wrote:
Exactly the first scenario.I have that book but it doesn't really go into the detail I need. As you say it is a good start. But I need a good finish.
I have created a module with a form which should CRUD (can one say that?) to a table I have defined in the install file. If I could just find some sample code... How to insert (I know db_insert etc but what about the return codes and messages etc etc) .
Thanks
On Jan 13, 2014 3:39 PM, "Metzler, David" <metzlerd@evergreen.edu mailto:metzlerd@evergreen.edu> wrote:
Not sure what you mean here. Are you talking about writing code using the drupal database API db_query, etc.? If so Drupal Pro Development is a good start. Perhaps you're talking about using working with external non-drupal databases? Or something else? Dave *From:*support-bounces@drupal.org <mailto:support-bounces@drupal.org> [mailto:support-bounces@drupal.org <mailto:support-bounces@drupal.org>] *On Behalf Of *Tony *Sent:* Monday, January 13, 2014 3:37 PM *To:* support@drupal.org <mailto:support@drupal.org> *Subject:* [support] Databases Does anyone know of a good book covering how to work with databases and drupal? Thanks Tony -- */Anthony Stefan Maciejowski/* */http://about.me/TonyMac <http://www.about.me/TonyMac>/* -- [ Drupal support list | http://lists.drupal.org/ ]
OK will do. Thanks.
On Mon, Jan 13, 2014 at 4:14 PM, Jamie Holly hovercrafter@earthlink.netwrote:
Check out the DBTing part of the examples module:
https://drupal.org/project/examples
Jamie Hollyhttp://hollyit.net
On 1/13/2014 7:06 PM, Tony wrote:
Exactly the first scenario.I have that book but it doesn't really go into the detail I need. As you say it is a good start. But I need a good finish.
I have created a module with a form which should CRUD (can one say that?) to a table I have defined in the install file. If I could just find some sample code... How to insert (I know db_insert etc but what about the return codes and messages etc etc) .
Thanks
On Jan 13, 2014 3:39 PM, "Metzler, David" metzlerd@evergreen.edu wrote:
Not sure what you mean here. Are you talking about writing code using the drupal database API db_query, etc.? If so Drupal Pro Development is a good start. Perhaps you’re talking about using working with external non-drupal databases? Or something else?
Dave
*From:* support-bounces@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *Tony *Sent:* Monday, January 13, 2014 3:37 PM *To:* support@drupal.org *Subject:* [support] Databases
Does anyone know of a good book covering how to work with databases and drupal?
Thanks
Tony
--
*Anthony Stefan Maciejowski*
*http://about.me/TonyMac http://www.about.me/TonyMac*
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Pretty much the books others have said. There's not really a specialized book, as there really isn't anything specialized with how Drupal handles databases. That's mostly due to the fact that Drupal is able to function on different databases. The database documentation on DO is really some of the best too:
https://drupal.org/developing/api/database
For more generic reading, anything on PDO will be really helpful, as it will give you the basic idea of how PHP and databases communicate. Also any general MySQL book to help learn the basic ideas behind relations, transactions and building optimized queries.
Jamie Holly http://hollyit.net
On 1/13/2014 6:36 PM, Tony wrote:
Does anyone know of a good book covering how to work with databases and drupal?
Thanks Tony
--
*/Anthony Stefan Maciejowski/*
Thanks. I did take another quick look at Pro Drupal Dev and see I forgot the chapter on DBs. Must re-read. I would recommend this FREE online course at Stanford too. https://www.coursera.org/course/db Starts tomorrow actually. It is really an excellent resource and can be revisited whenever in the future.
On Mon, Jan 13, 2014 at 4:10 PM, Jamie Holly hovercrafter@earthlink.netwrote:
Pretty much the books others have said. There's not really a specialized book, as there really isn't anything specialized with how Drupal handles databases. That's mostly due to the fact that Drupal is able to function on different databases. The database documentation on DO is really some of the best too:
https://drupal.org/developing/api/database
For more generic reading, anything on PDO will be really helpful, as it will give you the basic idea of how PHP and databases communicate. Also any general MySQL book to help learn the basic ideas behind relations, transactions and building optimized queries.
Jamie Hollyhttp://hollyit.net
On 1/13/2014 6:36 PM, Tony wrote:
Does anyone know of a good book covering how to work with databases and drupal?
Thanks Tony
--
*Anthony Stefan Maciejowski*
*http://about.me/TonyMac http://www.about.me/TonyMac*
-- [ Drupal support list | http://lists.drupal.org/ ]
-
Jamie Holly -
Metzler, David -
Tony -
Warren Vail