How to manage HTML and uploads in PostgreSQL with Flashboard

You created your app with PostgreSQL and love having all your data in it.

Now you need to manage HTML content, images, and file uploads for your app's data, like products, events, profiles, etc. Your marketing team also needs to manage blog posts, landing pages, documentation, FAQs, and case studies.

SQL editors work nicely for developers. But they fall short when you need to edit HTML or store references for uploads in your storage service.

A popular alternative is to integrate with a headless CMS. But then you must design the CMS schema separately from your app's database. You need to integrate with an SDK, learn a DSL, merge data from two sources, and keep them in sync.

And let's be honest: the last thing you want is to add another data source and kill the joy of using PostgreSQL for everything ☺️

An instant CMS for PostgreSQL

Flashboard is an instant CMS for your database. It connects to your database and immediately creates a complete admin panel, with a Notion-like HTML editor, uploads, and more.

Connect your database to Flashboard

All you need is your connection string to create your CMS in 2 minutes. Follow Flashboard's docs for instructions.

Editing HTML

In your CMS, you can edit any field by clicking it and making the changes you need, as long as the field is configured to be editable:

Some fields have an Expand icon:

Whenever you expand a field, you’ll open a screen to edit it as Plain text, Code, HTML, or Upload.

Expand any text field, and see the tabs below. Click the HTML tab and start writing:

In a new line, type / to open a menu with content options. Type to search for the command you're looking for:

You can also do pretty much anything you’re used to doing on a rich text editor, for example:

• Select text to format it

• Paste a URL with text selected to turn it into a link

• Upload images

• Paste content from other sources and preserve formatting

The HTML content will be stored in your database field with no styles, only markup. You can check the markup by alternating between the Code and HTML tabs.

Uploads

Flashboard lets you connect your S3-compatible storage service and upload images and files to your CMS.

There are two types of uploads:

1. Images inside HTML content

When writing HTML, you can upload images as part of the content. When you do that, an img tag is stored inside your HTML content, with the src pointing to that image's public URL inside your storage.

2. Uploads to fields in your database

You can upload images and files to any text or JSON field in your database. Flashboard stores references to multiple file uploads inside these columns in JSON format and includes everything you need to generate secure URLs for the files and render them.

Conclusion

You can now have your PostgreSQL as your single source of truth, even for marketing content, in seconds. By leveraging your database and Flashboard, you don't have to choose between a great CMS experience and the joy of using PostgreSQL's full potential.