DreamStudio - DemocracyLab 2.0 MemberCommons

We've applied a standards based data schema so numerous developers can easily integrate their contributions. Bolt AI with a Rust REST API and Azure PostgreSQL for the fastest and most reliable sites.

Comment

Inspiration

We needed a team project structure that would work equally well for Economic Developers who use Salesforce and community collaborators developing AI enhanced site updates to help reduce government expenses. We combined the Common Data Model (CDM) used by Microsoft Dynamics and popular CRM architecture like SuiteCRM which uses a Saleforce SQL schema.

What it does

Provides easeful integration of AI coded apps for skill training and Innovation Bond development funding.

How we built it

We leverage the Bolt AI prompt page to generate a JAM Stack site around our database structure. We provide the names of core tables (like users, accounts, opportunities) and a link to the full database schema which matches Salesforce.

Challenges we ran into

We initially created a single page app then converted it into multiple core pages with a shared navigation process. Transitioning and perfecting the navigation took the most time, but Bolt AI provided a handy way to collaborate on the development as we plugged in our backend setup with Rust SQLx and created pages that look great without needing to run complicated install processes.

Accomplishments that we're proud of

The MemberCommons database schema matches Salesforce and Microsoft Dynamics for robust team collaboration.

What we learned

We iterate three times to perfect the prompt used to launch our initial site design. You'll save time by detailing your requests beforehand rather than trying to change the course of a ship once its generated.

What's next for DreamStudio

We'll be managing our team projects area using the AI processes integrated into the new system created with Bolt AI as we strive to create zero cost services for government.

Share this project:

Updates