All Projects → openlink → Virtuoso Opensource

openlink / Virtuoso Opensource

Licence: other
Virtuoso is a high-performance and scalable Multi-Model RDBMS, Data Integration Middleware, Linked Data Deployment, and HTTP Application Server Platform

Programming Languages

c
50402 projects - #5 most used programming language

Projects that are alternatives of or similar to Virtuoso Opensource

Gorose
GoRose(go orm), a mini database ORM for golang, which inspired by the famous php framwork laravle's eloquent. It will be friendly for php developer and python or ruby developer. Currently provides six major database drivers: mysql,sqlite3,postgres,oracle,mssql, Clickhouse.
Stars: ✭ 947 (+37.65%)
Mutual labels:  sql, databases
Vanillacore
The core engine of VanillaDB
Stars: ✭ 119 (-82.7%)
Mutual labels:  sql, databases
Migrate
Database migrations. CLI and Golang library.
Stars: ✭ 7,712 (+1020.93%)
Mutual labels:  sql, databases
Firenze
Adapter based JavaScript ORM for Node.js and the browser
Stars: ✭ 131 (-80.96%)
Mutual labels:  sql, databases
Rom
Data mapping and persistence toolkit for Ruby
Stars: ✭ 1,959 (+184.74%)
Mutual labels:  sql, databases
Trino
Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
Stars: ✭ 4,581 (+565.84%)
Mutual labels:  sql, databases
Jcabi Jdbc
Fluent Wrapper of JDBC
Stars: ✭ 90 (-86.92%)
Mutual labels:  sql, databases
Developer Handbook
An opinionated guide on how to become a professional Web/Mobile App Developer.
Stars: ✭ 1,830 (+165.99%)
Mutual labels:  sql, databases
Atdatabases
TypeScript clients for databases that prevent SQL Injection
Stars: ✭ 154 (-77.62%)
Mutual labels:  sql, databases
Migrate
Database migrations. CLI and Golang library.
Stars: ✭ 2,315 (+236.48%)
Mutual labels:  sql, databases
Hue
Open source SQL Query Assistant service for Databases/Warehouses
Stars: ✭ 351 (-48.98%)
Mutual labels:  sql, databases
Awesome Semantic Web
A curated list of various semantic web and linked data resources.
Stars: ✭ 642 (-6.69%)
Mutual labels:  sparql
Manticoresearch
Database for search
Stars: ✭ 610 (-11.34%)
Mutual labels:  sql
Beekeeper Studio
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
Stars: ✭ 8,053 (+1070.49%)
Mutual labels:  sql
Lucid
AdonisJS official SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more
Stars: ✭ 613 (-10.9%)
Mutual labels:  sql
Atlas
Quick SQLMap Tamper Suggester
Stars: ✭ 679 (-1.31%)
Mutual labels:  sql
Node Sqlite
SQLite client for Node.js applications with SQL-based migrations API written in Typescript
Stars: ✭ 642 (-6.69%)
Mutual labels:  sql
Datafusion
DataFusion has now been donated to the Apache Arrow project
Stars: ✭ 611 (-11.19%)
Mutual labels:  sql
Sqlparser Rs
Extensible SQL Lexer and Parser for Rust
Stars: ✭ 607 (-11.77%)
Mutual labels:  sql
Dat
Go Postgres Data Access Toolkit
Stars: ✭ 604 (-12.21%)
Mutual labels:  sql

Virtuoso Open-Source Edition: Building

Copyright (C) 1998-2021 OpenLink Software [email protected]

Table of Contents

  • Building Virtuoso Open-Source Edition
  • .. Introduction
  • .. Package Dependencies
  • .. Diskspace Requirements
  • .. Make FAQ
  • .... Generic build environment
  • .... AIX 4.x 32-bit
  • .... AIX 4.x 64-bit
  • .... AIX 5.x 32-bit
  • .... AIX 5.x 32-bit
  • .... Digital Unix/OSF1 V5.0 64-bit
  • .... HP/UX 11.00 32-bit
  • .... HP/UX 11.00 64-bit
  • .... HP/UX 11.23 Itanium 32-bit
  • .... HP/UX 11.23 Itanium 64-bit
  • .... Linux 32-bit
  • .... Linux 64-bit
  • .... Mac OS X 10.2 and 10.3 PPC 32-bit
  • .... Mac OS X 10.4 PPC 32-bit
  • .... Mac OS X 10.4 PPC 64-bit
  • .... Mac OS X 10.4 Universal 32-bit
  • .... Mac OS X 10.5 32-bit
  • .... Mac OS X 10.5 64-bit
  • .... Mac OS X 10.5 Universal
  • .... Mac OS X 10.6 32-bit
  • .... Mac OS X 10.6 64-bit
  • .... Mac OS X 10.6 Universal
  • .... Mac OS X 10.7 32-bit
  • .... Mac OS X 10.7 64-bit
  • .... Mac OS X 10.7 Universal
  • .... Solaris 2.x i386 32-bit
  • .... Solaris 2.10 Opteron 32-bit
  • .... Solaris 2.10 Opteron 64-bit
  • .... Solaris 2.8 and above SPARC 32-bit
  • .... Solaris 2.8 and above SPARC 32-bit
  • .. Installation
  • .... Test Suite
  • .. Getting Started
  • .... VAD Packages

Introduction

This document explains steps to take after obtaining a Virtuoso source snapshot or git clone.

These sections explain how to compile, test and install and what components are produced by the make process and how one can interact with them.

Package Dependencies

To generate the configure script and all other build files necessary, please make sure the following packages and recommended versions are installed on your system.

Package Minimum Upto From
autoconf 2.57 2.69 http://www.gnu.org/software/autoconf/
automake 1.9 1.16.1 http://www.gnu.org/software/automake/
libtool 1.5 2.4.6 http://www.gnu.org/software/libtool/
flex 2.5.33 2.6.4 http://flex.sourceforge.net/
bison 2.3 3.5.1 http://www.gnu.org/software/bison/
gperf 3.0.1 3.1 http://www.gnu.org/software/gperf/
gawk 3.1.1 5.0.1 http://www.gnu.org/software/gawk/
m4 1.4.1 1.4.18 http://www.gnu.org/software/m4/
make 3.79.1 4.2.1 http://www.gnu.org/software/make/
OpenSSL 0.9.8e 1.1.1 http://www.openssl.org/

and any GNU packages required by these. The autogen.sh and configure scripts check for the presence and right version of some of the required components.

The Minimum column contains the oldest known versions of these packages capable of building Virtuoso. Older versions of these packages can sometimes be used, but could cause build problems.

The Upto column contains the most recently tested version of these packages.

To check the version number of the tools installed on your system, use one of the following commands:

  • autoconf --version
  • automake --version
  • libtoolize --version
  • flex --version
  • bison --version
  • gperf --version
  • gawk --version
  • m4 --version
  • make --version
  • openssl version

If you have an older version than automake version 1.9 you can edit the configure.ac script around line 47 using the examples provided for each version.

Note that many operating systems (particularly all Linux distibutions) split some of these packages into runtime and development packages, so users of these platforms may need to run e.g.:

apt-get install libssl-dev

or

yum install openssl-devel 

to get development headers & libraries for OpenSSL.

Diskspace Requirements

The build produces a demo database and Virtuoso application packages that are quite large. At least 800 MB of free space should be available in the build file system.

When running `make install', the target file system should have about 460 MB free. By default, the install target directories are under /usr/local/, but you can specify

./configure --prefix=/path/to/dir

instead.

The minimum working configuration consists of the server executable and config files plus database, no more than a few MB for the server executable, depending on platform and options.

Make FAQ

In the root directory of the checkout perform the following commands:

./autogen.sh        # should only be needed in git clone
./configure
make

to produce the default binaries, VAD packages and demo database. This takes some time, principally due to building and filling the demo database, rendering the XML documentation into several target formats and composing various Virtuoso application packages. It takes about 30 minutes on a 2GHz machine.

The default configure does not enable most of the runtime-hosting and extension features. See the links on the building page for instructions on how to enable these and what additional software is required.

Some builds require additional C compiler and other environment flags to be set before running the configure command, especially when building 64-bit versions of the server. If your system is not in this list, please try to run the configure command without any environment settings.

Warning: if VAD or other packages fail to be built, especially on 64-bit Linux platforms, ensure you're not using excessive optimization. CFLAGS="-O2" is known to work but there are reports of -O3 failing.

If your system requires additional flags not listed below, please contact us at [email protected].

Generic build environment

CC=cc
CFLAGS="-O"
export CFLAGS CC
./configure
make
make install

AIX 4.x 32-bit

CC=cc_r7
CFLAGS="-O -q32"
LDFLAGS="-brtl"
OBJECT_MODE=32
export CC CFLAGS LDFLAGS OBJECT_MODE
./configure ...

AIX 4.x 64-bit

CC=cc_r7
CFLAGS="-O -q64"
LDFLAGS="-brtl"
OBJECT_MODE=64
export CC CFLAGS LDFLAGS OBJECT_MODE
./configure ...

AIX 5.x 32-bit

CC=cc_r
CFLAGS="-O -q32"
LDFLAGS="-brtl"
OBJECT_MODE=32
export CC CFLAGS LDFLAGS OBJECT_MODE
./configure ...

AIX 5.x 32-bit

CC=cc_r
CFLAGS="-O -q64"
LDFLAGS="-brtl"
OBJECT_MODE=64
export CC CFLAGS LDFLAGS OBJECT_MODE
./configure ...

Digital Unix/OSF1 V5.0 64-bit

CFLAGS="-O"
export CFLAGS
./configure ...

HP/UX 11.00 32-bit

CFLAGS="-O -Ae +DA1.1"
export CFLAGS
./configure ...

HP/UX 11.00 64-bit

CFLAGS="-O -Ae +DA2.0W"
export CFLAGS
./configure ...

HP/UX 11.23 Itanium 32-bit

CFLAGS="-O -Ae +DD32"
export CFLAGS
./configure ...

HP/UX 11.23 Itanium 64-bit

CFLAGS="-O -Ae +DD64"
export CFLAGS
./configure ...

Linux 32-bit

CFLAGS="-O2"
export CFLAGS
./configure ...

Linux 64-bit

CFLAGS="-O2 -m64"
export CFLAGS
./configure ...

Mac OS X 10.2 and 10.3 PPC 32-bit

CFLAGS="-O -m32 -mmacosx-version-min=10.4"
export CFLAGS
./configure ...

Mac OS X 10.4 PPC 32-bit

CFLAGS="-O -m32 -mmacosx-version-min=10.4"
export CFLAGS
./configure ...

Mac OS X 10.4 PPC 64-bit

CFLAGS="-O -m64 -mmacosx-version-min=10.4"
export CFLAGS
./configure ...

Mac OS X 10.4 Universal 32-bit

CFLAGS="-O -isysroot /Developer/SDKs/MacOSX10.4u.sdk -arch ppc -arch i386 -mmacosx-version-min=10.4"
export CFLAGS
./configure --disable-dependency-tracking ...

Mac OS X 10.5 32-bit

CFLAGS="-O -m32 -mmacosx-version-min=10.5"
export CFLAGS
./configure ...

Mac OS X 10.5 64-bit

CFLAGS="-O -m64 -mmacosx-version-min=10.5"
export CFLAGS
./configure ...

Mac OS X 10.5 Universal

CFLAGS="-O -isysroot /Developer/SDKs/MacOSX10.5.sdk -arch ppc -arch i386 -arch ppc64 -arch x86_64 -mmacosx-version-min=10.5"
export CFLAGS
./configure --disable-dependency-tracking ...

Mac OS X 10.6 32-bit

CFLAGS="-O -m32 -mmacosx-version-min=10.6"
export CFLAGS
./configure ...

Mac OS X 10.6 64-bit

CFLAGS="-O -m64 -mmacosx-version-min=10.6"
export CFLAGS
./configure ...

Mac OS X 10.6 Universal

CFLAGS="-O -isysroot /Developer/SDKs/MacOSX10.6.sdk -arch i386 -arch x86_64 -mmacosx-version-min=10.6"
export CFLAGS
./configure --disable-dependency-tracking ...

Mac OS X 10.7 32-bit

CFLAGS="-O -m32 -mmacosx-version-min=10.7"
export CFLAGS
./configure ...

Mac OS X 10.7 64-bit

CFLAGS="-O -m64 -mmacosx-version-min=10.7"
export CFLAGS
./configure ...

Mac OS X 10.7 Universal

CFLAGS="-O -arch i386 -arch x86_64 -mmacosx-version-min=10.7"
export CFLAGS
./configure --disable-dependency-tracking ...

Solaris 2.x i386 32-bit

Note: on Solaris or Open Solaris we recommend you use gmake either from /usr/ sfw/bin/ or install it from sunfreeware, as long as it's version 3.80 or better.

CC=cc
CFLAGS="-O"
PATH=/opt/SUNWspro/bin:/usr/ccs/bin:$PATH
export CFLAGS CC PATH
./configure ...

Solaris 2.10 Opteron 32-bit

CC=cc
CFLAGS="-O -xtarget=opteron"
PATH=/opt/SUNWspro/bin:/usr/ccs/bin:$PATH
export CFLAGS CC PATH
./configure ...

Solaris 2.10 Opteron 64-bit

CC=cc
CFLAGS="-O -xtarget=opteron -xarch=amd64"
PATH=/opt/SUNWspro/bin:/usr/ccs/bin:$PATH
export CFLAGS CC PATH
./configure ...

Solaris 2.8 and above SPARC 32-bit

CC=cc
CFLAGS="-O"
PATH=/opt/SUNWspro/bin:/usr/ccs/bin:$PATH
export CFLAGS CC PATH
./configure ...

Solaris 2.8 and above SPARC 32-bit

CC=cc
CFLAGS="-O -xtarget=ultra -xarch=v9"
PATH=/opt/SUNWspro/bin:/usr/ccs/bin:$PATH
export CFLAGS CC PATH
./configure ...

Installation

After running configure && make,

make install

at the root of the build tree copies the files to the locations specified by the --prefix option to configure. The default of --prefix is /usr/local/. You can override this by specifying `make install prefix=/home/virtuoso' instead, for example.

These subdirectories are all appended to the specified prefix, i.e. /usr/local/ by default:

  • share/virtuoso/doc/html
  • share/virtuoso/doc/pdf
  • share/virtuoso/vad - VAD packages BPEL, Conductor, tutorials, documentation
  • var/lib/virtuoso/db - Empty database
  • var/lib/virtuoso/demo - Demo database - obsolete as of version 5.0.3
  • bin/ - The virtuoso-t, isql, isqlw, virt_mail, virtuoso-sample-t, inifile executables
  • lib/ - libvirtuoso-t.a libvirtuoso-t.la virtodbc32.a virtodbc32.la virtodbc32 r.a virtodbc32_r.la virtodbc_r.so wikiv.so, plus any plugins that may be enabled.
  • lib/virtuoso - hosting sample.a hosting_sample.la hosting_sample.so plugin_sample.a plugin_sample.so

Note: as of version 5.0.2, the ./configure script supports different subdirectory structures with the --with-layout= parameter. If you've specified something other than the default, the above may differ accordingly.

As of version 5.0.3, the demo is a VAD package, not a separate directory.

Test Suite

Optionally, you can run

make check

at the root of the build tree to start the automated test suite. This takes about an hour on a 2GHz machine and requires approximately 1 GB of free disk space.

Getting Started

Run

cd var/lib/virtuoso/db 
virtuoso-t -f &

to start the server in the background. It will not detach from the shell, so you see the startup messages.

By default, when no -c parameter is specified, virtuoso will use the virtuoso.ini file in this directory, which is generated as part of `make install'.

The first time it's run, it will create the empty database (no special commands required) and install the Conductor VAD package. From here, you can access http://localhost:8890/ and http://localhost:8890/conductor/ and use the System Administration / Packages page to install other packages such as Demo and the ODS suite (addressbook, weblog, feeds manager and other applications) etc.

The default login is dba' with a password ofdba' for the Conductor and isql (for DAV functions, the default login is dav' with a password ofdav').

You will see a checkpoint in the terminal for each package selected:

15:33:54 INFO: Checkpoint made, log reused

To connect with the command line SQL tool,

isql 1112 dba dba

gives a SQL> prompt.

If you've installed the demo VAD above, type SQL> use Demo;

to switch to the demo database, containing the Microsoft Northwind sample tables. The `help' command in isql gives further instructions.

To use the web admin interface, point the browser to:

http://localhost:8890/conductor

To read the documents online:

http://localhost:8890/doc/html

To experiment with online tutorials you can use the conductor to install the Tutorial vad package into your database, then point the browser to:

http://localhost:8890/tutorial

VAD Packages

The different VAD packages can be installed via ISQL using the following command (if the installation packages reside in the filesystem):

SQL> vad_install ('file/system/path/package-name.vad', 0);

Alternatively, you can copy VAD packages to Virtuoso's DAV repository and then execute the following command (also from ISQL):

SQL> vad_install ('webdav/path>/package-name.vad', 1);

at the isql command line. Note that the DirsAllowed parameter of the Parameters section of the ini-file must allow access to the directory where the package file is located.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].