New in version 7.2.0

February 17th, 2015
  • Virtuoso Engine:
  • Added new threadsafe / reentrant SQL parser
  • Added support for using TLSF library for page-maps
  • Added support for setting SSL Protocols and Ciphers
  • Added support for new Unicode-3 based collations
  • Added support for custom HTTPLogFormat
  • Added support for quality factor in accept headers
  • Added rate limiter for bad connections
  • Added ODBC 3.x alias for current_date, current_time and current_timestamp
  • Improved cost based optimizer
  • Improved LDP support
  • Improved XPER support
  • Improved CSV support
  • Fixed handling of regexp cache size and pcre_match depth limit
  • Fixed handling of multibyte strings
  • Fixed handling of nvarchar data with zeroes in the middle
  • Fixed handling of values in 10 day gap between Julian and Gregorian dates
  • Fixed if expr in rdf o range condition, set super so they get placed once
  • Fixed issue possibly reading freed block
  • Fixed issue with TZ field without separator
  • Fixed issue with duplicate hashes
  • Fixed issue with invariant preds
  • Fixed issue with non chash distinct gby with nulls
  • Fixed issue with user aggregates and chash flush
  • Fixed issues with outer join, order by and group by
  • Fixed sending IRI IDs to remotes when using 'where 0'
  • Fixed use SHA256 as default for certificate signing
  • Fixed memory leaks and memory fragmentation
  • Fixed ssl read/write error condition
  • Fixed windows build
  • GEO functions:
  • Added support for SPARQL INSERT with GEO literals
  • Added support for upcoming proj4 plugin
  • Fixed issue with rdf box with a geometry rdf type and a non geometry content
  • Fixed calculation of serialization lengths for geo boxes
  • Fixed compilation of a query with bif:st_intersects inside service {}
  • Fixed serialization of geo boxes
  • Fixed intersect to working with other geo shapes
  • SPARQL:
  • Added new SPARQL pragma: define sql:comment 0/1
  • Added indicator when max rows is returned on /sparql endpoint
  • Added new role SPARQL_LOAD_SERVICE_DATA
  • Added new client callable graph ins/del/replace functions
  • Added support for __tag of UNAME
  • Added support for multiple sparql update commands
  • Added support for xsd:gYear and the like
  • Added support for CASE x WHEN ... and CASE when in SPARQL
  • Added support for 'HTML with nice turtle' output format
  • Added TransStepMode option to virtuoso.ini
  • Improved handling of floats and doubles in SPARQL compiler
  • Improved Turtle parser
  • Fixed SPARQL DELETE DATA when a complete RDF box w/o RO_ID is passed as obj
  • Fixed URI() is synonym for IRI()
  • Fixed equality of unames and strings, iri strings
  • Fixed issue eliminating empty {} in VALUE join
  • Fixed issue with R2RML
  • Fixed issue with XMLA
  • Fixed issue with base graph when using 'with_delete' in bulkloader
  • Fixed issue with multiple OPTIONAL
  • Fixed issue with sparql ... with delete on certain datatypes
  • Fixed issue with varbinary in rdf views
  • Fixed printing optimized-away data rows of VALUES in sparql_explain() dump
  • Fixed propagation of limits if SPART_VARR_EXTARNAL/GLOBAL variables present
  • Fixed regression for SPARQL 1.1 VALUES bindings
  • Fixed sort accented letters from "ORDER BY" in alphabetical order
  • Fixed startup speed with many graph group members
  • Jena & Sesame:
  • Upgraded to Jena 2.12.0
  • Added support for Bulk Loading
  • Added support for Dataset method using defaultInsertGraph and defaultRemoveGraph
  • Fixed handling of blank nodes
  • Fixed transaction handling
  • Fixed NullPointerException for sparql with OPTIONAL
  • Fixed issue with statement leaks in older Virtuoso JDBC driver
  • Fixed issue with class definitions and classcast exceptions
  • Fixed issue with large datasets like Uniprot
  • JDBC Driver:
  • Enhanced Connection Pool implementation
  • Added support for arrays for RDF Bulk loader
  • Added JDBC4 compliant metadata required by JBOSS
  • Fixed issue with statement leaks
  • Fixed issue with RoundRobin if server out of license
  • Fixed issue with stored procedures returning multiple resultsets
  • Fixed issue with rewind on Virtuoso blob
  • Fixed issue with batch procedure execution
  • Fixed issue with dates
  • Fixed issue with SQL_UTF8_EXECS=1
  • Fixed issue with JDBC testsuite
  • Faceted Browser:
  • Added support for graph selection and persist in fct state
  • Added support for link out icons on certain doc and image links
  • Added new description and sponger options as entity link types
  • Added option for json output to fct service
  • Added group by to speed up distinct
  • Added precompiled queries to speed up usage.vsp
  • Fixed base uri for crawlers
  • Fixed color scheme
  • Fixed graph perm check
  • Fixed handling of foaf:depiction
  • Fixed handling of iframe
  • Fixed issue when lang is missing to fct service
  • Fixed issue with dateTime
  • Fixed issue with double quotes in literals
  • Fixed issue with nodeID
  • Fixed issue with null graphs
  • Fixed labels
  • Fixed links

New in version 7.1.0 (September 12th, 2014)

  • Engine:
  • Enhancements to cost based optimizer
  • Added optimization when splitting on scattered inserts
  • Added optimization on fetching col seg
  • Added support for multithreaded sync/flush
  • Added support for ordered count distinct and exact p stat
  • Added new settings EnableMonitor
  • Added BIFs key_delete_replay(), set_by_graph_keywords(), tweak_by_graph_keywords, vec_length(), vec_ref(), x509_verify_array(), xenc_x509_cert_verify_array()
  • Added new functions bif_list_names() and bif_metadata()
  • Added new general-purpose HTTP auth procedure
  • Added support for local dpipes
  • Added support for session pool
  • Added option to allow restricting number of id ranges for new IRIs
  • Added support for execution profile in xml format
  • Added support for PL-as-BIFs in SPARQL
  • Improved I/O for geometries in SQL
  • Fixed geo cost of non point geos where no explicit prec
  • Fixed reentrant lexer
  • Fixed rpc argument checks
  • Fixed memory leaks
  • Fixed compiler warnings
  • Treat single db file as a single segment with one stripe
  • Updated testsuite
  • GEO functions:
  • Added initial support for geoc_epsilon(), geometrytype(), st_affine() (2D trans nly), st_geometryn(), st_get_bounding_box_n(), st_intersects(), st_linestring(), st_numgeometries(), st_transform_by_custom_projection(), st_translate() , st_transscale(), st_contains() , st_may_contain(), st_may_intersect()
  • Added new BIFs for getting Z and M coords
  • Added support for trick in order to eliminate conversion of types on function call
  • Optimization in calculation of gcb steps to make number of chained blocks close to square root of lenght of the shape
  • Fixed geo box support for large polygons
  • Fixed mp_box_copy() of long shapes
  • Fixed range checks for coordinates
  • Fixed calculation of lat/long ratio for proximity checks
  • Fixed bboxes in geo_deserialize
  • Fixed check for NAN and INF in float valued geo inx
  • Fixed check for NULL arguments
  • Minor fixes to other geo BIFs
  • SPARQL:
  • Added initial support for list of quad maps in SPARQL BI
  • Added initial support for vectored iri to id
  • Added initial support for sparql valid()
  • Added new codegen for initial fill of RDB2RDF
  • Added new settings CreateGraphKeywords, QueryGraphKeywords
  • Added new SPARQL triple/group/subqery options
  • Added missing function rdf_vec_ins_triples
  • Added support for application/x-nice-microdata SPARQL format
  • Added support for buildin inverse functions
  • Added support for geosparql wkt type literal as synonym
  • Added support for the '-' operator for datetime data types
  • Fixed issues in handling geo predicates in SPARQL
  • Fixed RDF view to use multiple quad maps
  • Fixed issues with UNION and BREAKUP
  • Fixed dynamic local for vectored
  • Fixed support for combination of T_DIRECTION 3 and T_STEP (var)
  • Fixed handle 30x redirects when calling remote endpoint
  • Fixed support for MALLOC_DEBUG inside SPARQL compiler
  • Fixed TriG parser
  • Jena & Sesame:
  • Improved speed of batch delete
  • Removed unnesessary check that graph exists after remove
  • Removed unnesessary commits
  • Replaced n.getLiteralValue().toString() with n.getLiteralLexicalForm()
  • JDBC Driver:
  • Added staticstics for Connection Pool
  • Fixed speed of finalize
  • Conductor and DAV:
  • Added trigger for delete temporary graphs used for WebID verification
  • Added new CONFIGURE methods to DETs to unify folder creation
  • Added new page for managing CA root certificates
  • Added new pages for graph level security
  • Added verify for WebDAV DET folders
  • Added creation of shared DET folders
  • Fixed creation of ETAGs for DET resources
  • Fixed DAV rewrite issue
  • Fixed dav to use proper escape for graphs when uploading
  • Fixed issue deleting graphs
  • Fixed issue uploading bad .TTL files
  • Fixed issue with DAV QoS re-write rule for text/html
  • Fixed issue with user dba when creating DET folders
  • Fixed normalize paths procedure in WebDAV
  • Fixed reset connection variable before no file error
  • Faceted Browser:
  • Added missing grants
  • Added graph param in FCT permalink
  • Changed labels in LD views
  • Changed default sort order to date (desc)
  • Copied virt_rdf_label.sql locally
  • Fixed escape double quote in literals
  • Fixed FCT datatype links
  • Fixed the curie may contain UTF-8, so mark string accordingly
  • Changed describe mode for PivotViewer link

New in version 7.0.0 (February 5th, 2014)

  • Fixed error in make install when virt_html has not been generated
  • Fixed use Dkalloc_nc.c for driver
  • Updated NEWS and ChangeLog
  • Fixed whitespace
  • Removed file
  • Rebuild driver
  • Fixed missing initialization
  • Fixed missing initialization
  • Added missing monitor.h to distribution
  • Fixed issue with testsuite on VOS
  • Fixed small issues in tsuite for VOS
  • Updated build files for Windows
  • Updated version of driver to 3.65

New in version 6.1.8 (December 12th, 2013)

  • Various fixes and improvements across the Database Engine, SPARQL features, Client RPC, Jena & Sesame, Conductor (especially WebDAV areas), and Faceted Browser.

New in version 6.1.6 (August 3rd, 2012)

  • includes support for SPARQL 1.1 BINDINGS, FILTER NOT EXIST, and SERVICE DESCRIPTION clauses; soundex and difference; WebID protected endpoints; a new RDB2RDF VAD package; and Sponger support for Wolfram|Alpha, FTP URLs, and output as tab-separated values (TSV). ODS includes new API documentation; advanced ACLs for SPARQL and services auth; support for Dropbox, Box.net, Google Drive, and Skydrive; and CalDAV import. Fixes include ETag calculation; ODBC connection handle error-handling; date-time conversion; rdf/xml IRI escaping; microdata namespace issues; and miscellaneous building and portability issues.

New in version 6.1.4 (November 1st, 2011)

  • This version includes Database Engine and SPARQL optimizations and enhancements, HTTP enhancements like SPARQL 1.1 Graph Store and SPARQL CRUD, new Sponger cartridges for Eventbrite, Eventful, Foursquare, Google+, Google Place, Google Product, Google Profile, Gowalla, Guardian, Hyperpublic, Jigsaw, LinkedIn, Plancast, ProgrammableWeb, Seatgeek, Seevl, SimpleGeo, Upcoming, XRD, Zappos, and Zoopla, and fixes to existing cartridges.
  • Fixes include deadlock handling, memory handling and leaks, and SPARQL and SPARUL fixes. Jena and Sesame2 drivers were updated.

New in version 6.1.2 (July 13th, 2010)

  • This release includes new Python runtime hosting; semantic pingback APIs; new Sponger cartridges for CSV, Etsy, Facebook and OpenGraph, Tumblr and support for OData Atom and JSON feeds.
  • Jena and Sesame providers support creating rulesets and inference graphs and ARQ interoperability.
  • ODS apps support OpenID 2.0, FOAF+SSL registration and ACLs, WebID, and PubSubHubbub. GoodRelations Offers are incorporated into Profile Manager.
  • Address memory handling and leaks were fixed.
  • SPARQL now handles "distinct", "union", "group by"/"order by", and SPARUL "insert".
  • HTTP proxying SOAP and XML-RPC was fixed.

New in version 6.1.1 (April 1st, 2010)

  • Database engine:
  • Added wizard-based generation of SQL Tables from CSV imports
  • Added wizard-based publishing of RDF based Linked Data from CSV files
  • Added FOAF+SSL login for SQL clients
  • Added OPTIONS for HTTP server
  • Added support for setMaxRows in JDBC driver
  • Added support for JDBC Hibernate
  • Added support for unzip_file()
  • Added swap guard option
  • Fixed deadlock retry
  • Fixed memory leaks
  • Fixed mtx checks for checkpoint and log write
  • Fixed X509ClientVerify flag of 0/1/2/3 to accept self-signed or optional certificates
  • Fixed several issues with JDBC XA support
  • Fixed use sk_X509_ALGOR_* macros to support OpenSSL 1.0.0
  • Fixed wide character when getting procedure columns information.
  • Fixed remove id from hash before free structure
  • Fixed IN pred as iterator before index path
  • Fixed missing initialization in calculation of cost and cardinality
  • Fixed SQL codegen for NOT() retval expression
  • Updated documentation
  • SPARQL and RDF:
  • Added OData cartridge for producing RDF-based Linked Data from OData resource collections
  • Added CSV cartridge for producing and deploying RDF-based Linked Data from CSV resource types
  • Added uStream cartridge
  • Added slidesix cartridge
  • Added optimization of sprintf_inverse(const)
  • Added improved version of xsl:for-each-row for both SPARQL and SQL
  • Added DefaultServiceMap and DefaultServiceStorage
  • Added immortal IRI for uname_virtrdf_ns_uri_DefaultServiceStorage
  • Added proper ASK support in web service endpoint
  • Fixed SPARQL 1.1 compatibility in result set syntax
  • Fixed incorrect codegen of formatter in ssg_select_known_graphs_codegen
  • Fixed do not encode default graph
  • Fixed check if datadump is gz
  • Fixed detection of n3 and nt formats
  • Fixed regex to remove default ns from XML
  • Fixed run microformats independent of RDFa
  • Fixed bug with UTF-8 encoded strings in box
  • Fixed allow chunked content to be read as strses
  • Fixed SERVICE parameter passing for basic Federated SPARQL (SPARQL-FED)
  • Fixed (!ask(...)) in filters
  • Fixed codegen for FILTER (?local = IRI(?:global)) .
  • Fixed codegen in LIMIT ?:global-variable and OFFSET ?:global-variable
  • Fixed support for positional and named parameters from exec() or similar in SPARQL, as if they where global variables of other sorts
  • Fixed rewriting of group patterns with filters replaced with restrictions on equivs
  • Fixed faster loading of inference sets from single and graph groups
  • Upgraded native data providers for Jena to version 2.6.2
  • Upgraded native data providers for Sesame to version 2.3.1
  • Added support for Sesame 2 HTTP repository interface
  • Added implemented Sesame's Inference Context interfaces (for backward chained reasoning).
  • ODS Applications:
  • Added profile page improvements covering Favorite Things, GoodRelations-based Offerings (via "Seeks" and "Offers" UIs)
  • Added alternative registration and profile management pages (VSP, PHP, and Javascript variants) that work REST-fully with ODS engine
  • Added X.509 create certificate generation and export to alternative ODS profile management pages (VSP, PHP, and Javascript)
  • Added a++ option in user's pages
  • Added updates to Certificate Ontology used by FOAF+SSL
  • Added support for Google map v3
  • Added 'Import' to user pages (VSP, PHP, etc.)
  • Fixed Profile Management UI quirks
  • Fixed SIOC subscriptions
  • Fixed object properties in favorites
  • Fixed ontology APIs
  • Fixed use newer OAT functions
  • Fixed invitation problem with multiple users
  • Fixed typo in scovo:dimension
  • Fixed image preview

New in version 6.1.0 (February 13th, 2010)

  • Database engine:
  • Added new 2+3 index scheme for RDF_QUAD table
  • Added new inlined string table for RDF_QUAD
  • Added optimizations to cost based optimizer
  • Added RoundRobin connection support
  • Removed deprecated samples/demos
  • Fixed align buffer to sizeof pointer to avoid crash on strict checking platforms like sparc
  • Fixed text of version mismatch messages
  • Fixed issue with XA exception, double rollback, transact timeout
  • Merged enhancements and fixes from V5 branch
  • SPARQL and RDF:
  • Added support for owl:inverseOf, owl:SymmetricProperty and owl:TransitiveProperty.
  • Added DB.DBA.BEST_LANGMATCH() and bif_langmatches_pct_http()
  • Added initial support for SPARQL-FED
  • Added initial support for SERVICE { ... };
  • Added support for expressions in LIMIT and OFFSET clauses
  • Added support for Google Base, ithalia, revyu
  • Added built-in predicate IsRef()
  • Added new error reporting for unsupported syntax
  • Added rdf box id only serialization; stays compatible with 5/6
  • Added Yelp categories
  • Added support for SPARQL INSERT DATA / DELETE DATA
  • Added support for HAVING in sparql
  • Added special codegen for sparql select distinct ?g where { graph ?g { ?s ?p ?o }}
  • Added support for RDFa export
  • Added support for output:maxrows
  • Improved SPARQL parsing and SQL codegen for negative numbers
  • Improved recovery of lists in DB.DBA.RDF_AUDIT_METADATA()
  • Fixed iSPARQL use of external sparql endpoints
  • Fixed bad init in trans node if multiple inputs or step output values
  • Fixed redundant trailing '>' in results of TTL load when IRIs contain special chars
  • Fixed problem with rfc1808_expand_uri not using proper macros and allocate byte extra for strings
  • Fixed when different TZ is used, must find offset and transform via GMT
  • Fixed graph-level security in cluster
  • Fixed redundant equalities in case of multiple OPTIONALs with same variable
  • Fixed BOOLEAN_OF_OBJ in case of incomplete boxes
  • Fixed NTRIPLES serialization of triples
  • Merged enhancements and fixes from V5 branch
  • ODS Applications:
  • Added support for ckeditor
  • Added new popup calendar based on OAT
  • Added VSP and REST implementation for user API
  • Added new API functions
  • Added FOAF+SSL groups
  • Added feed admin rights
  • Added Facebook registration and login
  • Removed deprecated rte and kupu editors
  • Removed support for IE 5 and 6 compatibility
  • Merged enhancements and fixes from V5 branch

New in version 5.0.12 (October 20th, 2009)

  • This release includes PKI support in the Conductor, failover/round-robin support in all clients, a refactored JDBC driver, SPARQL graph-level security, a new RDFa parser, optimizations to the SPARQL engine, and new Sponger Cartridges for OpenOffice, Google apps and Picasa, Yelp, Tesco, GoodRelations, Geonames, and Alchemy, amongst others.
  • In the ODS application suite there is support for expirations and conversations, as well as the hCard microformat.
  • There are fixes for XA support, memory leaks, RDF View generation, OpenID, atom-publishing upstreaming of attachments, and other minor bugs.

New in version 6.0 TP1 (April 27th, 2009)

  • Updated version to 6.0.0-tp1 for Initial Release
  • Initial checkin of V6 single engine code

New in version 5.0.10 (February 18th, 2009)

  • This release includes initial JDBC 4.x support, rate-limiting HTTP ACLs, INI-file options for a lite/embeddable mode, new sponger cartridges, FOAF+SSL support, new CURIE-generation functions, greater integration with Amazon S3 storage, a programmatic interface to data-spaces via Ubiquity, performance optimizations, and bugfixes.

New in version 5.0.9 (November 6th, 2008)

  • This version brings performance optimizations for the SQL and SPARQL engines and ODBC and JDBC drivers.
  • New features include: an Excel MIME-type output option in the SPARQL endpoint; triple options bif:contains and transitivity; new RDF-generating cartridges with UMBEL lookups for the Sponger; support for very large HTTP client requests; a sparql-auth endpoint with digest authentication; and support for the Ubiquity Firefox plugin.
  • There are also minor bugfixes for memory leaks, SPARQL "select distinct", and various SQL query syntax handling.
  • XHTML validation is done in the ODS application suite.

New in version 5.0.8 (August 27th, 2008)

  • Database engine
  • Added optimizations to SQL compiler
  • Added re-entrant SQL compiler
  • Added optimizations for identity self joins
  • Added optimizations to JDBC drivers
  • Fixed compiler warnings
  • Fixed unneeded memory allocations in soap calls
  • SPARQL and RDF
  • Added optimizations to SPARQL engine
  • Added SPARQL-BI extensions
  • Added support for TriG format
  • Added support for 'define input:param" and "define input:param-valmode"
  • Added Digg, FriendFeed, OpenLibrary Books, CrunchBase cartridges
  • Added search results feed
  • Added support for bibo:document, foaf:document and sioc:container
  • Added #this to proxy IRIs
  • Added seeAlso for freebase extraction to link with wikipedia
  • Fixed WHERE conditions in BREAKUP
  • Fixed sparql construction for OPTIONAL
  • Fixed calls to startQueryResult/endQueryResult in Sesame2 provider
  • Fixed sponger to not sponge refs to self
  • Fixed small bugs in cartridges
  • ODS applications
  • Added support for new OAT Map
  • Added subscriptions
  • Added "Province" locator
  • Updated SIOC services namespace
  • Fixed Gems URL
  • Fixed SyncML support
  • Fixed small bugs