One CLI to rule them all
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
Different projects I am involved with concern themselves with different database systems, mainly Postgres and MariaDB, and to a lesser extent Oracle DB. In the cases where I connect directly to the database I prefer the CLI, as the rest of my work is also heavily terminal-based.
However, I find it hard to keep track of the different ways to query information, i.e. dt vs. show tables;, or d tablename vs. desc[ribe] tablename;, and suffer a bit under the cognitive overhead of these differences.
I was wondering whether someone else also did not want to use different commands for essentially the same thing and wrote a wrapper command-line client that can connect to either of the databases (the more, the merrier) while maintaining a consistent syntax for all meta-SQL queries. All of my google-fu has disappointed so far, I'm starting to think that it is not even possible.
Finally, there is always the option to "suck it up" and wait for the muscle memory to selectively kick in based on the prompt I am presented with when connecting. But technology exists to make our lives easier, so that is the last resort.
Is there a command-line interface that can connect both to MariaDB and Postgres, offering the same meta-commands for both systems?
postgresql mariadb command-line
asked 8 mins ago
tschoppitschoppi
1011
New contributor
tschoppi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Different projects I am involved with concern themselves with different database systems, mainly Postgres and MariaDB, and to a lesser extent Oracle DB. In the cases where I connect directly to the database I prefer the CLI, as the rest of my work is also heavily terminal-based.
However, I find it hard to keep track of the different ways to query information, i.e. dt vs. show tables;, or d tablename vs. desc[ribe] tablename;, and suffer a bit under the cognitive overhead of these differences.
I was wondering whether someone else also did not want to use different commands for essentially the same thing and wrote a wrapper command-line client that can connect to either of the databases (the more, the merrier) while maintaining a consistent syntax for all meta-SQL queries. All of my google-fu has disappointed so far, I'm starting to think that it is not even possible.
Finally, there is always the option to "suck it up" and wait for the muscle memory to selectively kick in based on the prompt I am presented with when connecting. But technology exists to make our lives easier, so that is the last resort.
Is there a command-line interface that can connect both to MariaDB and Postgres, offering the same meta-commands for both systems?
postgresql mariadb command-line
asked 8 mins ago
tschoppitschoppi
1011
New contributor
tschoppi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Different projects I am involved with concern themselves with different database systems, mainly Postgres and MariaDB, and to a lesser extent Oracle DB. In the cases where I connect directly to the database I prefer the CLI, as the rest of my work is also heavily terminal-based.
However, I find it hard to keep track of the different ways to query information, i.e. dt vs. show tables;, or d tablename vs. desc[ribe] tablename;, and suffer a bit under the cognitive overhead of these differences.
I was wondering whether someone else also did not want to use different commands for essentially the same thing and wrote a wrapper command-line client that can connect to either of the databases (the more, the merrier) while maintaining a consistent syntax for all meta-SQL queries. All of my google-fu has disappointed so far, I'm starting to think that it is not even possible.
Finally, there is always the option to "suck it up" and wait for the muscle memory to selectively kick in based on the prompt I am presented with when connecting. But technology exists to make our lives easier, so that is the last resort.
Is there a command-line interface that can connect both to MariaDB and Postgres, offering the same meta-commands for both systems?
postgresql mariadb command-line
asked 8 mins ago
tschoppitschoppi
1011
New contributor
tschoppi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Different projects I am involved with concern themselves with different database systems, mainly Postgres and MariaDB, and to a lesser extent Oracle DB. In the cases where I connect directly to the database I prefer the CLI, as the rest of my work is also heavily terminal-based.
However, I find it hard to keep track of the different ways to query information, i.e. dt vs. show tables;, or d tablename vs. desc[ribe] tablename;, and suffer a bit under the cognitive overhead of these differences.
I was wondering whether someone else also did not want to use different commands for essentially the same thing and wrote a wrapper command-line client that can connect to either of the databases (the more, the merrier) while maintaining a consistent syntax for all meta-SQL queries. All of my google-fu has disappointed so far, I'm starting to think that it is not even possible.
Finally, there is always the option to "suck it up" and wait for the muscle memory to selectively kick in based on the prompt I am presented with when connecting. But technology exists to make our lives easier, so that is the last resort.
Is there a command-line interface that can connect both to MariaDB and Postgres, offering the same meta-commands for both systems?
postgresql mariadb command-line
postgresql mariadb command-line
asked 8 mins ago
tschoppitschoppi
1011
New contributor
tschoppi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 8 mins ago
tschoppitschoppi
1011
New contributor
tschoppi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 8 mins ago
tschoppitschoppi
1011
New contributor
tschoppi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 8 mins ago
tschoppitschoppi
1011
asked 8 mins ago
tschoppitschoppi
1011
1011
New contributor
tschoppi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
tschoppi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
tschoppi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
tschoppi is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234269%2fone-cli-to-rule-them-all%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
tschoppi is a new contributor. Be nice, and check out our Code of Conduct.
tschoppi is a new contributor. Be nice, and check out our Code of Conduct.
tschoppi is a new contributor. Be nice, and check out our Code of Conduct.
tschoppi is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234269%2fone-cli-to-rule-them-all%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
