Windows: Difference between revisions
Line 28: | Line 28: | ||
Postgres does not have to be on the same server as Exodus, however, if it is not, dictionary entries cannot call Exodus subroutines. | Postgres does not have to be on the same server as Exodus, however, if it is not, dictionary entries cannot call Exodus subroutines. | ||
== Using Exodus == | == Using Exodus == |
Revision as of 14:14, 13 May 2011
Downloading and Installing Exodus
http://code.google.com/p/exodusdb/downloads
C++ Compiler
If you want to write or compile Exodus programs on Windows you need a Microsoft C++ compiler. You don't need a C++ compiler to just used the Exodus command line to access the database or run prepackaged Exodus programs.
MSVC
- Visual Studio 2003 Professional
- Visual Studio 2005 Professional
- Visual Studio 2005 Express (Requires Platform SDK)
- Visual Studio 2008 Express
- Visual Studio 2010 Express
A standard install of the free VS Express C++ preferably in the default location on C: or parallel default location but on the same drive as Exodus. No need for any SQL or options.
http://www.microsoft.com/Express/vc/
Postgresql
If you want to use Exodus to provide multivalue database functionality then you must already have or install a PostgreSQL database.
http://www.postgresql.org/download/windows
Postgres does not have to be on the same server as Exodus, however, if it is not, dictionary entries cannot call Exodus subroutines.
Using Exodus
Start, All Programs, Exodus, Exodus Console
Try the following commands.
Command | Comment |
---|---|
EDITING AND COMPILING | |
edic hello | edic=edit+compile+catalog. Creates a skeleton hello.cpp file using nano editor. edic will only compile on exit if saved, so make some change before you exit. |
hello | Run it |
compile hello | compile without editing |
edic testsort | Browse a sample exodus program showing all fundamental database operations including dictionaries and list. |
compile testsort | compile the preinstalled test program |
testsort | Run it to generate some data and inspect the output |
DATABASE OPERATIONS | |
listfiles | quick tool avoiding need to use any database client |
list myclients | text output - no page/column headers just yet sorry |
list myclients {H} | html output (port of a fully blown LIST replacement in heavy production use since 2000) |
list dict_myclients | NB the underscore after "dict" is *required*. "dict(SPACE)myclients" wont work |
list dict_voc | if you understand this then you understand your pick |
edir myclients SB001 | you can edit data or dictionaries directly. edir="edit record" |
delete myclients SB001 | useful command line tool |
createfile tempfile | ditto |
deletefile tempfile | ditto |
createindex myclients CLIENT_TYPE | speeds up select commands on the indexed fields in the traditional way |
deleteindex myclients CLIENT_TYPE | filenames are case insensitive, keys and fieldnames are CASE SENSITIVE |
If you get the following error then you have not completed the installation of the Exodus plugin for Postgres.
PGRES_FATAL_ERROR: ERROR: function exodus_extract_text(bytea, integer, integer, integer) does not exist