PostgreSQL database provider for Semantico. Provides Entity Framework Core configuration and migrations for PostgreSQL databases with snake_case naming conventions.
$ dotnet add package Semantico.Core.PostgreSqlPostgreSQL database provider for Semantico.
This package provides Entity Framework Core configuration and migrations for using PostgreSQL as the Semantico metadata database. It includes snake_case naming conventions and full support for PostgreSQL-specific features.
dotnet add package Semantico.Core.PostgreSql
dotnet add package Semantico.UI.AspNet
using Semantico.Core;
using Semantico.UI.AspNet;
// Single method call for all Semantico configuration
builder.Services.AddSemantico(builder.Configuration, options =>
{
options.UsePostgreSql(builder.Configuration.GetConnectionString("SemanticoContext")!, "semantico");
options.AddSemanticoScheduler<YourScheduler>();
options.BaseUrl = "https://your-domain.com/semantico";
});
var app = builder.Build();
app.UseStaticFiles(); // Required for Semantico UI assets
app.UseSemanticoUI()
.UseBasicAuthentication("admin", "admin")
.AddBlazorUI("/semantico");
In appsettings.json:
{
"ConnectionStrings": {
"SemanticoContext": "Host=localhost;Database=semantico;Username=postgres;Password=yourpassword"
}
}
CREATE DATABASE semantico;
CREATE SCHEMA semantico;
GRANT ALL ON SCHEMA semantico TO postgres;
MIT License - see LICENSE