demesew / mongo_backup.sh

Created September 8, 2021 20:31 — forked from sheharyarn/mongo_backup.sh

Mongodump Shell Script for Cronjob

	#!/bin/bash

	MONGO_DATABASE="your_db_name"
	APP_NAME="your_app_name"

	MONGO_HOST="127.0.0.1"
	MONGO_PORT="27017"
	TIMESTAMP=`date +%F-%H%M`
	MONGODUMP_PATH="/usr/bin/mongodump"
	BACKUPS_DIR="/home/username/backups/$APP_NAME"

demesew / gist:0d8cd012c5a09285e46c7acebf1b0a4d

Created March 8, 2021 03:43 — forked from kgorman/gist:134896c7414fde8e090b

MongoDB Profiler Cheat Sheet

	// a list of useful queries for profiler analysis. Starting with the most basic.
	// 2.4 compatible
	//

	// output explained:
	//
	{
	"ts" : ISODate("2012-09-14T16:34:00.010Z"), // date it occurred
	"op" : "query", // the operation type
	"ns" : "game.players", // the db and collection

demesew / mongodb commands

Created January 13, 2021 19:08 — forked from ForrestSutton/mongodb commands

mongodb commands


	//start mongodb
	mongod --dbpath data

	mongoimport --db opendata --collection atlenergy < energy_wb.json

	#restore database from mongodump
	mongorestore --collection col --db opendata opendata/col.bson

demesew / sql-mongo_comparison.md

Created January 13, 2021 19:07 — forked from aponxi/sql-mongo_comparison.md

MongoDb Cheat Sheets

SQL to MongoDB Mapping Chart

SQL to MongoDB Mapping Chart¶

In addition to the charts that follow, you might want to consider the Frequently Asked Questions section for a selection of common questions about MongoDB.

Executables¶

The following table presents the MySQL/Oracle executables and the corresponding MongoDB executables.

demesew / mongo-commands.md

Created January 13, 2021 19:07 — forked from dimitardanailov/mongo-commands.md

MongoDB - Commands

# Get documents, where writters are Joel Coen and Ethan Coen.
db.movieDetails.find({ "writters" : ["Joel Coen", "Ethan Coen"] }).count()

# Get documents, where Jeff Bridges is playing leading role.
> db.movieDetails.find({ "actors.0": "Jeff Bridges" }).pretty()

demesew / mongodb_collection_sizes.js

Created August 8, 2018 00:30 — forked from joeyAghion/mongodb_collection_sizes.js

List mongodb collections in descending order of size. Helpful for finding largest collections. First number is "size," second is "storageSize."

	var collectionNames = db.getCollectionNames(), stats = [];
	collectionNames.forEach(function (n) { stats.push(db[n].stats()); });
	stats = stats.sort(function(a, b) { return b['size'] - a['size']; });
	for (var c in stats) { print(stats[c]['ns'] + ": " + stats[c]['size'] + " (" + stats[c]['storageSize'] + ")"); }

demesew / angular-tableau.js

Created April 12, 2017 13:14 — forked from faustomorales/angular-tableau.js

Angular directive to embed Tableau dashboards

	/* Using this directive is as easy as 1, 2, 3.
	1. Grab the Tableau API JavaScript library as well as this module.
	a. <script src="path/to/tableau-2.0.0.min.js"></script>
	b. <script src="path/to/angular-tableau.js"></script>
	2. Import the module into your app by adding 'angular-tableau' to your dependencies.
	3. Use the directive like this:
	<tableau-viz height="'500px'"
	url="path/to/tableau-dashboard"
	filters={'field1':['item1', 'item2'], 'dateField':{'min':startDate, 'max':endDate}}">
	</tableau-viz>