Nosql Questions
Ad
How to update whole collection? Firebase Database migration
I've made some updates in article model and it's affects to all elements in the collection so i need to update whole collection. i don't
What am I missing in my firestore security rules that It denies every read and write?
I am using firebase rules simulator, but it denies read, write for authenticated or non-authenticated users. rules_version = '2';
Why does Firebase timestamp object return undefined?
I'm doing a little test thing to get into firebase. but now when i'm trying to access my timestamp object, it returns undefined. this is
Is it possible to exclude several specific documents from cloud firestore query?
I am building an android(java) app that reads data from cloud firestore and displays said data in a list view. currently i am planing on querying
Recommendations for a Graphical DBMS using Aerospike as backend?
Right now what i'm doing is: write some data in 3 different tables perform some reads to check if new values
MS SQL to DynamoDB migration, what's the best partition key to chose in my case
I am working on a migration from ms sql to dynamodb and i'm not sure what's the best hash key for my purpose. in ms sql i've an item table where i
How to aggregate queries in firebase
When i used to work with ms sql server i used to create for example this query select sum(amount * price) from table
Firestore: How to get all documents where a specific field exist
I have a collection in firestore where some documents contain an array but some don't. the structure looks like this: document1 = {
Firebase: Is it a good idea to use dimension / fact table design in NoSQL
So i was wondering, the one downside i have to nosql is: if my front end app ever drastically changes then i would have a horrible time
Nosql model structure
How would you structure your cloud firestore db. i have collections of teams, arenas and games: public class team {
Ad
Mongoose SUM get stacked
I'm trying to make trivial sum on mongodb to count number of prices for single client. my collection:
Manually sort in a NoSQL db
I'm new to the nosql world and i'm wondering if there are some known good patterns established for maintaining a manually sorted list.
Which one would be efficient design for firebase database?
I tried to design a book sharing app. a user can enroll in different group and share his books. each book contains field
GraphQL query omitting null fields for different type objects
I am using apollo graphql for getting a list of different models or types. i tried to use inhirit, but i didn't get it. i was trying to use whole
Modeling data for soft deletes in Firestore
I am trying to implement soft delete by having a field on every document deletedon that is either a timestamp or null. but so far it
Query subset of Firebase (NoSQL) data
I have a firebase (nosql) collection of say 5,000 "players". each day i want to query a subset of those players in order to perform some
Firebase date range query to fetch documents that have starDate and endDate
I have a collection of tasks on my firestore database like this: "tasks": { v8nc4govvope21fhwtp0 : { id:
Does mongoose prevent all NoSQL attacks?
Some times ago i found a few articles that keep saying that mongoose is prevention for nosql attacks but know i found a different article saying
how to import and export date time format data from json to nosql(firestore)
Input: created_at:monday, 29 april 2019 15:07:59 gmt+05:30 updated_at:monday, 29 april 2019 15:07:59 gmt+05:30 i tried
Dating app - Which database structure do I need in Firebase Firestore to query all users except those who disliked me?
I'm creating a dating app with react native and firebase cloud firestore. in my app users can dislike other
Alternative to select distinct in firestore flutter
Is there any way to get all unique field value in firestore using a collectiongroup query like a select distinct ?
Ad
Aggregate total and unique counts based on value type and unique visitorId - MongoDB
Similar to another question i had (here). but now i'm trying to count unique and total
What is wrong with my Mongoose Relationship?
I am learning mongoose relationship and stuck in this problem... someone tell me where am i wrong..? and is there a better approach of doing
I have a huge dataset of machine position data in MongoDB and I am using node js. I want to query hourly values (for every single hour)
The data looks like this. i need to calculate the distance travelled by a user. i achieved that and can specify a date range and it shows the
How to deal with indexes of multiple where query in firebase?
In my flutter app. i have to fetch data from firebase using multiple filters. i've done as below. it worked but the problem is that some
how to get data from child node in firebase in iOS
My database structure is appname: tasks: childbyautoid1: "name": "myname"
How to check if array contains two specific strings in Firestore?
I'm trying to make a chat app that can have chatrooms with max two users. i got a collection chatrooms and chatroom-documents with
Hot to build Firebase Chat Room database?
I'm trying to struct firestore database for chat application. i want to add owner's reference of chat room into specific chat room. here is my
Which database fits better for a Gymlog app?
In my gym log app you can create an own gymplan. this plan will have a fix amount of exercises where you can note every day your stats for each
Firestore basic question: How to avoid N+1 requests on join
I would like to know how i could structure my database in order to avoid doing n requests for all the joins i want to do. firebase gets quite
Firestore document sharing without scanning entire collection
I am learning my basics for firestore and trying to build an app which allows user1 to share a document with user2/3/4 etc. for billing
How to query Firebase-DB for data like 'WHERE'-clause?
I'm working on a contact-app for android with firebase and i want to read values (here: the users' profile) from a user in my database that
Ad
Remove parent key from json file with php
I have a php function that gets the following json file from a firebase db and creates an object called $data. keep in mind
Firebase fetches whole parents data, even when there is no valid path, How to avoid this?
I am fetching data from firebase using ref(). the issue , i am facing is when there is no valid child path means, its fetching whole parent. for
How to connect to and access information on a NoSQL database using C++
I want my code to be able to connect to a wide-column store database like cassandra or dynamodb and read/write information to it. i have
Firestore replicating a SQL Join for noSQL and Flutter
I realise there is many questions in regards to replicating joins with nosql document databases such as firestore, however i'm unable to find a
How can I update a property inside an object in Mongoose
I'm trying to update a property inside an object using $inc in mongoose. i've tried several ways but apparently the syntax is not valid.
Firestore: Getting documents sorted by a numeric field contained in the two sub-levels documents
My firm asked me to get all the documents from the root collection, users. they must be sorted according to the value of a numeric
How can I query multiple fields on a single map data in Firestore?
I'm building an app using react + redux + firebase. in firestore users collection, i have multiple fields including language, subject as map data.
In MongoDB, what is the purpose of embedded documents if the same thing can be achieved without using them?
For example instead of a field named, column_1, that holds an embedded document with fields a, b, and c. why not 3
Firestore data modelling for less requests
I am wondering if i am modelling my firestore data models correctly as i realise the current way will result in a lot of requests to the
When i move document betwen couchbase collections, how do i add time of moving?
I have collection with some documents. sometimes i need to move certain document to another collection (aka archive) and i also need to add
MongoDB issue in query returning value from user
I am using mongodb with nodejs and i am trying to find the usertype value of a specific user so i've got this: var myquery= {
Ad
Sorting records and then using updateMany in MongoDB with limit
I am trying to update all records in my mongodb database. i want to sort the records based on a date(updatedat) in the ascending order. and then
How do you figure out how many documents are created per hour in a Firestore collection?
What is the best way to figure out how many documents are being created per hour into a firestore collection. i have created a cloud functions
Firestore: How to setup array based security rules?
I'm working on an app where you can follow/unfollow other app users. so in firestore i've got a collections of users, and each user contains a
Count unseen messages in group chat with firestore
I want to track the number of unseen messages for each member of a group chat. i store chat metadata in a chats collection, and
Firebase Cloud Firestore Social network database design
I have a simple question. i am building a instagram clone app and i want to show each user to their friends. also they can see the friends list. i
How could I filter by date and location availability in firestore?
In my firebase project i need to query all users who are available on a certain date at a certain city and sort by some other criteria.
Java async update from Firebase eventlistener
I have section of code that updates a variable by the return of a firebase query. outside of this section, i reference that variable and print
How can i make my social network app more efficient in storing and retriving the Data?
I am working on a social network app from scratch, i designed my database (choosing mysql) to store and retrieve data the problem starts
What is the most efficient firestore model for this use case?
In my app i currently have three collections: db_contacts firestore-root | --- db_contacts
Private, json file hosting
After extensive research and a very thorough comparison i've found that all nosql databases uses json to store data, collections and what not.
How to query nested objects in firestore
I want to store data in following format: { "chatname": "football", "chatmembers": [ { "userid":
Ad
Firestore: Data modeling for object tracking application
This is my first firestore – and nosql – project, and i'm struggling with modeling my data. i have a number of objects (in the order
Specify Multiple Join Conditions with $lookup in mongodb
I have these two collections which i want to join as 2 conditions.the examid and the user id .i am using mongodb version 4 and nodejs.there is no
Flutter Firebase: Retrieve a list of documents, limited to IDs in an array?
I'm working on a flutter app where each user can create projects, and share projects with other users. i've created a 'shares' collection, where
Error Delete multiple rows table Cassandra
I'm new to cassandra and i've been having some issues trying to delete multiple rows in table. i have a table defined as follows:
NoSQL Database Structure for Facebook type social network
For a facebook type social networking app, a high performing database structure is required, for storing data in firebase(cloud firestore)
How to create the following data structure in a NoSQL environment
Intro i have a firestore database similar to a social media db, with 3 collections users, events, and eventupdates. my goal
Saving and retrieving related data in mongoose
I am building a messaging system in node.js,socket.io and mongodb. i am well aware of node.js and socket.io but i am new to mongodb. here are my
How do I load/retrieve a Many to Many relationship in Firebase Realtime Database
In my android project i need firebase to load/retrieve my list of 'children' (user with name) when retrieving an object (group) that is in a
Accessing nested collections and document in Firebase (Flutter)
If you cannot understand the title i am very sorry. i am new to nosql don't know how to address this problem. i am having a nested
get a list of document from firestore
I have a collection accounts structured as follow:
Why I can't record first and last records on an array to Firestore
I am trying to register 20 users and create a document on my collection for each of them on firebase firestore. my program successfully registers
Ad
Retrieve specific items from nested array document
I want to retrieve all the documents with their variants except variants which has property isdeleted : true [ {
How to query data with attribute in an interval in Mongoose?
I want to make request to mongodb via mongoose. i need in get documents in interval. for example: i have cats with their ages:
Firestore Query - One to Many Relationship
I am going to develop android mobile app and going to use firebase as backend. i am new to nosql firestore. in my app an user has many
Is it okay to use multiple concurrent read/write operations on the same database file but with different stores in Sembast?
My app has profile and work databases (and others) stored locally using sembast db. please look at the two examples below, which one is a better
NoSQL query of items,lists, Groups and Users using Firebase
Am looking at the data structure in this
NoSQL creating and accessing different store references
I am trying to create a nosql database for a flutter app that has different stores for different activities done throughout the day (sleep,
Mongodb sort by in array
Is there a way to sort by a given array? something like this: const somes = await somemodel.find({}).sort({'_id': {'$in':
How to query database with firebase cloud functions
I am trying to query my firestore database using cloud functions. i want to trigger an email notification every time a new reading in my database
How do I get list of the document ID's inside a collection without getting the content of the documents in Firestore?
I want to do something like: final collectionreference = firestore.instance.collection('mycollection'); final list<string>
What are the differences between put and add in Sembast?
Using flutter package called sembast. what are the difference behaviors between these two commands?
Firebase Update resultset NodeJS
Why is it that i can't seem to update a result set. i have 1000 items and i query firebase and get back a datasnapshot array. i want to check
Ad
Flutter Firebase Realtime Database 'join'
How can i join data in flutter firebase realtime database. data model on appended screen i've something like this.
Initialize a store the first time is created in sembast
I'm developing a mobile application in flutter, and i would like to manage the settings of my application (light theme or dark theme, ...).
converting rdms like instagram to firebase nosql
I am planning to develop production ready hybrid ionic3 mobile application similar to instagram using firebase.
How to create Cassandra primary key in correct way
I have the following table structure: create table test_keyspace.persons ( id uuid, country text, city text,
Cloud Firestore and data modeling: From RDBMS to No-SQL
I am building an ios app that is using cloud firestore (not firebase realtime database) as a backend/database. google is trying to push
Dynamodb filter expression not returning all results
I want to scan all items for last 7 days, so what i do is i generate timestamp for 7 days back and filter for timestamp greater than that value.
Firebase Database relationship issue - storing selected items for users
So i am definitely a firebase and just generally a nosql noob at this point. here is my issue. i have a set of data like so
Mitigating MongoDB injection attacks with Mongoose
I'm using the mongoose odm wrapper for nodejs and i'm concerned about injection attacks.
Determining if the user falls within a zone bounded by two coordinates Firebase
Lets say that i have two sets of coordinates that bound the island of bermuda: x1y1 = [32.43059334605672,-64.90143284218118] x2y2
How to make my NoSQL model structure flatter than what it is (Firebase Realtime Database)
I'm trying to model a database structure to retrieve restaurants within a specific city. for example: when a user accepts
How to join two arrays from different nosql collections?
I want to merge two json collection with vue. { "menu" : { "-lejeln1gntoi0u_xcgo" : { "available" : true,
Ad
How to write location, reference and timestamp data types on Firestore with Python's SDK?
Documentation goes as far as explaining how to write the following data types: data = { u'stringexample': u'hello, world!',
Firestore Query with timestemp in flutter
I'm building an app where i need to get the list of tasks planned for today. but i'm not sure how to write the query for it. this is the
Flutter & Firestore location-based queries & data structure
I am currently working on an app that will connect clients and craftsmen. right now i am structuring the database and thinking about possible
what is the purpose of declaring mongoose.Schema.Types.ObjectId?
I have been going through some nodejs/mongoose code and i realised that there are some codes which explicitly define the _id field when trying to
Firestore multiple range query
Let's say i have a collection of cars and i want to filter them by price range and by year range. i know that firestore
Firestore Food-Ordering Application Database Design Questions
I'm working on a flutter application that basically allows users to place orders to restaurants then go and pick-up those orders. a
Mongodb and Express.js: Automatically creating the db and collections based on Models
In hibernate we can automatically create db and tables (sql databases) using entity classes. is it possible to achieve the same facility in
What does firebase realtime database use under the hood for offline capabilities?
I am curious to know, if firebase uses sqlite under the hood to save its data for offline use or it creates a file saving the data or anything
NoSQL 'like' model structure
I've had some relational database experience, but i am quite new to nosql databases. i am trying to do the following (in firebase firestore) i
Does firestore support skip functionality?
summary: i want to use the 'skip' function used in mysql and mongodb. however, 'startafter (number)' does not skip.
Firestore query a lot of documents
I have a firestore database with a lot of data in it. in my application i have to get a lot of documents from it at once. i know the exact
Ad
How to create/drop mongoDB database and collections from a golang (go language) program.?
Func databaseconnect() (db *mongo.database, err error) { ctx, cancel := context.withtimeout(context.background(), 20*time.second)
MongoDB: Set field value to 10 if less than 10, otherwise increment by one
Consider the following code: findandmodify({id: id}, undefined, {$inc: {counter: 1}, {$max: {counter: 10}) this
Ad
Blog Categories
Ad