Hiperspace.SQL
2.5.0
Prefix Reserved
See the version list below for details.
dotnet add package Hiperspace.SQL --version 2.5.0
NuGet\Install-Package Hiperspace.SQL -Version 2.5.0
<PackageReference Include="Hiperspace.SQL" Version="2.5.0" />
<PackageVersion Include="Hiperspace.SQL" Version="2.5.0" />
<PackageReference Include="Hiperspace.SQL" />
paket add Hiperspace.SQL --version 2.5.0
#r "nuget: Hiperspace.SQL, 2.5.0"
#:package Hiperspace.SQL@2.5.0
#addin nuget:?package=Hiperspace.SQL&version=2.5.0
#tool nuget:?package=Hiperspace.SQL&version=2.5.0
Hiperspace.SQL
Hiperspace.SQL is a full SQL query engine for Hiperspace, supporting the full range of joins, aggregations, and subqueries.
Hiperspace.SQL provides the same query functionality as a .NET client can use with LINQ queries, but without the need to write code in C#/F#
Hiperspace fully supports point-in-time "time travel" queries that are not possible with Python Data-Frames or DuckDB
Features
- Hiperspace.SQL is not limited to queries of columns within a table, but supports the full navigation of properties of Hiperspace elements
- Where a column is a complex object it is returned as a JSON object
- Executing a batch of SQL statements return columnar data frames (dictionary of column-name and array of values)
- Explain SQL returns the execution plan, detailing the SetSPaces accessed and keys used for search (Key, Index, Scan)
- The Parquet method returns a Parquet file that can be used with any Apache Parquet library, or added to DuckDB OLAP store
Data Dictionary
SCHEMA_TABLE
| Column Name | Data Type | Description |
|---|---|---|
| TABLE_NAME | string | The name of the table |
| TABLE_TYPE | string | The type of the table in SCHEMA_PROPERTY |
SCHEMA_COLUMN
| Column Name | Data Type | Description |
|---|---|---|
| TABLE_NAME | string | The name of the table |
| COLUMN_NAME | string | The name of the column |
| COLUMN_TYPE | string | The type of the table in SCHEMA_PROPERTY |
SCHEMA_PROPERTY
| Column Name | Data Type | Description |
|---|---|---|
| TYPE_NAME | string | The Type Name |
| PROPERTY_NAME | string | The name of each property |
| PROPERTY_TYPE | string | reference to SCHEMA_PROPERTY.TYPE_NAME |
Examples
Simple query
SELECT p.Name, p.Gender FROM Persons as p WHERE p.Name = 'Lucy'
Query parameters
SELECT p.Name, p.Gender FROM Persons as p WHERE p.Name = :name
Query batches
SELECT p.Name, p.Gender FROM Persons as p WHERE p.Name = :name;
SELECT Name as name, Father as father from Persons ;
Joins
SELECT p.Name, f.Name as Father, f.Father as GrandFather
FROM Persons as p
join Persons as f on p.Father.Name = f.Name
WHERE p.Name = :name
Aggregates
select p.Father.Name, count(p.Name) as Children
from Persons as p
group by p.Father.Name as f
having count(*) > 1;
Like expressions
select p.Father.Name, count(p.Name) as Children
from Persons as p
where Name like 'L%' and Name like '%y' or (Name like '%u%' and Name like '_uc_')
group by p.Father.Name as f
having count(*) > 1;
Null handling
select p.Name, p.Father.Name
from Persons as p
where Name is not null
in query
SELECT p.Name, p.Gender
FROM Persons as p
WHERE p.Gender in (select p2.Gender from Persons as p2 where p2.Name = 'Lucy')
union
SELECT p.Name, p.Gender
FROM Persons as p
WHERE p.Name in ('Lucy', 'Mark')
union
SELECT p.Name, p.Gender
FROM Persons as p
WHERE p.Name in ('Eve', 'Mary')
inline view
SELECT p.Name, p.Gender
FROM Persons as p
join (select p2.Gender from Persons as p2 where p2.Name = 'Lucy') as p3 on p.Gender = p3.Gender
dictionary query
select * from SCHEMA_TABLES;
select * from SCHEMA_COLUMNS;
select * from SCHEMA_PROPERTIES;
API
The Hiperspace.SQL API can be called from any language that supports DOTNET interop, including Python (using pythonnet). Access via the Hiperspace.SQL.Engine object that is constructed with a reference to any domain space.
Explain
Provides a detailed breakdown of the query execution plan
member engine.Explain (source, parameters : IDictionary<string,obj>) : string array =
Execute
Executes the SQL queries and returns an array of Data Frames
member engine.Execute (source , parameters : IDictionary<string,obj>) : IDictionary<string, obj array> array =
Parquet
Executes the SQL queries will a n array of filenames (one for each statement) and returns the filenames after writing the results to the Apache Parquet files.
member this.Parquet (source, fileNames, parameters : IDictionary<string,obj>): string array =
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
-
net8.0
- FSharp.Core (>= 9.0.303)
- FsLexYacc (>= 11.3.0)
- FsLexYacc.Runtime (>= 11.3.0)
- HiLang (>= 2.5.0)
- Hiperspace (>= 2.5.0)
- Microsoft.Bcl.HashCode (>= 6.0.0)
- Microsoft.CodeAnalysis (>= 4.14.0)
- Microsoft.CodeAnalysis.Analyzers (>= 4.14.0)
- Microsoft.CodeAnalysis.CSharp (>= 4.14.0)
- Parquet.Net (>= 5.2.0)
- protobuf-net.Core (>= 3.2.56)
- System.CodeDom (>= 9.0.10)
- System.Text.Json (>= 9.0.10)
-
net9.0
- FSharp.Core (>= 9.0.303)
- FsLexYacc (>= 11.3.0)
- FsLexYacc.Runtime (>= 11.3.0)
- HiLang (>= 2.5.0)
- Hiperspace (>= 2.5.0)
- Microsoft.Bcl.HashCode (>= 6.0.0)
- Microsoft.CodeAnalysis (>= 4.14.0)
- Microsoft.CodeAnalysis.Analyzers (>= 4.14.0)
- Microsoft.CodeAnalysis.CSharp (>= 4.14.0)
- Parquet.Net (>= 5.2.0)
- protobuf-net.Core (>= 3.2.56)
- System.CodeDom (>= 9.0.10)
- System.Text.Json (>= 9.0.10)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated |
|---|---|---|
| 2.5.21 | 373 | 12/10/2025 |
| 2.5.18 | 650 | 12/3/2025 |
| 2.5.8 | 155 | 11/15/2025 |
| 2.5.2 | 181 | 11/6/2025 |
| 2.5.0 | 171 | 10/20/2025 |
| 2.4.6 | 179 | 9/23/2025 |
| 2.4.4 | 255 | 8/7/2025 |
| 2.4.2 | 144 | 7/28/2025 |
| 2.4.0 | 175 | 7/10/2025 |
| 2.3.8 | 165 | 7/1/2025 |
| 2.3.4 | 166 | 6/5/2025 |
| 2.2.2 | 183 | 5/5/2025 |
| 2.2.1 | 235 | 4/14/2025 |
| 2.2.0 | 118 | 3/29/2025 |
| 2.1.9 | 252 | 3/5/2025 |
| 2.1.6 | 149 | 2/15/2025 |
| 2.0.0 | 121 | 1/14/2025 |
| 1.0.5 | 141 | 11/15/2024 |
| 1.0.2 | 143 | 11/1/2024 |
| 1.0.1 | 181 | 10/18/2024 |
https://www.cepheis.com/hiperspace/20251020
## Overview
This release introduced the **message** element for client/server scenarios where you might want to run a query on a server and transfer only the final results to a client. This is especially useful for whole graph queries that select every element that is related to the subject ***node*** for a *butterfly* view.
-----
## Message
The [HiLang Message](https://www.cepheis.com/hiperspace/message) page goes into detail about the structure of *messages*.. but it is worth referring to an example for clarity. The `CustomerCube` *message* takes a reference to a *Customer* and returns all the information need to display a *hipercube* in a [Web Assembly](https://webassembly.org/) browser client, transfered with [Protobuf](https://protobuf.dev/) compression between client and server
```
message API.CustomerCube
(
Customer : Acc.Customer #1
)
{
CustomerTree : List<Acc.Customer> #2,
Sector : List<Acc.Sector> #3,
Accounts : List<Acc.Account> #4 ,
"Using the generated cube element from Transaction and its dimensions"
Cube : List<Acc.Transaction_Cube> #5,
"Using the generated cube drilldown from cube"
Drilldown : List<Acc.Transaction_CubeDrillDown> #6
};
```
**NB** `Cube : List<Acc.Transaction_Cube>` is a *physical* element, generated from the `Transaction` *@Fact* property, and including the *@Dimension* {*Customer, Account, Sector*} and *@Measure* analysis properties
When the schema is compiled with [HiLang](HiLang), implementations are not provided for
```
namespace API
{
public partial class CustomerCube : IMessage
{
public Task<IMessage> InvokeAsync(CancellationToken token = default)
{
}
public async IAsyncEnumerable<IMessage> InvokeStreamAsync([EnumeratorCancellation]CancellationToken token = default)
{
yield return await InvokeAsync(token);
}
}
}
```
which must be added to the schema project to provide implementation for the server-side functions
-----
### HiperSpace
`HiperSpace` has two additional methods that transfer messages through the layers of Hiperspaces, until a server `SubSpace` is found that will execute the message, and return the value
```
public virtual Task<byte[]> InvokeAsync(byte[] key, CancellationToken token = default) => Task.FromResult(key);
public virtual IAsyncEnumerable<byte[]> InvokeStreamAsync(byte[] key, CancellationToken token = default) => new byte[][] { key }.ToAsyncEnumerable();
```
### SubSpace
`SubSpace` has the above functions (*because they also implement* `HiperSpace`), plus the domain specific functions needed for code like `var msg = await space.InvokeAsync(new CustomerCube {Customer = myCust}); to be executed on a client.
```
public async Task<TMessage> InvokeAsync<TMessage>(TMessage item, CancellationToken token = default)
where TMessage : class, IMessage
public async IAsyncEnumerable<TMessage> InvokeStreamAsync<TMessage>(TMessage item, [EnumeratorCancellation]CancellationToken token = default)
```
There are no equivalent synchronous messages handling functions because the only reason for using messages is to perform query processing on a server, and Blazor client cannot use any blocking operations.
With this release the *obsolete* function `public abstract object? Get(string sid);` has been removed, and `Get<object?>(string sid)` should be used instead.
-----
#### Domain implementation
The Domain implementation of `SubSpace` (*generated by HiLang*) includes logic to execute the message logic in the first *domain Space* that has the `RemoteLabel` set to true. Generated HiLang schema will not compile until the `InvokeAsync` and `InvokeStreamAsync` functions have been added by the implementor.
-----
### HiLang
HiLang `segment` (*many*) and `aspect` (*optionally one*) can be applied to any `entity` to extend the definition of the entity with information that is versioned separately. Consider the example of [TOGAF](https://github.com/channell/Hiperspace/blob/master/examples/TOGAF/TOGAF.hilang) where every entity type can include any number of ***Gaps*** each of which have separate storage and references to their `owner` with navigation from the `owner` using the ***Gap*** property.
[HiLang](HiLang) Generates {*ServiceGap, DriverGap, ActorGap, FunctionGap, CapabilityGap, ProductGap, GoalGap, ObjectiveGap, MeasureGap, ActivityGap, EventGap, ProcessGap, ControlGap, ValueStreamGap, CourseOfActionGap, EntityGap, LogicalGap, PhysicalGap, SystemGap, ComponentGap, DeployedGap, PlatformGap, HostGap, InstanceGap*} to provide storage for entity specific versions of the ***Gap***, and *View* to bring togther every different implementation for query together.
When *segment*/*aspect* is only used in a single comtext, we can end-up with very long segment implementation names like `CustomerAccountTransaction` when `Customer` has many `Account` *segments* , which has many `Transaction` segments. To minimise the generated classes, an additional *step* has been added to HiLang to remove the generated prefix when a segment is only used in one context.
This version changes `CustomerAccountTransaction` to `Transaction`. If we subsequently need to add the segment to another *entity*, the prefix would be added back to distinguish different owners of `Transaction`.
**NB** Hiperspace does not store the name of the *element* with every instance (only the #id is stored), so any change will be transparent.
-----
### LatestSpace
`LatestSpace` is a specialisation fo HeapSpace, that discards history to reduce memory usage. the main use-case is with Blazor Web-Assembly clients that have no interest in the history of an Element, but need to hold the durable representation for synchronization at the end of a session.
## References
References to other libraries have been updated