Last Updated: June 24, 2016
·
275
· ryrych

Querying database from inside Vim

Vim can not only be a perfect tool for distractless writing (prose). Software developers can harness Vim modularity to create distractless coding experience.

The less app / windows you have to switch, the more productive you can be. For example with Rdbext you can query database directly from Vim:

Select * from tasks

Connection: T(PGSQL)  H(localhost)  S(localhost)  D(app_development)
U(wojtekryrych)   at 06:48
 id | deleted_at | creator_id | name | logo_url | domain |         created_at         |         updated_at         | testing | channel 
----+------------+------------+------+----------+--------+----------------------------+----------------------------+---------+---------
  1 |            |            | pro  |          | pro    | 2016-04-14 17:37:48.832924 | 2016-04-14 17:37:48.832924 | f       | 
  2 |            |          7 | Ruby |          | ruby   | 2016-04-25 14:03:38.729358 | 2016-04-25 14:03:38.729358 | t       | 
  3 |            |         10 | Bp   |          | bp     | 2016-04-25 14:04:09.365463 | 2016-04-25 14:04:09.365463 | t       | 
  4 |            |         19 | Inc  |          | inc    | 2016-04-28 18:04:03.641899 | 2016-04-28 18:04:03.641899 | t       | 
(4 rows)

For more information visit vim-rails by Tim Pope or read docs: h rails-:Rdbext.