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/ ]

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/ ]

-- *Anthony Stefan Maciejowski* *http://about.me/TonyMac <http://www.about.me/TonyMac>*

OK will do. Thanks. On Mon, Jan 13, 2014 at 4:14 PM, Jamie Holly <hovercrafter@earthlink.net>wrote:

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/ ]

-- *Anthony Stefan Maciejowski* *http://about.me/TonyMac <http://www.about.me/TonyMac>*

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.net>wrote:

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/ ]

-- *Anthony Stefan Maciejowski* *http://about.me/TonyMac <http://www.about.me/TonyMac>*