Lately i'm going deep in MongoDB and i'm wondering about the stored JavaScript Procedures. After reading the Blog Entry from PointBeing, i got some questions.   Is it a real advantage to store my code in DB? I mean functions like lookups for...
I am working with Azure Cosmos DB, I am programming the client side in C# (web service) and I'm writing some server side Stored Procedures with java-script.  How can I debug my stored procedure's code?  Thanks,  MAK...
Is it possible to use javascript promises instead of regular callbacks within CosmosDB (DocumentDB) stored procedure API calls? An usage would be implementing pagination.  For example  token = getToken(); doSomething(token);      //.... function getT...
I am having an issue with getting correct output from plv8.elog(). Just to start, I'm using PostgreSQL 9.2, plv8 1.4.1 as installed by pgxn, on Ubuntu 12.10. I have a function I am building that includes nested cursor loops and uses a number of p...
I have been using C# to run operations on a DocumentDB instance and really like it so far.  I have a lot of C# code that queries from multiple collections to create new collections from the relationships between the first two collections.  Can I esse...
I have a DocumentDB stored procedure that does insert or update (not replace but rather reads and update existing document). The stored procedure does at most two operations:   query by Id and  either insert or update   The document is also not parti...
I am trying to check if there are duplicates in a collection. New to stored procedures and azure database, so for now am trying to count distinct entries. If count distinct (column name) = count (column name), there are no duplicates, so I am trying...
Trying to return table from PLV8 stored procedure.  It fails to recognize input args i.e. $1 when the function is with  RETURNS TABLE(...).  It works when function returns scalars:  psql# CREATE OR REPLACE function foo(integer)        RETURNS integer...
I have stored procedure that should accept few different parameters. Based on parameters query will return desired results. However, there is one filter that I'm not 100% sure what would be the best option to choose. Here is example:    $('#f...
I am trying to write a stored procedure with a Merge statement.  It looks something like this:  create or replace procedure database.events.insert_groupss() returns string LANGUAGE JAVASCRIPT as $$ var sql_cmd = 'Merge into database.events.groups...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.