Quick Tip: A Fast Overview of Querious (MySQL Manager)
videos

Quick Tip: A Fast Overview of Querious (MySQL Manager)

on Jun 16th 2010 with 58 comments
Tutorial Details
  • Difficulty: Beginner

In today’s video quick tip, we’ll have a quick (not sponsored) overview of a Mac database manager for MySQL that I came across yesterday, called Querious. As I mention in the screencast, I particularly like this one, because it just works — without being too complicated or overwhelming in the way that PHPMyAdmin might be for some.

Premium Members: Download this Video ( Must be logged in)
Prefer to watch this video on Screenr?
Screenshot

 
Enjoyed this Post?

Subscribe to our RSS Feed, Follow us on Twitter or simply recommend us to friends and colleagues!

By

Rollover to read this author's bio or click through to see a full list of posts by this author.

I'm the editor of Nettuts+, and love making the process of building for the web as easy as possible. Also, I'm finishing up my latest book on Laravel Testing! If you want be friends, say hi on Twitter.  

Plus Premium
 
 
Note: Want to add some source code? Type <pre><code> before it and </code></pre> after it. Find out more
  • Jack

    This is why I stop my premium membership…. I don’t care about software for Macs, Windows has the dominant market share therefore you should have tutorials on software that is able to use on Windows, or able to use on both Windows and Mac’s

    • http://www.jeffrey-way.com Jeffrey Way
      Author

      I mentioned in the screencast that today’s DB app will be for Mac. We’ll follow up shortly with options for PC.

      • http://www.jeffrey-way.com Jeffrey Way
        Author

        And for that matter, we should never post Ruby tutorials, because PHP is more popular. :)

      • Teun Beijers

        @ the PHP thing I can’t react to :P:
        Why not make tutorials about J2EE. That’s used in the professional scene a lot(by banks etc.)

    • http://www.thirstdesign.com Richard

      Jack my man sorry to say your totally wrong. If it doesn’t apply to you this time then don’t waste your previous time just skip it (I do it for the ASP stuff etc cause I’m not into that) but I’m grateful for these little tips.

      For example I knew about sequel pro but not this, well now I do and it’s another potential tool in the box.

      Thanks Jeff (also thanks for the CI tuts, those really got me stuck into it),

      Rich

      • Erik

        Hardly the dominant OS for web developers; i’ve read a number of surveys that web-development centric sites have done to determine their visitor’s OS and a number of them have MacOS at 40%+ … after subtracting Unix users, that actually leaves windows as the minority.

    • Sascha

      @Jack – it’s also the reason why i have cancelled my Premium Membership.

      I fully agree with you!

      • http://envexlabs.com Matt Vickers

        Thanks for coming! Hope you enjoyed your stay.

        It’s not like 100% of articles posted here are only on the OS X. Is it our fault that most sexy applications are mac only?!

        That being said, good review. I was in the beta for this but stopped using it because I used phpmyadmin more.

    • John

      Your loss…

  • http://worktimer.co.uk Sirbastian

    What makes Querious better than Sequel Pro? (free) http://www.sequelpro.com/

    • Lacey

      Thank you so much Sirbastian!!!

  • Jozan

    Of course we have open source alternative, Sequel Pro.
    http://www.sequelpro.com/
    http://nightly.sequelpro.com/

  • http://www.thirstdesign.com Richard

    Looks OK but I’ve been using Sequel Pro for the last year and I would say it is a little easier to use. I would be interested in seeing the cleanup operations etc that this new one has.

    But my vote still goes for sequel pro, plus it’s free!

    • http://www.jeffrey-way.com Jeffrey Way
      Author

      Yeah – free is definitely hard to argue with. :)

  • http://www.bramjetten.nl Bram Jetten

    I was already using Querious, it has saved me lot’s of time. It’s simplicity makes it really awesome to work with. Especially after using PHPMyAdmin for a long time… ;)

  • Matthew

    Looks like a solid program, but I don’t see any benefits over Sequel Pro (which is free).

  • http://www.philohermans.com Philo Hermans

    Nice app, but I’ll stick with Sequel Pro! :)

  • http://www.projectfive.nl Duncan

    Looks indeed like a great program to use instead of phpmyadmin!
    Unfortunately this time, I’m using Windows. Does anyone know of such (a good) program for windows?

    • http://www.bluelayermedia.com Jason

      I’d suggest Navicat for Windows.

    • Ashen

      Try looking at Navicat, was using that before I made the switch to Mac.

    • Marcin

      There are many great options for Windows. I am using HeidiSQL and I’m very happy with it.

      • http://www.delucamarketing.ch NetHawk

        HeidiSQL? What an odd name! But thanks for recommending it, Heidi made a great SQL tool, I really like it and there’s also a stickware version.

    • Josh

      HeidiSQL is the best i’ve found for PC thusfar. It does have it’s moments of frustration though.

      • http://www.delucamarketing.ch NetHawk

        Tell me more…

  • Chris

    I’m new to using databases, but this looks fantastic! Looks really easy and intuitive; can’t wait to try it out. Thanks for the vid, Jeff!

  • Reese

    Haven’t watched yet, but what are people’s feelings/experiences with Chive, as far as the PC’s are concerned?

    • http://wyome.com John Cox

      I use Chive from time to time because of the trigger and view support. I like it, but it’s not ready to replace phpMyAdmin as your @anywhere tool yet. It’s just a little buggy right now. It is faster though for the things that do work.

  • Liam

    I saw this article in my reader and was about to come in here and ask what the advantages were over Sequel Pro, but I see I was beaten to the punch there :D

  • http://newarts.at Drazen Mokic

    I have tested so many of them… sequel pro, navicat, querious and one or two more but none of them could convince me to go away from Phomyadmin. For me PMA is still the best out there or at least i do my work faster with PMA than with any desktop app.

  • Kat

    I don’t use Querious but I’d like to try it. Unfortunately the only MySQL5 server I have access to doesn’t play well with it at all. Its so slow I can’t use it. I tried working with Querious developers but its out of their control from what I can tell and is an issue with the webhost ( web.com – ew i know ;/ )

  • http://www.obdsvs.com tacho universal

    Inside your BLOG learned a lot, thank you and share your success and happiness. Note silently in the distance a view of your friends.

  • mdennisa

    you can always use mysql workbench both for WINDOWS or MAC.

    thx jeff for the great article.

  • David

    Does this allow for working with stored procedures and triggers?

  • http://www.sidelane.co.uk Ira

    Gotta agree with everyone on the Sequel Pro front. I bought a licence for Querious when it was still in beta and it looked very promising, but development was slow, support wasn’t great (often didn’t get a reply), and the performance of it when accessing remotely hosted databases sucked fat one compared to Sequel Pro. It’s a shame, ‘cos it looks real nice an all, but it just doesn’t cut it.

  • http://www.crearedesign.co.uk Steve Maggs

    I’ve been looking for a friendlier alternative to phpmyadmin for a while (although not very hard) but it looks like I don’t have to look any further. I’ll definitely be trying sequelpro, as free is definitely hard to argue with, and thanks to some strong recommendations here too.

    Keep catering for the minority!

  • Mike

    Why I can’t see video in IE?

    • http://thedigitalyardsale.com Digital Yard Sale

      Seems the answer is within your question.

      ….IEh?

  • http://www.comolohago.cl Xabadu

    Thank you for this quick tip Jeff. It’s always good to look at new software alternatives for doing the things we normally do. I really liked the look and feel of the app, perfect for new users that normally get confused around tools like phpMyAdmin.

  • http://www.jordanwalker.net Jordan Walker

    Can’t use that with Linux.

  • http://drive58.ru/ AlexKad

    Oh, today I switched from Snow Leopard to Windows 7. Want to see cross-platform screencast…

  • http://www.igotjosh.com Josue

    Honestly i find SequelPro a bit too simple for me, MySQLWorkbench it’s exactly what i need :) Plus it’s free! It has a ERR designer, a Resource Meter and their Query Editor it’s just awesome! I suggest you guys try it out :D

  • http://mac-apps.pl Seed

    One thing I don’t like about Querious is that when you make a new database, you can’t set the deafult encoding like in sequel pro, but Querious is really great and I’m using it a while now.

  • http://alsmediagroup.com/ Allen

    This tool is great for local development servers, I would stick with phpMyadmin on live sites though…. simply create a sql dump and import it into the live environment.

  • http://www.realtytop.net Dejan

    Good article ….. but MySQLWorkbench is my favorite ….

  • Alex

    Jeffrey hey I am very grateful for all the tutorials you post, I was wondering if you could do a tutorial on how to build a shopping cart with php and mysql
    I would appreciate

  • http://www.jacobbednarz.com Jacob Bednarz

    MySQL Workbench gets my vote. :)

  • Damon

    I bought this app awhile back but have ceased using it. I find the free Sequel Pro much better. I seem to always get a hangup with Querious. It will just spin and spin and never connect, or if it does connect it’s very sluggish. This happens on several of my bd servers. I never have any issues with Sequel Pro.

  • http://www.freude-co.de Jens

    I prefer sequel pro. it’s for free.

  • http://birkir.forritun.org/ Birkir R Gudjonsson

    Does Querious support Data modeling with diagrams and physical schemata ?

    Well my MySQL Workbench works great for me at the moment. Untill you can provide some powerful data modeling tool, I will consider to check it out.

    See pic: http://img.brothersoft.com/screenshots/softimage/m/mysql_workbench-295363-1255574862.jpeg

  • http://betngandang.com Betngandang

    i like this. . .

  • Shane

    I like to use Sequel Pro as my SQL GUI. It’s a nice seamless workspace to work in, but I’ll definitely check out Querious.

  • http://www.ewaveinfotech.com gun

    Nice application.MYSql is free So lots of small application use this as backend database storage

    PHP+MY sql is very good free No Licence needed

  • nykeri

    So im making a guess that MYSQL Workbench is gonna show up in the windows version of this video. My choice MySQL Workbench as well as it does everything i need (db creation, EER modeling, sql execution plus more)

  • http://www.iamiivo.com Iivari Leinonen

    Installed a trial version today and I also installed Sequel pro just to give them both a go. One thing that I can’t find anywhere is that how can you set an md5 or sha1 encryption to a field? In phpmyadmin when you’ve created a table and start to input data, you can choose md5 or sha1 from the “functions” dropdown menu for a password field. With neither one of the programs I can’t find this feature anywhere. :(

    • http://www.iamiivo.com Iivari Leinonen

      If anyone else wants to know the solution to the same issue, I got a mail from the support team about this today and they said:

      “As of now, you’d need to run the insert statement via SQL (like below), or at least get the result of the MD5 function via sql and enter it into the field through the Content interface. There isn’t a way to specify a function and value when editing or inserting a field/row in a table.

      INSERT INTO users (id, username, hashed_password) VALUES(1, ‘user’, MD5(‘abcdef’)”

  • tenshimsm

    I use MySQL Workbench which is FREE and has versions for Linux, Mac And Windows.

  • tenshimsm

    SQL Power Architect seems to be nice and supports various database types including MySQL and PostgreSQL.

  • daniel

    I use a free tool Valentina Studio at the moment. it works natively on 3 OS: mac, win, lin. Does everything you need, and does it very well. http://www.valentina-db.com/valentina-studio-overview