JackDB Heroku Plugin - Explore Your Databases In Your Browser(github.com)
github.com
JackDB Heroku Plugin - Explore Your Databases In Your Browser
https://github.com/jackdb/jackdb-heroku-plugin
19 comments
Thanks. This is actually great feedback for us.
The distraction-free splash page is designed for first impressions. For return visitors, we make it easy to log in or try JackDB in a couple of clicks. We're always trying out new things with our design.
Our vision for JackDB is building a ubiquitous platform for working with data. Hence, "Make a lasting connection with your data."
The distraction-free splash page is designed for first impressions. For return visitors, we make it easy to log in or try JackDB in a couple of clicks. We're always trying out new things with our design.
Our vision for JackDB is building a ubiquitous platform for working with data. Hence, "Make a lasting connection with your data."
Hi founder here - Hopefully the github page does a decent job explaining how it all works. If not, I can answer any questions you guys have.
Believe it or not (given we live in the age of gmail and the cloud), the big issue for me is trust. How am I supposed to provide login information on mission critical databases, get the convenience of using a cloud-based product AND sleep well at night?
This is a great question.
Of course, trust is an ongoing concern. Being upfront about how we handle security is a start. There's already a lot of trust in *aaS platforms, and we think JackDB is a great tool for building new data-driven projects in the cloud.
We also offer enterprise and private cloud deployments of JackDB.
I'll personally answer any security-related questions that people have.
Of course, trust is an ongoing concern. Being upfront about how we handle security is a start. There's already a lot of trust in *aaS platforms, and we think JackDB is a great tool for building new data-driven projects in the cloud.
We also offer enterprise and private cloud deployments of JackDB.
I'll personally answer any security-related questions that people have.
This looks really nice but the plan structure is very weird.
Why do I need to know or care how many concurrent connections my querying or administration requires? Is this to stop people having more than one tab open? Why can't you just use connection pooling and probably not exceed more than 2 or 3 regardless?
The tiny limits on returned rows means many tasks are going to made tedious, simple stuff like pulling out every name/email subscribed to a mailing list is going to take multiple queries even on the pro plan.
Why do I need to know or care how many concurrent connections my querying or administration requires? Is this to stop people having more than one tab open? Why can't you just use connection pooling and probably not exceed more than 2 or 3 regardless?
The tiny limits on returned rows means many tasks are going to made tedious, simple stuff like pulling out every name/email subscribed to a mailing list is going to take multiple queries even on the pro plan.
As we scale up JackDB, we'll be bumping up the usage limits and revising our pricing plans.
Connection pooling doesn't really make sense in this context because users can't share a database connection; if one is in the middle of a transaction, he could get clobbered by the other's work.
Connection pooling doesn't really make sense in this context because users can't share a database connection; if one is in the middle of a transaction, he could get clobbered by the other's work.
Connection pooling usually happens at the driver level, basically when you 'close' a connection it doesn't typically close it just gets flagged as ready to be re-used so the next query doesn't suffer the full overhead of establishing the connection.
Unless you're counting connections in some other way (or persisting them?) this means in the pro plan for instance I would need up to 20 literally-concurrent queries executing to actually use those connections at the same time which is really only applicable in a web-facing situation where you might have 10s or 100s or 1000s of concurrent users running queries.
From a technical stance an entire team of people accessing the database may fit within the '2' connections of the most basic plan just because there's not enough people to trigger high enough concurrency to require additional connections.
In an administration etc context it seems extremely unlikely unless I've got some long running queries which are also unlikely in a session/browser based service since the odds of closing before a query completes are too high.
It would make much more sense to charge directly based on the number of people actually administrating the database.
It would also be cool to see "plug your S3 credentials in" and have backups taken care of, this is something MongoHQ does and it's beautiful in its simplicity.
Unless you're counting connections in some other way (or persisting them?) this means in the pro plan for instance I would need up to 20 literally-concurrent queries executing to actually use those connections at the same time which is really only applicable in a web-facing situation where you might have 10s or 100s or 1000s of concurrent users running queries.
From a technical stance an entire team of people accessing the database may fit within the '2' connections of the most basic plan just because there's not enough people to trigger high enough concurrency to require additional connections.
In an administration etc context it seems extremely unlikely unless I've got some long running queries which are also unlikely in a session/browser based service since the odds of closing before a query completes are too high.
It would make much more sense to charge directly based on the number of people actually administrating the database.
It would also be cool to see "plug your S3 credentials in" and have backups taken care of, this is something MongoHQ does and it's beautiful in its simplicity.
This is great. Any plans to support nosql datastores like couch and mongo? These datastores could really use an exploratory interface like JackDB.
Thanks! Definitely. NoSQL support is coming soon, starting with MongoDB.
I assume you didn't focus on MongoDB first because there's already MongoHQ. How does their admin interface compare to your open source project and to your paid solution?
Although JackDB works great as a management and administration tool, a big use case is developers and DBAs running ad-hoc queries and digging deep into their data sources. We don't host databases.
To start, our focus has been on building an interface for SQL databases (Postgres, MySQL, etc). We're still polishing our support for MongoDB and other NoSQL databases.
To start, our focus has been on building an interface for SQL databases (Postgres, MySQL, etc). We're still polishing our support for MongoDB and other NoSQL databases.
Would be awesome if the connection part of jackdb could be open sourced so the community could help bring NOSQL support. I understand you've got to make a living though. Just think of all the DBs you could support if you used an ORM (just thinking about Ruby there us Sequel, ActiveRecord, DataMapper).
this looks great. since i switched to postgres from mysql, i was missing something like sequel pro. i tried induction, but it is buggy. will be trying this out shortly!
With all the new datastores out there, ending your project with DB seems to imply it's yet another database, then you go to your homepage and I have to click the about button to even figure out what the product might be.
Also, I kind of hate the tagline "make a lasting connection with your data". Given that your homepage only shows that and 2 buttons, it seems that you really want me to "make a lasting connection with my data" more than figure out what your product is. Why would someone even click the "Try JackDB Now" button if they don't know what it is or does?
http://www.jackdb.com/home.html is a much better page and maybe it should be your hope page. It certainly explains your product better.
On a side note, I'm not sure that there is a market willing to pay $12 or $29 a month for a web based database client, but I can see the basic appeal. Best of luck!