Sfrgttk

What is GPS' 19 year rollover and does it present a cybersecurity issue?

Where to refill my bottle in India?

Unbreakable Formation vs. Cry of the Carnarium

I see my dog run

A poker game description that does not feel gimmicky

What is it called when one voice type sings a 'solo'?

Why did the Germans forbid the possession of pet pigeons in Rostov-on-Don in 1941?

Is there a familial term for apples and pears?

Copycat chess is back

Why doesn't a const reference extend the life of a temporary object passed via a function?

Domain expired, GoDaddy holds it and is asking more money

LWC and complex parameters

Hosting Wordpress in a EC2 Load Balanced Instance

Are cabin dividers used to "hide" the flex of the airplane?

Information to fellow intern about hiring?

How to manage monthly salary

Is "plugging out" electronic devices an American expression?

What causes the sudden spool-up sound from an F-16 when enabling afterburner?

Landing in very high winds

Map list to bin numbers

Uplifted animals have parts of their "brain" in various locations of their body. Where?

Is this food a bread or a loaf?

Where else does the Shulchan Aruch quote an authority by name?

Landlord wants to switch my lease to a "Land contract" to "get back at the city"

One CLI to rule them all

How do I list all databases and tables using psql?Close all connections to postgres without having a connectionPostgres create an insert return ruleInsertion Rule on a viewIs anyone else experiencing consistency issues with postgres-xl?How to drop user@% on the MySQL CLI?Rule of Thumb on OS Free SpaceTeach MySQL cli autocomplete to only list table names, not field names?Trigger or rule to convert all strings to lower casepg_restore into a new database

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

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

share|improve this question

asked 13 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 | 

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

share|improve this question

asked 13 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

share|improve this question

asked 13 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.

share|improve this question

asked 13 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.

share|improve this question

asked 13 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 13 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 13 mins ago

tschoppitschoppi

1011