ManagedModels / CoreData version of Microsoft's Northwind Database, filled from NorthwindSQLite.swift, which is a packaged version of Northwind-SQLite3.
ManagedModels is a Swift package that provides a SwiftData like API on top of plain CoreData.
From Northwind-SQLite3:
The Northwind sample database was provided with Microsoft Access as a tutorial schema for managing small business customers, orders, inventory, purchasing, suppliers, shipping, and employees. Northwind is an excellent tutorial schema for a small-business ERP, with customers, orders, inventory, purchasing, suppliers, shipping, employees, and single-entry accounting.
It can be useful to play with ManagedModels / CoreData, as it provides a pre-filled database and a set of models. The database is a little old, but still useful to get started w/ an actual dataset.
- Create a SwiftUI app in Xcode
- Add NorthwindManagedModels as a dependency, the url is:
https://github.com/Northwind-swift/NorthwindManagedModels - Setup the model container for the UI:
@main
struct NorthwindApp: App {
var body: some Scene {
WindowGroup {
ContentView()
}
.modelContainer(try! NorthwindStore.modelContainer())
}
}That's it. It will copy the included database to the application support directory of the application and setup everything else.
The other option is to use .readOnlyModelContainer() which will return a
container that directly accesses the embedded database.
Can be useful for tests and the like.
The model structure as provided by Northwind-SQLite3.
erDiagram
CustomerCustomerDemo }o--|| CustomerDemographics : have
CustomerCustomerDemo }o--|| Customers : through
Employees ||--|| Employees : "reports to"
Employees ||--o{ EmployeeTerritories : through
Orders }o--|| Shippers : "ships via"
"Order Details" }o--|| Orders : have
"Order Details" }o--|| Products : contain
Products }o--|| Categories : in
Products }o--|| Suppliers : "supplied by"
Territories ||--|| Regions : in
EmployeeTerritories }o--|| Territories : have
Orders }o--|| Customers : place
Orders }o--|| Employees : "sold by"
Categories {
int CategoryID PK
string CategoryName
string Description
blob Picture
}
CustomerCustomerDemo {
string CustomerID PK, FK
string CustomerTypeID PK, FK
}
CustomerDemographics {
string CustomerTypeID PK
string CustomerDesc
}
Customers {
string CustomerID PK
string CompanyName
string ContactName
string ContactTitle
string Address
string City
string Region
string PostalCode
string Country
string Phone
string Fax
}
Employees {
int EmployeeID PK
string LastName
string FirstName
string Title
string TitleOfCourtesy
date BirthDate
date HireDate
string Address
string City
string Region
string PostalCode
string Country
string HomePhone
string Extension
blob Photo
string Notes
int ReportsTo FK
string PhotoPath
}
EmployeeTerritories {
int EmployeeID PK, FK
int TerritoryID PK, FK
}
"Order Details" {
int OrderID PK, FK
int ProductID PK, FK
float UnitPrice
int Quantity
real Discount
}
Orders {
int OrderID PK
string CustomerID FK
int EmployeeID FK
datetime OrderDate
datetime RequiredDate
datetime ShippedDate
int ShipVia FK
numeric Freight
string ShipName
string ShipAddress
string ShipCity
string ShipRegion
string ShipPostalCode
string ShipCountry
}
Products {
int ProductID PK
string ProductName
int SupplierID FK
int CategoryID FK
int QuantityPerUnit
float UnitPrice
int UnitsInStock
int UnitsOnOrder
int ReorderLevel
string Discontinued
}
Regions {
int RegionID PK
string RegionDescription
}
Shippers {
int ShipperID PK
string CompanyName
string Phone
}
Suppliers {
int SupplierID PK
string CompanyName
string ContactName
string ContactTitle
string Address
string City
string Region
string PostalCode
string Country
string Phone
string Fax
string HomePage
}
Territories {
string TerritoryID PK
string TerritoryDescription
int RegionID FK
}
The package includes a filled Northwind database created from the data provided in Northwind-SQLite3. It is imported using NorthwindSQLite.swift by a separate Importer Tool.
Note: The import takes hours to run ⏳
The SQLite version of Northwind has a few bugs, mostly related to optionality (i.e. a lot of columns are marked as NULLable which likely shouldn't be). The goal is to fix those in the SwiftData model & import, PRs are welcome. Though it shouldn't be overly non-null, even if fields are never set to NULL in the DB (e.g. address fields).
Northwind for SwiftData is brought to you by Helge Heß / ZeeZide. We like feedback, GitHub stars, cool contract work, presumably any form of praise you can think of.
Want to support my work? Buy an app: Code for SQLite3, Past for iChat, SVG Shaper, Shrugs, HMScriptEditor. You don't have to use it! 😀