JackDB – Query and analyze any database in the cloud, right in your web browser
jackdb.com
jackdb.com
[0]: https://developers.google.com/bigquery/ [1]: http://inductionapp.com/
We're looking into adding both BigQuery and Google Cloud SQL integration. The latter should be out pretty soon.
> I don't understand why you would ever pay for this?
One big one is ease of use and convenience. If you're using a cloud database (Heroku Postgres, Amazon RDS, etc) then JackDB is the fastest and easiest way to start running queries. With Heroku in particular we have OAuth integration so you can list your data sources and connect in just a couple mouse clicks.
Add to that additional features like never losing your work (close the browser, reopen it, and keep scrolling your query), sharing SQL among your team, and a full audit trail of all activity and you have a product that people will (and do) pay for.
> If you need a web based database gui, what's wrong with the hundreds of free versions?
Obviously I might be a bit biased but I think JackDB is the best database GUI there is. We've been using it ourselves to develop JackDB for quite a while now (i.e. dog fooding).
> And it comes free with the non scary part of giving someone else your database access.
Security is a big deal and there is definitely a trust factor involved in using something like this (or more generally any other cloud data service). We try to be as open as possible about how we handle security and crypto on our site.
Still though, when you consider that the vast majority of people using it are already outsourcing the maintenance of their database to a cloud provider the leap of faith to using JackDB isn't as large as you think it is.
It would seem that their enterprise version does this.
As JackDB requires a direct connection to your database it works best with cloud database as a service providers (ex: Heroku Postgres or Amazon RDS). You can connect it to a local network as well (quite a few folks do!) though you'll have to setup the firewall rules to accommodate it.
1 user, 1+ user, unlimited users
Also, row limits are not listed in the top tier, making me think that they are either unlimited, or that the go until they break due to a technical limitation somewhere after 5k rows.
> What does 1+ user mean if not unlimited?
There's no limit to the number of Pro users that can work together with the same data sources.
> Also, row limits are not listed in the top tier, making me think that they are either unlimited, or that the go until they break due to a technical limitation somewhere after 5k rows.
Enterprise deployments can customize the row limits (default is 5K). There's no technical limit on the server side though some browsers slow down at very large limits. Using Chrome we've had no issue with 50K+ rows. It doesn't come up in real world use cases though as people dealing with more than a couple K rows usually want the data exported (which we support separately) vs just scrolling through a result set.
If you're keen on a DIY option there are a couple out there but I wouldn't consider any of them to be as full featured as our offering and none allows for data source sharing or tracking audit trails. Also, most other tooling is specific to a single database type (MySQL, Postgres, etc) and I'm not sure which you're using (Amazon RDS supports MySQL, Postgres, SQL Server, and Oracle).
That said, here are some other options:
http://phppgadmin.sourceforge.net/