Draft accessible only to Ed-Fi Alliance staff.
This page describes "alpha" quality code and processes. It is intended to provide an early look into the Project Roadrunner: PostgreSQL Support for the Ed-Fi ODS / API development process and elicit feedback. As such, full release functionality could end up differing substantially from the code described herein.
What's Available
EdFi.Db.Deploy
This is a new database deployment tool, which will support deploying the EdFi ODS/API databases to either SQL Server or PostgreSQL. Source code is available in the new Ed-Fi-Databases repository; check-out the 1.0.0-alpha1 tag for this initial preview release. Build and usage instructions are provided in the project readme file.
PostgreSQL testing has been performed on the latest 10.x and 11.x binaries, in local Docker containers and on a stand-alone integration server.
Please note that the API cannot connect to the PostgreSQL instances yet - we have much work to do to make this possible. Thus this initial preview is quite limited in scope:
- Covers the SQL scripts from the Ed-Fi-ODS repository.
- Proves out the new deployment process, which will eventually be incorporated into the ODS/API's PowerShell scripts.
- Works out provisions for shortening some database object names, which were longer than the PostgreSQL max-length of 63 characters.
Next Up
The ODS Platform core development team will work to add scripts from the Ed-Fi-ODS-Implementation repository.