synodinos / nodepal Goto Github PK

I noticed the MySQL client library supports a '?' placeholder in queries:
https://github.com/felixge/node-mysql

You may want to consider using placeholders to avoid SQL injection. (thanks to damz for passing this along.)

Would be great if nodepal could work with db prefixes too.

I couldn't get this to work with Node 0.49.

Sessions being stored in mysql is still a pretty big problem. Is the idea to port the sessions mongodb module to D6, or perhaps port nodepal forward to D7. Personally I rather have the latter.

Maybe it's also possible to add a caching function to nodepal to cache sessions in mongo after 1 fetch from mysql.

What do your plans look like?

I have a php script that currently calls drupal_bootstrap_session in order to validate against users.

Can I do the same thing in javascript with nodepal?

That is, access the $node and $user objects? Or do I have to select directly from mysql.

Thanks.

will be there api functions to create and update cck nodes / interact with views / users / system ?

wouldn't it be better if we interact with drupal services (rest/json server) ?

Hi,

looking at https://github.com/synodinos/nodepal/blob/master/nodepal.js#L198 I've noticed that the only case covered is that of one field for one node type.

It is definitely a good practice to keep separate fields for different node types as everything sits in the content_type_nodeType table and there are less joins when getting the data, yet some setups have the field shared by more than one node type. And that results in the field data in a separate table all-together (content_field_fieldName).

Not entirely sure how one would cover this without another query, but in a module the solution is http://stream.zerolab.org/post/472787229/proper-custom-queries-with-drupal-cck-fields

How do we do this?

I have an apache server, do I alter .htaccess to enable particular urls for node?

Please give full instructions. Thanks!