Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Missing docs which data can be manipulated directly in DB #6053

Closed
mtrezza opened this issue Sep 15, 2019 · 3 comments
Closed

Missing docs which data can be manipulated directly in DB #6053

mtrezza opened this issue Sep 15, 2019 · 3 comments
Labels
type:docs Only change in the docs or README

Comments

@mtrezza
Copy link
Member

mtrezza commented Sep 15, 2019

Issue Description

For certain use cases it can be more efficient to manipulate data on the DB level than via Parse Dashboard or a Parse SDK.

  • For example bulk operations on large collections can be executed more efficiently in the MongoDB shell or via a MongoDB Script than routing the command through parse server.
  • Or it may just be dropping a collection or removing a field from every document because the shell is already open.

At the moment it is unclear which operations should go through Parse Server because there are pre or post operations executed, for example updating the _SCHEMA collection.

Example questions:

  • How to remove a column on a large collection #3939
  • Is it safe to simply drop a relations collection in the DB? Dropping a whole collection would be instantaneous and cause no additional load on the DB, but dropping the column in Parse Dashboard presumably will.

Particularly when it comes to collections with tens of millions of documents the approach to data manipulation changes and the current Parse Dashboard may not be suitable anymore for certain operations like dropping a column for all documents at once.

Expected Results

It should be documented which operations are save to be executed on the DB level and which should go through Parse Server.

Actual Outcome

Currently not documented.

@mtrezza mtrezza changed the title Missing docs which operations can be executed on the DB level Missing docs which data can be manipulated directly in DB Sep 15, 2019
@davimacedo davimacedo added discussion type:docs Only change in the docs or README labels Sep 16, 2019
@davimacedo
Copy link
Member

A documentation explaining the data model could be a good idea but I am not sure if we should specify which/how operations could be done directly in Mongo.

@mtrezza
Copy link
Member Author

mtrezza commented Sep 16, 2019

@davimacedo Yes, I think the data model would do it.

With a note that before/after could code hooks are not applied. Which is not obvious because one could think that parse server listens to MongoDB change streams and executes the hooks, which is not the case.

@stale
Copy link

stale bot commented Oct 31, 2019

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type:docs Only change in the docs or README
Projects
None yet
Development

No branches or pull requests

2 participants