Welcome to sql-admin.org!

sql-admin is a database engine administration tool for GNU Emacs.

Or at least that is the intention. sql-admin.el is currently in development and there is no usable version. If you are interested in contributing to this project, or have any other comments or questions please direct them to Dan McKinley via mcfunley at gmail.

About this Project

The goal of this project is to provide an Emacs-based alternative to programs like pgadmin and mysqladmin. This will present a uniform interface for common tasks like editing sprocs and queries, dumping data, and so on across several different database engines.

Where to get the code

As noted above, in its current state this project is very unstable and not even really usable. But if you would like to take a look, the subversion repository is located at http://sql-admin.org/svn/. You can check out the latest version to the current directory with this command: 

$ svn co http://sql-admin.org/svn/trunk .

Or, you can browse the repository using the Browse Source link.

How to work on the Project

For now, there's not really any entry point other than the functions. You can use a function like this one to load it and get it working: 

(defun temp-reload-sql-admin ()
  (setq sql:*postgres-map* nil)
  (let ((files 
	 (mapcar 
	  '(lambda (f)
	     (format 
	      "/Users/dmckinley/Projects/sql-admin/trunk/sql-admin/%s.el" f))
	  '("pg" "sql-admin-util" "sql-admin-faces" "sql-admin-structs" 
	    "sql-admin-core" "sql-admin-pg" "sql-admin"))))
    (mapcar 'load-file files)
    (mapcar 'find-file files))
  (sql:set-engine-map sql:*postgres-map*)
  (sql:set-connargs 
   :dbname "my_database" 
   :user "postgres" 
   :port 5432))

Then from there you can test that it's working with something like this in IELM: 

ELISP> (sql:view-results (sql:query "select * from some_table limit 50;"))

NotesForReadme