Tutorial Details
- Topic: MySQL Database Manager
- Availability: Mac only
- Tutorial Format: Video
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.
Enjoyed this Post?
Subscribe to our RSS Feed, Follow us on Twitter or simply recommend us to friends and colleagues!
By Jeffrey Way
Getting Good with JavaScript
Learn how to liven up your webpages, from start to finish. Veteran Nettuts+ author Andrew Burgess helps you Get Good with JavaScript.
Join our newsletter!
UberMenu - WordPress Mega Me ... only $16.00 
RoyalSlider – Touch-Enable ... only $12.00 
Kult House - More
Web Basix
Just getting started? Start with our basix tutorials on the fundamentals. View All Basix Tutorials
Create a Tutorial, Get Paid!
Have something to teach the world? Want to earn money doing it? Tutorials, screencasts, and articles published here on Nettuts+ are largely contributed by readers just like you! We'll pay you great money for good content. Find Out More
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
I mentioned in the screencast that today’s DB app will be for Mac. We’ll follow up shortly with options for PC.
And for that matter, we should never post Ruby tutorials, because PHP is more popular. :)
@ 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.)
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
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.
@Jack – it’s also the reason why i have cancelled my Premium Membership.
I fully agree with you!
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.
Your loss…
What makes Querious better than Sequel Pro? (free) http://www.sequelpro.com/
Thank you so much Sirbastian!!!
Of course we have open source alternative, Sequel Pro.
http://www.sequelpro.com/
http://nightly.sequelpro.com/
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!
Yeah – free is definitely hard to argue with. :)
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… ;)
Looks like a solid program, but I don’t see any benefits over Sequel Pro (which is free).
Nice app, but I’ll stick with Sequel Pro! :)
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?
I’d suggest Navicat for Windows.
Try looking at Navicat, was using that before I made the switch to Mac.
There are many great options for Windows. I am using HeidiSQL and I’m very happy with it.
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.
HeidiSQL is the best i’ve found for PC thusfar. It does have it’s moments of frustration though.
Tell me more…
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!
Haven’t watched yet, but what are people’s feelings/experiences with Chive, as far as the PC’s are concerned?
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.
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
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.
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 ;/ )
Inside your BLOG learned a lot, thank you and share your success and happiness. Note silently in the distance a view of your friends.
you can always use mysql workbench both for WINDOWS or MAC.
thx jeff for the great article.
Does this allow for working with stored procedures and triggers?
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.
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!
Why I can’t see video in IE?
Seems the answer is within your question.
….IEh?
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.
Can’t use that with Linux.
Oh, today I switched from Snow Leopard to Windows 7. Want to see cross-platform screencast…
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
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.
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.
Good article ….. but MySQLWorkbench is my favorite ….
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
MySQL Workbench gets my vote. :)
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.
I prefer sequel pro. it’s for free.
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
i like this. . .
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.
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
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)
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. :(
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’)”