12 ms·
Induction: A Polyglot Database Client For Mac OS X
- lbotos 15y agoThis is incredible! Kudos. I can't wait to try this out.
- matttthompson 15y agoThanks! It's super alpha, but I hope to iterate quickly.
- learc83 15y agoThis would have been great when I was taking the Stanford DB class a few months ago. I like it, looks much nicer than any of the solutions I'm aware of currently.
- monatron 15y agoreally interesting. im excited to check this out. what are you using for the data visualizations?
- matttthompson 15y agod3.js embedded in a web view. That's a sister project I'm calling "Lies, Damned Lies", and will include a variety of canned charts to plug into.
- stevelosh 15y agoDoes anyone have an actual build of this? I just uninstalled XCode this morning and replaced it with Apple's new CLI dev tools, otherwise I'd try building it myself.
- matttthompson 15y agoBuilds are available at https://github.com/Induction/Induction/downloads https://github.com/Induction/Induction/downloads.
- stevelosh 15y agoAh, nice, they weren't there when I first checked but now it's there. Thanks!
- lux 15y agoThe built copy only seems to support PostgreSQL and Redis, but the site mentions MySQL, SQLite, and MongoDB too. Is that coming soon? Edit: I could have answered this question for myself by reading... Skimmed the line that explains that on the site and just caught it now. Oops ;)
- ryb 15y agoI didn't notice the note at first either. They should probably revise the whole sentence to make it clearer that it doesn't yet support those "out-of-the-box" instead of a note afterwards. I'm yearning for the MongoDB support myself.
- artiom 15y agono love for 10.6.8, Lion only
- fcoury 15y agoCame here to ask this exactly. Thanks!
- dguaraglia 15y agoLooks interesting, but there are no binaries and the XCode project didn't compile right away. (I guess, being a software developer, I should go and try to figure out what's breaking the building process. On the other hand, I've never used XCode and don't know enough about OS X library management to figure out broken deps)
- matttthompson 15y agoSorry about that! Binaries are up at https://github.com/Induction/Induction/downloads https://github.com/Induction/Induction/downloads Let me know what build errors you're getting. I would do well to document the requirements (Postgres, Redis)...
- jaimzob 15y agoI'm getting lots of "Unknown property attribute 'strong'" type errors (which I suspect would go away if I upgraded to XCode 4.2?)
- matttthompson 15y agoYeah, that should do it :) Induction is my first real project with ARC, so I'm figuring this out as I go along.
- kapitalx 15y agoLooks very interesting. Unfortunately binary doesn't run on osx 10.6.8. Requires Lion :(
- lytol 15y agoThe XCode project compiled and ran straight out of the box for me.
- deleted 15y ago[deleted]
- tibbon 15y agoWonder if I'll be able to get this working with Oracle. Unfortunately (believe me, I've complained and hope to change it in the future) I have to use Oracle at work. Would love to use this.
- matttthompson 15y agoOracle support would be very awesome (and hopefully very possible). I designed the protocols to be extremely simple; check the Postgres one for an example (~500 LOC)
- martingordon 15y agoI got it to build using Xcode 4.3 (with warnings), but since my Postgres user and database names don't match, I can't connect to my local database.
- matttthompson 15y agoYou can specify the database as the path of the connection URL. I'll add a field for that ASAP.
- burke 15y agoThis looks like it might be less painful for simpler postgres databases than Navicat. Very cool.
- sheraz 15y agoVery cool. This is my current suite of DB apps: - Navicat - PGAdmin III - SeqlPro Looks like I will add this as a fourth. Big win on the visualization feature!
- dasil003 15y agoThe list of 5 databases are precisely the set of database technologies used across my entire projects folder... Suite!!
- gms 15y agoI like the design on that landing page. The most relevant bits are also the most apparent.
- Legion 15y ago"for Mac OS X" breaks my heart, because this is exactly the kind of open-source DB client I want on Linux. At least I can use this when I'm on my Air, but I recently went looking for a multi-DB client app like this for Linux, and this looks like what I was wishing I would find.
- hinathan 15y agoWritten to what API? Gnome, X, Qt? You'll be addressing a slice of a fraction of potential users. It'd be great if it weren't the case, but the diversity that makes linux interesting to hackers also makes it really tough to roll out GUI apps like this and have it 'just work'. I get the sense that's a good part of the appeal of OS X for the developer community lately - mostly Linux-ish when you need it, but a unified GUI experience for the pretty tools (e.g. TextMate, Base, and so on)
- heretohelp 15y agoNobody targets X as an API anymore and haven't since Tk, this is a canard. In general, given the demographics of desktop Linux, it's safe to assume everyone has GTK and Qt working, so pick whatever suits you and go for it. (Spotify is Qt IIRC)
- hinathan 15y agoHonestly it wasn't meant as a canard — this was basically my thought process when I was thinking through an app idea. I'm surely uninformed and some of that is a function of my own laziness, but it's also a reflection of how much diversity there is. I feel like it's akin to Kissinger's rhetorical (at the time) question "Who do I call if I want to call Europe?"
- deleted 15y ago[deleted]
- heretohelp 15y ago>"Who do I call if I want to call Europe?" You just pick whoever people listen to at the time you make the call. In this case, GTK and Qt have been calling the shots and all Linux installs worth targeting are going to support them or support installing the dependencies necessary (which you can specify in your package, as spotify does). Flailing about and perpetuating this myth that Linux is impossible to target just makes things worse.
- newman314 15y agoI wonder if this could be used to hook up something Excel-ish to a DB backend. I use Excel frequently to model and ask "what-if" questions but I often wish I could store/retrieve information dynamically from a DB. (The ODBC connectors that Excel has leave much to be desired). For my use case, that would be the holy grail.
- j_s 15y agoThis commercial solution seems to be languishing in relative obscurity: http://www.querycell.com/ http://www.querycell.com/
- sheff 15y agoSomewhat off topic, but I remembered the author of this Excel add in's "Ask HN" when it first came out ( http://news.ycombinator.com/item?id=794317 http://news.ycombinator.com/item?id=794317 ). 2 or 3 years later, it looks like he's expanded and now has 2 software products and a SAAS ( http://www.OakFocus.net/ http://www.OakFocus.net/ ), so very inspiring.
- endlessvoid94 15y agoI'd do this myself if I had time, but I'd love a homebrew formula for this.
- latchkey 15y agoOh, I'd love it if it supported the Google AppEngine datastore!
- JangoSteve 15y agoThis idea is friggin awesome and definitely something I'd pay for. My apps are pretty evenly divided at this point between MySQL, Postgres, and MongoDB, and I don't see that trend going away any time soon (we always pick the db that makes the most sense for each particular project). Having them all available in the same app would be amazing. With that in mind, just to warn everyone, this is very alpha-level software. It only supports postgres and redis right now. If you put the wrong credentials in, there's no feedback, it just seems like nothing happened. Also, trying to resize the window turned everything white for me and the app had to be rebooted. If you decide to use it (and please do, because I want this to work), be sure to have your Mac's system log opened in console, so you can see what's going on. UPDATE: Looks like someone has already submitted a pull request for the "no feedback on wrong credentials" bug I mentioned [1], and I created a ticket for the resize issue [2]. [1] https://github.com/Induction/Induction/pull/8 https://github.com/Induction/Induction/pull/8 [2] https://github.com/Induction/Induction/issues/10 https://github.com/Induction/Induction/issues/10
- vineet 15y agoFor someone thinking about building a java version - this might help: http://schemacrawler.sourceforge.net/ http://schemacrawler.sourceforge.net/ (I don't think that it supports noSQL.)
- methoddk 15y agoThis is freaking awesome and I can't wait to build it.
- renownedmedia 15y agoI'm lazy, where's the binaries? :3
- methoddk 15y agoTheres a binary hosted on the github page somewhere.
- thebauerpauer 15y agoIt should be noted somewhere that this project currently appears to only work on OS X Lion due to usage of a few Lion-specific classes, namely NSOrderedSet.
- TomatoTomato 15y agoIs there a visual query designer?
- grogs 15y agoWhat's the appeal of this? Just use SQuirreL or DBArtisan.
- bsg75 15y agoDBArtisan, while a very good tool, is expensive, and Windows only. It is one of the few remaining reasons I keep a Windows VM.
- not_chriscohoat 15y agoThis looks great! I maintain a number of PostgreSQL DBs so being able to visualize it locally will be a great resource.
- phillmv 15y agoSerious question: Can't someone just add database drivers to Sequel Pro? It's far and away the best Database GUI I've ever used and its reliance on MySQL is actually keeping me from moving to PostgreSQL full time. (i.e. http://www.sequelpro.com/ http://www.sequelpro.com/ and http://www.sequelpro.com/docs/Source_Code http://www.sequelpro.com/docs/Source_Code - a little crazy they're still on SVN but oh well)
- mcrider 15y agoGod I would love this. This really is the best GUI DB client. I use Navicat for PGSQL but its not free and its quite clunky (though to be fair, very powerful). In any case, SQLite and PGSQL support are supposedly in their roadmap.
- tvon 15y agoIt's certainly not a small task, but an issue is open here: http://code.google.com/p/sequel-pro/issues/detail?id=362&q=postgres&colspec=ID%20Type%20Status%20Priority%20Milestone%20Owner%20Summary%20Stars http://code.google.com/p/sequel-pro/issues/detail?id=362&... Developer input from mid-2011 is towards the bottom, but in short the gist is "that would be great, contributions welcome".
- phillmv 15y agoBlargh. If only it were as easy as `gem install pg`. I would totally throw $20 at a kickstarter to pay someone. That's what, optimistically? Two weeks of work? How quickly could we scrounge up $10k? Shit. More like $100, now that I think about it.
- ddagradi 15y ago> If only it were as easy as `gem install pg`. It is with MacRuby, but that's a whole different set of problems :)
- kennywinker 15y ago
- thought_alarm 15y agoIsn't this just reinventing ODBC? Back in the day you could whip together an app like this using Borland's dev tools in literally a matter of minutes, and it worked with any data source configured on your system. And I think there's a YouTube video that has Steve Jobs demoing that same sort of data access using only Interface Builder on NeXTSTEP. What am I missing?
- lobster_johnson 15y agoODBC is fairly complex (both to work against and to implement providers for) and is very much tied to relational databases. It's also unevenly implemented: On Windows there's native Microsoft-provided ODBC (but in terms of focus it has been superceded by ADO, which superceded OLE DB, which was supposed to be the replacement for ODBC — it's not like Microsoft ever settles on a single technology), and on Unix there's UnixODBC. I don't know about the driver quality; I suspect Windows ODBC drivers are quite good, whereas JDBC has been favoured by the server/enterprise world for a while, and I would not be surprised if UnixODBC drivers were a bit behind the times. As for the Borland dev tools, they also used their own proprietary data source tech: The BDE (Borland Database Engine), which had an ODBC bridge built in. I remember being quite fed up with the BDE at the time, and eventually started using a set of native ODBC components that someone developed. Cocoa does have a sort of rich data framework that you refer to: Core Data. Unfortunately it's quite complex, and not really designed to be a common interface to databases, but rather a sort of data abstraction layer where you work with objects and never see any SQL.
- aheilbut 15y agoRazorSQL is excellent too, and connects to lots of different databases through jdbc.
- bokchoi 15y agoDbVisualizer is a nice RDBMS client that is cross platform, supports many databases, graphs table relations, and comes in a free or $$ flavor: http://www.dbvis.com/ http://www.dbvis.com/
- jpitz 15y agoIf I could just marry something like this to DataGraph. Sigh.