Xangelo.ca

Tag: Database

• Mongo vs. DynamoDB — Abstract Whenever you get into the conversation of NoSQL, and specifically “Document based” systems, you inevitably seem to end up on either DynamoDB or Mongo. The truth is while DynamoDB is a wonderful tool, Mongo should probably be your first stop. Mongo vs. DynamoDB Mongo and DynamoDB are two document storage databases in the NoSQL family. Where mongo took the more traditional “server” route, DynamoDB opted for “serverless”. As a result, most of the distinction between the two comes from this divide. Keywords: database mongo documentdb.
• What the heck is a Database Index? — When you do a standard select * from table_name where columns=some_value from a table.. the database has no idea where IN the table that data exists. In order to figure out which rows in the table it needs to return to you (based on your where clause), it looks through the rows in the table. Of course, if you don’t set a limit clause, it has to look through EVERY single entry in the table because it doesn’t know where/how-many instances of a particular value it might find. Keywords: explanation database.