SCALE 19x venue
SCALE 19x logo
Los Angeles, CA
July 2022

OpenSource SQL Business Schemas

Audience:
Topic:

Stop using the Microsoft Northwind Database Schema.
Rolling your own is always a compromise.

Quick-start your project with a fully baked FOSS Business Database Schema.

79 TABLEs
40 VIEWs
102 PostgreSQL FUNCTIONs

Come see a brief walk-through of just some of the included features.

There are 26 Normalized TABLEs for Web Sessions alone.

Not to worry, pre-written functions allow for single short SQL statements to handle all the business logic and INSERTs!

* People and Entity management
GetIndividualEntity('Company Supplier');

* Double Entry Accounting
SELECT Book('Sale Jane Doe', 1000) FROM DUAL; -- Jane Doe makes a commission sale

* Inventory Movement
GetPart('Bunny');

* Email Subscribe Lists
SELECT ListUnSubscribe('Job', 'Clown', GetIndividualEmail('Zippy@ADb.Net')) FROM DUAL;

* Time Periods
SELECT open FROM TimePeriod WHERE period = 1; -- open is true if it is Christmas Day
SELECT open FROM TimePeriod WHERE period = 2; -- open is true if it is Thanksgiving

* and so much more
https://github.com/jazd/Business/wiki/Examples
https://github.com/jazd/Business

Room:
Los Angeles B
Time:
Thursday, July 28, 2022 - 13:30 to 14:30