You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
124 lines
4.4 KiB
124 lines
4.4 KiB
11 months ago
|
<!DOCTYPE html>
|
||
|
|
<html lang="en">
|
||
|
|
<head>
|
||
|
|
<meta http-equiv="X-UA-Compatible" content="IE=edge">
|
||
|
|
<meta http-equiv="content-type" content="text/html; charset=utf-8">
|
||
|
|
|
||
|
|
<!-- Enable responsiveness on mobile devices-->
|
||
|
|
<!-- viewport-fit=cover is to support iPhone X rounded corners and notch in landscape-->
|
||
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1, viewport-fit=cover">
|
||
|
|
|
||
|
|
<title>Julio Biason .Me 4.3</title>
|
||
|
|
|
||
|
|
<!-- CSS -->
|
||
|
|
<link rel="stylesheet" href="https://blog.juliobiason.me/print.css" media="print">
|
||
|
|
<link rel="stylesheet" href="https://blog.juliobiason.me/poole.css">
|
||
|
|
<link rel="stylesheet" href="https://blog.juliobiason.me/hyde.css">
|
||
|
|
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=PT+Sans:400,400italic,700|Abril+Fatface">
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</head>
|
||
|
|
|
||
|
|
<body class=" ">
|
||
|
|
|
||
|
|
<div class="sidebar">
|
||
|
|
<div class="container sidebar-sticky">
|
||
|
|
<div class="sidebar-about">
|
||
|
|
|
||
|
|
<a href="https://blog.juliobiason.me"><h1>Julio Biason .Me 4.3</h1></a>
|
||
|
|
|
||
|
|
<p class="lead">Old school dev living in a 2.0 dev world</p>
|
||
|
|
|
||
|
|
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<ul class="sidebar-nav">
|
||
|
|
|
||
|
|
|
||
|
|
<li class="sidebar-nav-item"><a href="/">English</a></li>
|
||
|
|
|
||
|
|
<li class="sidebar-nav-item"><a href="/pt">Português</a></li>
|
||
|
|
|
||
|
|
<li class="sidebar-nav-item"><a href="/tags">Tags (EN)</a></li>
|
||
|
|
|
||
|
|
<li class="sidebar-nav-item"><a href="/pt/tags">Tags (PT)</a></li>
|
||
|
|
|
||
|
|
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
|
||
|
|
<div class="content container">
|
||
|
|
|
||
|
|
<div class="post">
|
||
|
|
<h1 class="post-title">Potent Thrifty Iridium</h1>
|
||
|
|
<span class="post-date">
|
||
|
|
2020-10-22
|
||
|
|
|
||
|
|
<a href="https://blog.juliobiason.me/tags/projects/">#projects</a>
|
||
|
|
|
||
|
|
<a href="https://blog.juliobiason.me/tags/personal/">#personal</a>
|
||
|
|
|
||
|
|
<a href="https://blog.juliobiason.me/tags/postgres/">#postgres</a>
|
||
|
|
|
||
|
|
<a href="https://blog.juliobiason.me/tags/tui/">#tui</a>
|
||
|
|
|
||
|
|
</span>
|
||
|
|
<p><strong>ARCHIVED</strong> <a href="https://www.pgcli.com/">pgcli</a> does everything I wish.</p>
|
||
|
|
<p>Postgres Text Interface.</p>
|
||
|
|
<ul>
|
||
|
|
<li>Simple, Borland-like interface.</li>
|
||
|
|
<li>List of servers/connections.</li>
|
||
|
|
</ul>
|
||
|
|
<pre style="background-color:#2b303b;color:#c0c5ce;"><code><span>+----------------------------------------+
|
||
|
|
</span><span>| *Connected to XXX* |
|
||
|
|
</span><span>+----------------------------------------+
|
||
|
|
</span><span>| Query |
|
||
|
|
</span><span>| |
|
||
|
|
</span><span>| |
|
||
|
|
</span><span>| |
|
||
|
|
</span><span>+----------------------------------------+
|
||
|
|
</span><span>| Results |
|
||
|
|
</span><span>| +----+---------+----------+------+---> |
|
||
|
|
</span><span>| | Fi | Field | Field | Fiel | F |
|
||
|
|
</span><span>| +----+---------+----------+------+---> |
|
||
|
|
</span><span>| | Va | Value | Value | Valu | V |
|
||
|
|
</span><span>| | Va | Value | Value | Valu | V |
|
||
|
|
</span><span>| | Va | Value | Value | Valu | V |
|
||
|
|
</span><span>| | Va | Value | Value | Valu | V |
|
||
|
|
</span><span>| +----+---------+----------+------+---> |
|
||
|
|
</span><span>+----------------------------------------+
|
||
|
|
</span></code></pre>
|
||
|
|
<ul>
|
||
|
|
<li><code><Tab></code> jumps between results and query.</li>
|
||
|
|
<li>Save queries?
|
||
|
|
<ul>
|
||
|
|
<li>Could save and load files, the are pure text anyway...</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>How does one disconnect/return to server list?</li>
|
||
|
|
<li>VIM-like keybinds, maybe?</li>
|
||
|
|
<li>Replace commands like <code>\dt</code> with <code>show tables</code> (accept both)
|
||
|
|
<ul>
|
||
|
|
<li>More interesting, using <code>show tables</code> should show that the actual command
|
||
|
|
is <code>\dt</code></li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>Auto-complete tables, fields, etc (pretty much what psql does already)</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</div>
|
||
|
|
|
||
|
|
</body>
|
||
|
|
|
||
|
|
</html>
|