8 ms·

Vim-db: Modern database interface for Vim

205 points by petercooper 9y ago

krzyk 9y ago
It's a pity it doesn't support Oracle. Some corps force developers to use it.
- nobleach 9y ago
  When Oracle is forced, often Java is forced right along with it... Java means most will be using some sort of IDE instead of Vim (not always, but often) But I agree... if we're stuck using that beast of a database, it'd be nice to see support in my tooling.
- gaius 9y ago
  So make the case for Postgres and show the business how much cash they will save. Don’t submit to your fate, fight it.
  - always_good 9y ago
    In my experience, the organization is well aware how much they need to switch away from Oracle. They're reminded every billing period. By then it's just no small feat. Look at Amazon, aggressively trying to move away from Oracle yet still far away.
    - mordae 9y ago
      We want to get rid of it for years now, but say that to the accounting dept. with their ancient Oracle Forms ERP.
      - gaius 9y ago
        Ironic that the beancounters waste the most money. Remember that when they want to make cuts.
- icc97 9y ago
  Looking at the code there's some thought of allowing both SQL Server and Oracle. He only just released it today so there's time to add the others.
- lostapathy 9y ago
  It says right in the list of supported DBs "Your own easily implemented adapter" - it's definitely something that can be added. Odds are he built it to use the DBs he uses, now it's your turn to contribute back the adapter for the DB you use.
- ken 9y ago
  Is there any overlap in Oracle and Mac usage?
  - fiddlerwoaroof 9y ago
    Where I work most of the developers use Mac and are stuck with a legacy oracle db.
hucker 9y ago
Shameless self-promotion incoming, but if you're mostly using postgres (like me), you can take a look at https://github.com/martingms/vipsql https://github.com/martingms/vipsql as well.
- aidos 9y ago
  Nice work! I use (a slightly modified version of) https://github.com/ivalkeen/vim-simpledb https://github.com/ivalkeen/vim-simpledb Looks pretty similar to yours. I definitely like that model of editing / execution.
falcolas 9y ago
I don't want to be Debbie Downer, but what's the usecase for this tool that isn't better suited for a client in a separate terminal? I am guessing that the two biggest answers would be the :%DB command and the variable setting, but given the ease of switching and copy-pasting between terminals, this seems superfluous. Maybe it's for easier integration into other plugins? Personally, if I was looking for a DB integration with VIM, I'd be looking for an interactive prompt style buffer instead of per-command executions.
- mbreese 9y ago
  I haven’t tried this, but the docs mention an interactive mode. I assume this would be a more vim-esque prompt mode.
  - eptcyka 9y ago
    I did try this and the 'interactive' mode just spawns a shell of a given SQL terminal. And this doesn't work on neovim.
- wmonk 9y ago
  For me, vim is so integral now to my dev workflow that being able to work in a single environment is great. I don't really use and cli tooling for DB access and querying, now being able to use a vim pane as my query entry is really nice - no switching back and forth between various applications. An interactive prompt would be pretty nice though, agree with that.
  - in9 9y ago
    inb4 "oh so you should use emacs" :D
    - zeveb 9y ago
      I find it really amusing that the vim ecosystem is reinventing emacs, more slowly, in a worse language. There are some really amazing, really smart people (like Tim Pope), creating some really amazing, really cool software — I can only imagine how much more effective they'd be if they were working in a better environment.
claudio_alvarez 9y ago
Is it hard at all to exit vim-db?
blaisio 9y ago
Everyone should probably be paying Tim Pope some sort of tribute for all the software that has been written more quickly because of his plugins. Companies working on other editors should be trying to recruit him!
djtriptych 9y ago
Should mention in the comments that this is written by Tim Pope, probably the foremost vim plugin author of the last decade. He also wrote pathogen, vim-surround, vim-repeat, etc etc etc. https://github.com/tpope?tab=repositories https://github.com/tpope?tab=repositories
- badosu 9y ago
  Shout out to Tim Pope! I follow his work since I started using Vim ~ 8 years ago, the absolute pinnacle for me being vim-fugitive, I can't live without it!
purplezooey 9y ago
SQlite support. awesome.
- joehan 9y ago
  Not integrated in vim, but try visidata (https://github.com/saulpw/visidata https://github.com/saulpw/visidata) on Sqlite. I tried after HN post last weekend and it was amazing... with Vim-like keys and interface.
agumonkey 9y ago
I'd love to see a screencast. I'm mostly an emacser but I like vi ergonomics very much, and would love to see the approach here.
- marrone12 9y ago
  Why not just use evil-mode in emacs?
  - agumonkey 9y ago
    I'm not in the mood for learning UI right now. Also it's beside my question. I'm curious about vi culture and vi fanatics (or fetishists, or satanists, forgot the proper terminology).
pweissbrod 9y ago
This is a very nascent project but started by one of the best vim developers around, Tim Pope. As someone who has run into some of the rougher edges from time to time of dbext I applaud this effort and will closely watch progression
dguaraglia 9y ago
I see Tim Pope, I upvote. This guy has produced some of the plugins that have changed how I Vim forever (vim-surround, pathogen, vim-repeat, vim-fugitive, etc.)
notaspider 9y ago
Checkmate emacs /s

205 points by petercooper 9y ago

krzyk 9y ago

It's a pity it doesn't support Oracle. Some corps force developers to use it.

nobleach 9y ago
When Oracle is forced, often Java is forced right along with it... Java means most will be using some sort of IDE instead of Vim (not always, but often) But I agree... if we're stuck using that beast of a database, it'd be nice to see support in my tooling.
gaius 9y ago
So make the case for Postgres and show the business how much cash they will save. Don’t submit to your fate, fight it.
- always_good 9y ago
  In my experience, the organization is well aware how much they need to switch away from Oracle. They're reminded every billing period. By then it's just no small feat. Look at Amazon, aggressively trying to move away from Oracle yet still far away.
  - mordae 9y ago
    We want to get rid of it for years now, but say that to the accounting dept. with their ancient Oracle Forms ERP.
    - gaius 9y ago
      Ironic that the beancounters waste the most money. Remember that when they want to make cuts.
icc97 9y ago
Looking at the code there's some thought of allowing both SQL Server and Oracle. He only just released it today so there's time to add the others.
lostapathy 9y ago
It says right in the list of supported DBs "Your own easily implemented adapter" - it's definitely something that can be added. Odds are he built it to use the DBs he uses, now it's your turn to contribute back the adapter for the DB you use.
ken 9y ago
Is there any overlap in Oracle and Mac usage?
- fiddlerwoaroof 9y ago
  Where I work most of the developers use Mac and are stuck with a legacy oracle db.

hucker 9y ago

Shameless self-promotion incoming, but if you're mostly using postgres (like me), you can take a look at https://github.com/martingms/vipsql https://github.com/martingms/vipsql as well.

aidos 9y ago
Nice work! I use (a slightly modified version of) https://github.com/ivalkeen/vim-simpledb https://github.com/ivalkeen/vim-simpledb Looks pretty similar to yours. I definitely like that model of editing / execution.

falcolas 9y ago

I don't want to be Debbie Downer, but what's the usecase for this tool that isn't better suited for a client in a separate terminal? I am guessing that the two biggest answers would be the :%DB command and the variable setting, but given the ease of switching and copy-pasting between terminals, this seems superfluous. Maybe it's for easier integration into other plugins? Personally, if I was looking for a DB integration with VIM, I'd be looking for an interactive prompt style buffer instead of per-command executions.

mbreese 9y ago
I haven’t tried this, but the docs mention an interactive mode. I assume this would be a more vim-esque prompt mode.
- eptcyka 9y ago
  I did try this and the 'interactive' mode just spawns a shell of a given SQL terminal. And this doesn't work on neovim.
wmonk 9y ago
For me, vim is so integral now to my dev workflow that being able to work in a single environment is great. I don't really use and cli tooling for DB access and querying, now being able to use a vim pane as my query entry is really nice - no switching back and forth between various applications. An interactive prompt would be pretty nice though, agree with that.
- in9 9y ago
  inb4 "oh so you should use emacs" :D
  - zeveb 9y ago
    I find it really amusing that the vim ecosystem is reinventing emacs, more slowly, in a worse language. There are some really amazing, really smart people (like Tim Pope), creating some really amazing, really cool software — I can only imagine how much more effective they'd be if they were working in a better environment.

claudio_alvarez 9y ago

Is it hard at all to exit vim-db?

blaisio 9y ago

Everyone should probably be paying Tim Pope some sort of tribute for all the software that has been written more quickly because of his plugins. Companies working on other editors should be trying to recruit him!

djtriptych 9y ago

Should mention in the comments that this is written by Tim Pope, probably the foremost vim plugin author of the last decade. He also wrote pathogen, vim-surround, vim-repeat, etc etc etc. https://github.com/tpope?tab=repositories https://github.com/tpope?tab=repositories

badosu 9y ago
Shout out to Tim Pope! I follow his work since I started using Vim ~ 8 years ago, the absolute pinnacle for me being vim-fugitive, I can't live without it!

purplezooey 9y ago

SQlite support. awesome.

joehan 9y ago
Not integrated in vim, but try visidata (https://github.com/saulpw/visidata https://github.com/saulpw/visidata) on Sqlite. I tried after HN post last weekend and it was amazing... with Vim-like keys and interface.

agumonkey 9y ago

I'd love to see a screencast. I'm mostly an emacser but I like vi ergonomics very much, and would love to see the approach here.

marrone12 9y ago
Why not just use evil-mode in emacs?
- agumonkey 9y ago
  I'm not in the mood for learning UI right now. Also it's beside my question. I'm curious about vi culture and vi fanatics (or fetishists, or satanists, forgot the proper terminology).

pweissbrod 9y ago

This is a very nascent project but started by one of the best vim developers around, Tim Pope. As someone who has run into some of the rougher edges from time to time of dbext I applaud this effort and will closely watch progression

dguaraglia 9y ago

I see Tim Pope, I upvote. This guy has produced some of the plugins that have changed how I Vim forever (vim-surround, pathogen, vim-repeat, vim-fugitive, etc.)

notaspider 9y ago

Checkmate emacs /s