Hot answers tagged

9

I used Mongovue once, I might be a good fit for your needs. It is what you except it to be from a DB management UI: Here's the feature list: Open multiple connections to different MongoDB servers View your MongoDB database as a hierarchical tree consisting of databases, collections, indexes and users Peek at db and collection stats at the click of your ...


4

You can use Robomongo: free and open source Windows/Linux/Mac The main difference with Mongovue is that it is shell-centric (while Mongovue is really GUI). So in some sense it is half a GUI, half a CLI, with all the pros and cons CLI and GUI have.


3

tldr; I'm going to say that Cassandra is probably the better choice for you. may be lots of sensors including Camera for photos or Videos] - Where data flow is huge. Due to its log-based nature, tracking sensor data is a good use case for Cassandra. The ability to handle large amounts of write throughput is a strength of Cassandra, and you can scale ...


1

In general what is a good database for write heavy applications, where all I need is latest match for the query (not the entire result set). I am thinking of deleting the records older than 1 day and storing in separate table for faster fetches. Are there any better alternatives? PostGIS is great. If you're using any GIS functionality, PostGIS is easily the ...


1

You can use MongoChef: Windows, Mac, and Linux Free for non-commercial use I find the interface much more responsive than MongoVUE


1

You can use RockMongo. It's basically the equivalent of PHPMyAdmin for MongoDB (i.e. web-based, and you need a PHP server). It does all you asked for, and has a few more features: Open source under New BSD License Runs fast, and easy to install I18N (English, Chinese, French, Japanese, British, Spanish, German, Italian, Russian) Plug-ins: everyone can ...


1

Postgres meets all your needs: 50k documents. Postgres easily handles millions of records. Read performance. Postgres is very fast, having its own caching in memory plus the caching from disk provided by your host OS. Searching by date. Postgres has some of the best date-time handling features in the industry, with extensive data types and built-in ...


1

Too long for a comment, so I will have to post this as an answer … How many years do you have available for the project? Because it *will take years (at a rough guess, man-decades). Spend a good few months coming up with requirements; then have someone review them (do you have a customer or end user?) . Then spend longer on an architecture. Review. Then ...


1

Finally, after few hours of suffering i found answer for my own question To Create Mongo user db.createUser({ user: "root" , pwd: "<password>", roles: ["userAdminAnyDatabase", "dbAdminAnyDatabase", "readWriteAnyDatabase"]}) Adminer for MogoDb Adminer configuration nano adminer.php search --> connect("mongodb://$N",$sf); edit if condition --> if(...


1

Instead of generating a Excel file why not connect excel directly to the database and skip the middle man.


1

The answer is: It doesn't matter which database you choose. Any major database will be able to be accessed via Python. And once you can access the data in Python, it is a simple matter to write data out to an Excel workbook using Python. The easiest and most efficient way to write to an Excel workbook in Python is to use one of the ready-made packages, of ...


1

Disclaimer: I'm an active developer for the software I'm about to recommend, so I'm at least a bit biased. While it might be slight overkill for your particular use case, Netdata should be able to do a vast majority of the monitoring you would potentially be interested in. It's a bit more focused on the performance monitoring side of things, but it can ...


1

If you are looking for something Open Source, Free and on-premises have a look at Metabase. It takes really just 5 minutes, if not under to get your first graph on the screen. It supports MongoDB but it supports the following databases as well: MySQL Postgres SQL Server AWS Redshift Google BigQuery Druid H2 SQLite Oracle Crate Google Analytics Vertica I'...


1

Available storage engines in the MongoDB Community Server (as at MongoDB 3.6) are: WiredTiger (default storage engine since MongoDB 3.2) MMAPv1 (original storage engine; will be deprecated in MongoDB 4.0) MongoDB Enterprise Server (commercial edition) adds: Encrypted Storage Engine (MongoDB 3.2+) In-Memory Storage Engine (MongoDB 3.2.6+) Outside of these ...


1

YugaByte DB is an open-source cloud-native database for mission-critical applications. YugaByte DB supports two popular NoSQL APIs, Apache Cassandra Query Language (CQL) and Redis, in a wire-compatible fashion. It supports single-row ACID (with multi-row transactions coming soon), and has been extensively tested in a number of real-world use cases. Automatic ...


1

I used to manage informations like these. I used PostgreSQL, where you have the advantage of a relational db and Nosql. You can store in a single record, normalized data, like import data, an id, etc.. and an array, or a json, or even an Hstore. Plus: it has native compression.


Only top voted, non community-wiki answers of a minimum length are eligible