How to store JavsScript code from .js file, as stored procedure, in MongoDB

Question

There are a couple of examples of how to create "stored procedures" in MongoDB (here is one) but they only show how to add the code directly, for example in the mongo shell. For any nontrivial stored procedure one would want to store the code in a .js file and 'import' the file into MongoDB. That way it can be easily edited, versioned, etc.

Is there a way to do this?

What are you trying to accomplish? (Using the technique in the linked blog post is specifically not recommended by 10gen : docs.mongodb.org/manual/applications/server-side-javascript) Running JS within the DB isn't recommended in MongoDB currently. It's not designed with a "Stored Procedure" model. — WiredPrairie
– WiredPrairie, Commented Feb 14, 2013 at 21:03
I would like to call a single mongodb function from my webserver, that performs multiple queries before returning a final result, without having to go in and out of the database because of interim data. It's odd that 10gen discourages this practice and then provides nice documentation and api support to do it. — user1332148
– user1332148, Commented Feb 14, 2013 at 21:27
Its not "nice", you must use eval which is not a native API for the execution of JS functions, it is much like hacking it to do something it isn't supposed to using a global lock and function which can't be used across shards. Stored procedures are so rarely needed and so frequently abused in databases that support them. I would make sure that you actually get any performance at all from using them. As for getting them to work, I am unsure how you can performantly atm. — Sammaye
– Sammaye, Commented Feb 14, 2013 at 21:54

Kirill Zorin · Accepted Answer · 2013-02-14 22:25:01Z

3

You can use following syntax:

$ mongo mydb import.js

And writing import instructions inside a script, i.e:

var myfunc = function(x, y){ return x + y; }}

db.system.js.save({_id:"myfunc", value: myfunc);

answered Feb 14, 2013 at 22:25

Kirill Zorin

2391 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to store JavsScript code from .js file, as stored procedure, in MongoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related