Questions tagged [compose-db]

DO NOT USE FOR THE ANDROID JETPACK COMPOSE (use [android-jetpack-compose] for those questions!) Compose is a Database as a Service (DBaaS) provider that offers cloud-based databases (MongoDB, Elasticsearch, RethinkDB, Redis, PostgreSQL).

94 questions
1
vote
2 answers

Node.js Date Objects stored in MongoDB as "1970-01-01T00:00:00.001Z"

I have a Node.js application and I'm using Mongoose to interface with MongoDB on Compose.io. Here's some code that should store the current date and time in my database: signup.Volunteer.find({_id : uniqueid.toObjectId()}, function(err, doc){ …
Alex H Hadik
  • 774
  • 2
  • 7
  • 16
1
vote
0 answers

Is there any benefit to installing Heroku addon for MongoHQ/Compose?

I use Heroku to host my node.js api. I use MongoHQ (now Compose) for my database. I had gone directly to MongoHQ and setup an account quite sometime ago and I've just setup my mongoose connection directly to my MongoHQ/Compose account. Is there any…
nwkeeley
  • 1,397
  • 5
  • 18
  • 28
0
votes
3 answers

How can I set TLS for Mongoose connection

I'm trying to migrate my mongo database from Compose to IBM Cloud Databases for Mongo and in their documnetations (https://www.compose.com/articles/exporting-databases-from-compose-for-mongodb-to-ibm-cloud/): "With a new Databases for MongoDB…
godzo101
  • 237
  • 1
  • 5
  • 14
0
votes
1 answer

Why is the "download_link" result from Compose for MySQL API set to "true" instead of a url?

With the Compose for MySQL api, when I query for the details of a logfile, a download link is not provided as it should, per the docs at https://www.compose.com/articles/the-ibm-cloud-compose-api/. The value for "download_link" is instead "true". A…
mdl1550
  • 1
  • 1
0
votes
2 answers

Is there support of Cloud databases for Mobile Foundation Service in IBM Cloud?

Does Mobile Foundation Service in IBM Cloud Public support the new service Cloud Databases for Postgres instead of compose for Postgres?
0
votes
1 answer

how to split mongo DB document into multiple documents using compose transporter

I had a document like below I need to send this document to elasticsearch as 3 documents with title contains each of array and I am using compose transporter to send my documents to elasticsearch. How can I achieve this? { "_id" :…
satya
  • 152
  • 2
  • 8
0
votes
1 answer

Weighted Average for nested aggregation in Elastic Search

I am trying to obtain the weighted average by aggregating a nested list. Each document has details of a single student, and the subjects vary across each student and each subject has different weights. I am trying to calculate the weighted average…
User54211
  • 121
  • 2
  • 11
0
votes
1 answer

Saving dates in Mongo via Compose.io vs. dates in Mongo via Meteor

In Meteor: Events.insert({ 'start': new Date(2018, 9, 5, 7, 0, 0, 0) }); In Meteor Mongo the saved date: { "start" : ISODate("2018-10-05T11:00:00.000+0000"), // UTC time } Browser will display date as 7AM, as expected (EDT). HOWEVER, In…
flimflam57
  • 1,334
  • 4
  • 16
  • 31
0
votes
1 answer

How to index(elasticsearch) a specific collection of a specific db of mongodb using transporter?

I want to index only specific mongodb collection in elastic search using transporter. Mongodb server has multiple databases having multiple collections. I dont want to index entire database.
0
votes
2 answers

MongoDB Connector for BI using compose.io

im trying to use the MongoDB Connector for BI on my cloud instance which runs on compose.io. This is the command im using: ./mongosqld --mongo-uri mongodb://%host%:%port% --mongo-username %myuser% --mongo-password %mypassword% --auth…
Alem Filli
  • 73
  • 1
  • 1
  • 7
0
votes
0 answers

Compose.io MongoDB memory usage uneven between data servers

I have a FeathersJS and Apollo graphql app that uses a Compose.io as the database. The portal servers have similar memory consumption but the data servers are very different (see screenshot below). A few weeks ago I increased the memory allocation…
sagannotcarl
  • 354
  • 2
  • 13
0
votes
1 answer

How to Connect Compose for PostgreSQL from IBM Cloud Functions?

I am using IBM Cloud Functions to convert the audio file into text and I am using IBM Watson speech to text service for that. Here I want to store the transcript to PostgreSQL Database. Is there any connection between IBM Cloud Functions and Compose…
Mdumanoj
  • 517
  • 3
  • 9
  • 27
0
votes
1 answer

Issue in connecting mongodatabase

I am using mongoose version 4.13.6 and mongodb from compose, and below is my code for connecting to mongo database. mongoose.createConnection('mongodb://[user]:[pass]@[host1]:[port1],[host2]:[port2]/dbnamme?ssl=true', {}); But when I run this am…
Kishore Indraganti
  • 1,296
  • 3
  • 17
  • 34
0
votes
1 answer

Can I manage Compose for MySQL using workbench?

Here is my connection string: mysql://admin:RandomString@sl-us-south-1-portal.serverNumber.dblayer.com:MyPORT/compose Is the "RandomString" my password (obviously I changed it). Or what is that? Or is there another IDE I can use to create the…
tjcinnamon
  • 345
  • 2
  • 7
  • 20
0
votes
0 answers

Unable to get last_insert_id() from MySQL Compose DB

My spring-batch application generates the following error while trying to get "last_insert_id()" from Compose for MySQL database privided by IBM bluemix: org.springframework.dao.DataAccessResourceFailureException: Could not obtain last_insert_id();…
Gilles
  • 1