|
|
| (23 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| == Downloading and Installing Exodus == | | == Downloading and Installing Exodus == |
|
| |
|
| http://code.google.com/p/exodusdb/downloads
| | [[Step by step instructions]] |
| | |
| == 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 (works)
| |
| *Visual Studio 2010 Express (not known)
| |
| | |
| 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 but if not, you will not be able to use dictionary entries that are written in Exodus code.
| |
| | |
| === Windows Postgres plugin ===
| |
| | |
| At the moment the Windows installer does not install the pgexodus.dll plugin for postgres automatically and you must copy pgexodus.dll from the installed exodus bin directory to the postgres lib directory (for example).
| |
| | |
| copy "C:\Program Files\Exodus\10.10\lib\pgexodus-8.dll" "C:\Program Files\PostgreSQL\8.4\lib"
| |
| | |
| copy "C:\Program Files\Exodus\10.10\lib\pgexodus-9.dll" "C:\Program Files\PostgreSQL\9.0\lib"
| |
| | |
| === Postgres configuration ===
| |
| | |
| By default, Exodus assumes the following postgres configuration. This of course is not secure and should only be used for testing purposes.
| |
| | |
| host=127.0.0.1 port=5432 dbname=exodus user=exodus password=somesillysecret connect_timeout=10
| |
| | |
| The following Exodus command prompts for a postgres admin user and password and creates the default database and password.
| |
| | |
| configexodus
| |
| | |
| Alternatively, you can use any Postgres utility to create an initial database and user. The user should have database creation rights if you wish to be able to create and drop databases from Exodus but there is no need for the user to have admin rights.
| |
| | |
| notepad %USERPROFILE%\.exodus
| |
| | |
| host=127.0.0.1 port=5432 dbname=exodus user=exodus password=somesillysecret connect_timeout=10
| |
| | |
| The following environment variables can override default and .exodus parameters on a one by one basis.
| |
| | |
| set EXODUS_HOST=127.0.0.1
| |
| set EXODUS_PORT=5432
| |
| set EXODUS_DBNAME=exodus
| |
| set EXODUS_USER=exodus
| |
| set EXODUS_PASSWORD=somesillysecret
| |
| set EXODUS_TIMEOUT=10
| |
|
| |
|
| == Using Exodus == | | == Using Exodus == |
| Line 64: |
Line 7: |
| Start, All Programs, Exodus, Exodus Console | | Start, All Programs, Exodus, Exodus Console |
|
| |
|
| Try the following commands.
| | {{exodus console first steps}} |
| | |
| {| | |
| !Command !!Comment
| |
| |-
| |
| |configexodus ||One time setup of default database and user in postgres (exodus and exodus)
| |
| |-
| |
| |<U>EDITING AND COMPILING</U>
| |
| |-
| |
| |edic test ||Creates a skeleton test.cpp file using nano editor with exodus. edit will compile on exit if saved, so make some change before you exit.
| |
| |-
| |
| |test ||Run it
| |
| |-
| |
| |compile test ||compile without editing
| |
| |-
| |
| |edic testsort ||Browse a sample exodus program showing all fundamental database operations including dictionaries and list.
| |
| |-
| |
| |<U>DATABASE OPERATIONS</U>
| |
| |-
| |
| |compile testsort ||compile the preinstalled test program
| |
| |-
| |
| |testsort ||Run it to generate some data and inspect the output
| |
| |-
| |
| |listfiles ||quick tool avoiding need to use any database client
| |
| |-
| |
| |list test_clients ||text output - no page/column headers just yet sorry
| |
| |-
| |
| |list test_clients (H) ||html output (port of a LIST replacement in heave use since 2000)
| |
| |-
| |
| |list dict_test_clients ||nb the underscore after "dict" is required - dict(space)voc wont work
| |
| |-
| |
| |list dict_voc ||if you understand this then you understand your pick
| |
| |-
| |
| |edir test_clients SB001 ||you can edit data or dictionaries directly
| |
| |-
| |
| |delete test_clients SB001 ||useful command line tool
| |
| |-
| |
| |createfile tempfile ||ditto
| |
| |-
| |
| |deletefile tempfile ||ditto
| |
| |-
| |
| |createindex test_clients CLIENT_TYPE ||speeds up select commands on the indexed fields in the traditional way
| |
| |-
| |
| |deleteindex test_clients CLIENT_TYPE ||filenames are case insensitive, keys and fieldnames are not
| |
| |}
| |
| | |
| If you get the following error then you have not completed the installation of pgexodus.dll function in postgres as described in the section on postgres above.
| |
| | |
| PGRES_FATAL_ERROR: ERROR: function exodus_extract_text(bytea, integer, integer, integer) does not exist
| |
| | |
| == Documentation how to program in Exodus ==
| |
| | |
| No programming manual yet but there is a list of functions in wiki at
| |
| | |
| http://code.google.com/p/exodusdb
| |
| [[Unorganised notes about programming in Exodus]]
| |
| | |
| == Source code and Exodus development environment ==
| |
| | |
| http://code.google.com/p/exodusdb has latest full source code and tools to build exodus from scratch on all supported platforms.
| |
| | |
| include\exodusfuncs.h lists the functions that simulates pickish syntax as close as can be achieved. The functionality however should be identical.
| |
| | |
| include\exodusmacros.h lists a few keywords to simplify programming for application programmers not interested in the raw power of c++.
| |
| | |
| include\mv.h lists the massive var class definition that defines how to write pick in oo object.method() style syntax.
| |
| | |
| Following is not up to date but still informative.
| |
| | |
| http://devwiki.neosys.com/dox
| |
