You could also try:įor PostgreSQL, and beyond the psql command line utility, there's a number of utilities. We have an introduction to the PostgreSQL data browser which covers it in more detail. Our first edition of the PostgreSQL browser lets you view databases and tables, creating SQL queries, viewing their results in a table and to edit those results. The most recent addition to our range of data browsers is PostgreSQL. If you want a more web-centric experience, there's also the pay-for-with-free-tier Redismin with many monitoring and administration features alongside key/value editing. that we are publishing in a hope to validate usefulness of application" so do bear that in mind when testing it out.
#Psequel query mac
You could also try:įor a native Windows, Mac or Linux client, there's RDM - Redis Desktop Manager - an open source (LGPL2) GUI application which renders Redis data as a tree and offers a spreadsheet-like table for editing data. You can learn more about it in our introduction to the browser which includes a screencast. We created a browser to match that environment, allowing you to scan and search through the keys in the database and retrieve and modify the values – strings, hashes, lists and sets – that they point to. Redis is a key/value in-memory database and it's a very different environment to say MongoDB. RedisĬompose Redis deployments were the second database on Compose to get a data browser. Till they are addressed, we can't emphatically recommend RoboMongo but if you are running an older MongoDB version and are, for example, prepared to manually select your server in your replica set, then you may find RoboMongo a very useful tool.
#Psequel query update
A much bigger update is needed though as the arrival of MongoDB 3.0 has just amplified some of the underlying compatibility issues in RoboMongo. Since that article, not much has changed with RoboMongo, save a recent minor update. We looked at this app just over a year ago in RoboMongo: Your Next Shell. Which brings us to RoboMongo, a GUI application for browsing MongoDB which blends in the command line power of the shell with a native presentation layer on Mac, Windows or Linux. Counting against the Mongo shell though is that its data formatting is practically non-existent. You could also try:Īlthough not a point-and-click environment, the Mongo shell is very powerful – we've written about discovering that power and other tips and tricks in this very blog. And you can add new JSON documents to or edit documents in collections through a text editor.
The browser also lets you create databases, collections and indexes, rename collections and view their statistics. To tune your queries we give you access to MongoDB's hint and explain commands too. With the MongoDB data browser you can view any collection in your database, creating MongoDB queries and applying limits or skipping and sorting the results. MongoDB was the recipient of the first of our database browsers. So we decided to round up all the ways you can browse your data on Compose databases to give you the bigger picture. We've been busy adding browsing capabilities to some of the newer Compose databases and as we've done that, we've been asked questions about whether the functionality would be added to the other databases or not.
#Psequel query trial
Compose - a Data Browsing Guide mongdb rethinkdb elasticsearch Free 30 Day Trial
0 kommentar(er)
