9

GitHub - urbint/emacs-postgresql-interactive

 3 years ago
source link: https://github.com/urbint/emacs-postgresql-interactive
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

PostgreSQL Interactive

Live, interactive development support for PostgreSQL

Features

  • DB-aware autocomplete via Company
  • Multi-connection autocomplete in org-mode source blocks via Company

Planned features

  • Autocomplete in string literals in source code
  • Interactive schema and documentation lookup
  • Context-aware autocomplete
  • Syntax and schema checking via Flycheck

Installation

Quelpa

(quelpa '(emacs-postgresql-interactive
          :fetcher github
          :repo "urbint/emacs-postgresql-interactive"))

DOOM Emacs

;; in packages.el
(package! emacs-postgresql-interactive
  :recipe (:fetcher github
           :repo "urbint/emacs-postgresql-interactive"
           :files ("*")))

;; in config.el
(def-package! emacs-postgresql-interactive)

Spacemacs

;; in .spacemacs (SPC+fed)
   dotspacemacs-additional-packages
    '((emacs-postgresql-interactive :location (recipe :fetcher github :repo "urbint/emacs-postgresql-interactive")))

Setup

First you will want to require the package:

(require 'company-postgresql)

Then you will want to make sure to add the backend for company to your org-mode-hook:

(add-to-list 'company-backends 'company-ob-postgresql)

Then make sure that you have a pgpass file with all the required fields for your target database

Should just work with ob-sql


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK