ProjectNine.Services.FictionalUniverseDatabase

ProjectNine.Services.FictionalUniverseDatabase.FictionalUniverseServices

Some user-facing utilities

ProjectNine.Services.FictionalUniverseDatabase.FictionalUniverseServices.DefaultFictionalUniverseDatabaseConnectionString

A read-only clone of official database.

ProjectNine.Services.FictionalUniverseDatabase.FictionalUniverseServices.FictionalUniverseDatabase

Expose a FictionalUniverseConnection for default P9 configuration for read-only db to be used to Postgre Database.

Returns

ProjectNine.Services.FictionalUniverseDatabase.Utilities.PopulateSamplePopulation

A self‑contained console-enabled program that: 1. Connects to a remote PostgreSQL server using the supplied connection string 2. Creates a "population" table (dropping any existing one) 3. Populates it with N rows via PostgreSQL's binary COPY for maximum throughput 4. Runs two example queries (COUNT and keyed lookup) 5. Measures and prints the elapsed time for every stage Adjust ROW_COUNT and the connection string to taste. When ROW_COUNT = 300_000_000 the process will take tens of minutes to \u2013 hours depending on network bandwidth and server I/O throughput. Fills a new PostgreSQL databas. Depends on Npgsql and Divooka.Database.PostgreSQL.

ProjectNine.Services.FictionalUniverseDatabase.Utilities.PopulateSamplePopulation.Run()

Parameters

NameDescriptionDefault
configuration
rowCount Change to 300_000_000 for the full load representing NFC
progressEvery console progress interval

ProjectNine.FictionalWorld.DataSet

A hybrid real-procedural dataset

ProjectNine.FictionalWorld.DataSet.GetPopulationData

Get actual data from Project Nine world.

Returns

ProjectNine.FictionalWorld.DataSet.SamplePopulationData

Generate a fake, sample population data.

Returns

A divooka data grid.