5

Is there any application/project that provides you with a command line SQL client that will work with multiple databases and/or provides a mechanism for writing your own drivers?

Put another way, I'm looking for something like the mysql command line client or SQL*Plus for Oracle, but that's database agnostic.

All platforms welcome, but extra points for OS X/*nix approaches.

Improve this question

3 Answers 3

Reset to default
3

Try sqlsharp from the Mono subversion repository. You can define new providers via a configuration file. They are loaded from .NET assemblies, so you can write your own provider if you want to, but Mono already has MS SQL and Oracle, plus postgres and MySQL provide their own .NET assemblies.

It works on any platform supported by Mono and MS.NET.

Improve this answer
Sign up to request clarification or add additional context in comments.

4 Comments

That looks pretty awesome. Random related question: Is it a hard or easy thing to get the Mono run-time onto a system you don't have full access (i.e. root/sudo/Administrator) to?
Easy. You just need to either build it from sources (you'll need gcc, glib-2.0, make, autotools, libtool, pkg-config for windows, just VS + glib-2.0 and pkg-config) or install it in a folder where you have rights to write.
Unfortunately this link doesn't work any more and neither does the one at mono-project.com/Software. Does anybody know where is sqlsharp hosted now?
It's in the main mono repo; github.com/mono/mono/tree/master/mcs/tools/sqlsharp
2

Why not use something built on Perl and DBI like DBI-Shell?

Improve this answer

Comments

0

a SQL client and front-end for multiple database is Crunchyfrog, which offers a Native Database Shell. Not sure if this meets your requriement

Improve this answer

1 Comment

From that page, it looks like the native database shell is just running the existing executable from the database i.e. crunchyfrog isn't doing anything there...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.