Bubble Docs
  • Introduction
  • New? Start Here
  • What is Bubble?
  • The Glossary
  • User manual
    • Getting started
      • What is Bubble?
      • Building your first app
        • Planning features
        • Database structure
        • Design and UX
        • eCommerce and payments
          • Shopping cart
          • Checkout page
          • One-time payments
          • Subscriptions
          • Marketplace
      • Creating and managing apps
      • The Bubble editor
        • Tabs and sections
          • Design tab
            • The element tree
            • The property editor
          • Workflow tab
          • Data tab
          • Styles tab
          • Plugins tab
          • Settings tab
            • Application settings
              • Custom headers/body
              • Visual settings
              • Social media sharing
              • Translating your app
              • Email settings
              • Collaboration
            • Custom domain and DNS
          • Logs tab
        • Tools
          • Key features
          • The search tool
          • The Issue Checker
          • The element tree
          • The element property editor
          • The debugger
          • Notes
        • Previewing your app
      • Transitioning to Bubble from...
        • JavaScript
        • HTML and CSS
        • SQL
    • Design
      • Elements
        • The element hierarchy
          • The element tree
        • The page
        • Containers
          • Groups
          • Repeating groups
          • Table elements
          • Popups
          • Floating groups
          • Group focus
        • Visual elements
        • Input forms
          • Text and numbers
          • Dates and time
          • File uploads
          • Selection controls
        • Reusable Elements
      • Styling
        • Color variables
        • Font variables
        • Styles
        • Custom Fonts
      • Responsive design
        • Building responsive pages
        • Legacy articles
          • The Basics (Legacy)
          • Building Responsive Pages (Legacy)
          • Migrating Legacy Pages
          • Tips When Designing (Legacy)
      • Templates
      • The Component Library
      • Importing from Figma
    • Data
      • The database
        • Data types and fields
        • Creating, saving and deleting data
        • Finding data
        • Displaying data
        • Protecting data with privacy rules
        • The database editor
        • Export/import data
          • Exporting data
          • Importing data (CSV)
        • Working with location data
        • Using Algolia
        • Database structure by app type
          • Marketplace Apps
          • Directory & Listings Apps
          • Social Network Apps
          • SaaS Apps
          • Project Management Apps
          • CRM Apps
          • Professional Services Apps
          • On-demand Apps
          • Documentation/ CMS Apps
          • Applicant Tracking System (ATS) Apps
          • Portfolio Apps
          • Gallery Apps
          • Online Store / Ecommerce Apps
          • Blog Apps
          • Messaging App
          • Dashboards
          • Building Block Apps
          • Bubble as a backend
      • Files
      • Images
      • Static data
        • App texts (translations)
        • Option sets
      • Temporary data
        • Custom states
        • URL parameters
      • User accounts
        • Authentication plugins
          • Facebook plugin
          • Fitbit plugin
          • Google plugin
          • Instagram plugin
          • LinkedIn plugin
          • Pinterest plugin
          • Slack plugin
          • Wistia plugin
          • YouTube plugin
        • Cookies set by Bubble
      • Time, dates and time zones
    • Logic
      • The frontend and backend
      • Workflows
        • Events
          • Frontend events
            • Recurring workflows
            • Custom events
          • Backend events
            • Database trigger events
        • Actions
        • API Workflows
      • Dynamic expressions
      • Conditions
      • Navigation
        • Single-page applications (SPA)
        • Multi-page applications
        • Page slugs
    • Workload
      • Understanding workload
        • Activity types
        • The workload calculation
        • Client-side and server-side processing
      • Tracking workload
        • Measuring
          • Using App Metrics
        • Monitoring
          • Workload notifications
          • Infinite recursion protection
      • Optimizing workload
        • Optimization framework
        • Optimization checklist
          • Page load
          • Searches
          • Workflows and actions
          • Backend workflows
        • Agency showcases
          • Minimum Studio
          • Neam
          • Support Dept
    • Security
      • Bubble's security features
      • Planning app security
      • Client-side and server-side
      • Bubble account security
      • App security
      • Page security
      • Database security
      • API security
        • API Connector security
        • Data API security
        • Workflow API security
      • Flusk
        • Overview
        • Flusk plan features
        • Getting started with Flusk
        • Flusk security tools
          • The Issues Explorer
          • Issue details
          • Tools and settings
            • Pages rating
            • Database rating
        • Flusk FAQ
      • Cookies
      • Security checklist
    • Publishing your app
      • Web app
      • Native mobile app
        • Global native mobile settings
        • iOS App Store
        • Google Play Store
        • Publishing FAQ
    • AI
      • Generate apps with AI
        • About AI app generation
      • AI page designer
      • Connect to AI agents
    • Maintenance
      • Collaborators
      • Version control
        • Best practices: Version control
        • Transitioning from the legacy version control
        • Terminology: Version control
        • Version Control (legacy)
      • Commenting
      • Database maintenance
        • Copying the database
        • Restoring database backups
        • Bulk operations
          • Bulk operation methods compared
        • Wiping change history
      • Performance
        • Hard limits
        • Capacity Usage (legacy)
        • Notes on queries
      • SEO
        • Introduction to SEO
        • SEO: App
        • SEO: Page
      • Testing and debugging
        • Introduction to testing and debugging
        • The debugger
        • The server logs
        • Supported browsers
      • API workflow scheduler
    • Integrations
      • API
        • Introduction to APIs
          • What is a RESTful API?
        • The Bubble API
          • Bubble API terminology
          • Authentication
            • How to authenticate
            • No authentication
            • As a User
            • As an admin
          • The Data API
            • Data API Privacy Rules
            • Data API endpoints
            • Data API requests
          • The Workflow API
            • Workflow API privacy rules
            • Workflow API endpoints
            • API workflows
              • Creating API workflows
              • Scheduling API workflows
              • Recursive API workflows
              • API Workflow Scheduler
              • Case: Stripe notifications
        • The API Connector
          • Authentication
          • API Connector security
          • API guides
            • OpenAI
              • Authentication
              • Calls
                • ChatGPT
                  • Chat
            • Google Translate
              • How to setup Google API keys
          • Streaming API
        • API security
        • Plugins that connect to APIs
        • API Glossary
      • Plugins
        • What Plugins Can Do
        • Installing and using Plugins
        • Authentication plugins
        • Special Plugins
      • SQL Database Connector
      • Bubble App Connector
      • WorkOS
        • WorkOS SSO
        • WorkOS API
    • Infrastructure
      • Sub-apps
      • Bubble release tiers
      • Hosting and scaling
        • How Bubble hosting works
        • Scaling with Bubble
        • CDN (Cloudflare)
        • Bubble app names
        • Domain and DNS
      • Compliance
        • GDPR
        • SOC 2 Type II
        • HIPAA
        • Other frameworks and standards
    • Bubble for Enterprise
      • Hosting and infrastructure
        • Dedicated instance
          • The Dedicated editor experience
          • Technical specs
          • Main cluster dependencies
          • Customizable options
          • Migration process
            • Pre-migration
            • During migration
            • Post-migration
      • Security and compliance
        • Single sign-on (SSO)
        • GDPR
        • SOC 2 Type II
        • HIPAA
        • Other frameworks
        • Bubble's security features
      • Admin and collaboration
      • Priority support
      • Billing and Payment Guideline for Dedicated Instances
  • Core Reference
    • Using the core reference
    • Bubble's Interface
      • Design tab
      • Design tab (Legacy)
      • Workflow tab
      • Data tab
      • Styles tab
      • Styles tab (Legacy)
      • Plugins tab
      • Settings tab
      • Logs tab
      • Template tab
      • Toolbar
      • Top and context menu options
      • Deployment and version control
        • Deployment & Version Control Dropdown (legacy)
      • Notes
    • Elements
      • General properties
      • General properties (Legacy)
      • Styling properties
      • Styling Properties (Legacy)
      • Responsive Properties
      • Responsive Properties (Legacy)
      • Conditional formatting
      • States
      • Page Element
        • Page Element (Legacy)
      • Visual Elements
      • Containers
      • Container Layout Types
      • Containers (Legacy)
      • Input Forms
      • Reusable Elements
      • Element Templates (legacy)
    • Workflows
    • Events
      • General events
      • Element events
      • Custom events
      • Recurring event
      • Database trigger event
    • Actions
      • Account
      • Navigation
      • Data (things)
      • Email
      • Element
      • Custom
    • Data
      • Data Sources
      • Operators and comparisons
      • Search
      • Privacy
    • Styles
    • API
      • The Bubble API
        • The Data API
          • Authentication
          • Data API endpoints
          • Data API requests
        • The Workflow API
      • The API Connector
        • Authentication
        • Adding calls
    • Bubble-made Plugins
      • AddtoAny Share Buttons
      • Airtable
      • API Connector
      • Blockspring
      • Box
      • Braintree
      • Bubble App Connector
      • Chart.js
      • Circle Music Player
      • Draggable Elements
      • Dropzone
      • Facebook
      • Fitbit
      • Full Calendar
      • Google
      • Google Analytics
      • Google Optimize
      • Google Places
      • Ionic Elements
      • iTunes
      • Slidebar Menu
      • LinkedIn
      • Localize Translation
      • Mixpanel
      • Mouse & Keyboard Interactions
      • Multiselect Dropdown
      • Progress Bar
      • Rich Text Editor
      • Rich Text Editor (Legacy)
      • Screenshotlayer
      • SelectPDF
      • Slack
      • Segment
      • Slick Slideshow
      • SQL Database Connector
      • Star Rating
      • Stripe
      • Tinder-like Element
      • Twitter
      • YouTube
      • Zapier
    • Application Settings
      • App plan
      • General
      • Domain / email
      • Languages
      • SEO / metatags
      • API
      • Collaboration
      • Sub-apps
      • Versions
  • Account & Marketplace
    • Account and billing
      • Pricing and plans
        • Plans and billing
        • Billing cycle
        • FAQ: Pricing and Workload
      • Account Management
      • Building Apps for Others
      • Selling on the Marketplace
      • Plans & Billing (legacy)
    • Official Bubble Certification
      • Hiring certified developers
    • Building Plugins
      • The Plugin Editor
      • General Settings
      • Updating to Plugin API v4
      • Adding API Connections
      • Building Elements
      • Building Actions
      • Loading Data
      • Publishing and versioning
      • Github Integration
    • Building Templates
    • Application and data ownership
    • Marketplace policies
    • Bug reports
  • Vulnerability Disclosure Policy
  • Beta features
    • About the Beta features section
    • Native mobile apps 🔒
      • Introduction
        • What is a native mobile app?
        • Native mobile vs. web development
        • Differences in native and web elements
        • Native mobile app terminology
      • Building
        • Views and navigation
        • Native mobile actions
        • Components and gestures
        • Device resources
          • Location services
          • Camera/photo library
      • Previewing
      • Publishing
Powered by GitBook
On this page
  • Data types recommended
  • User
  • Project
  • Tag
  • Like
  • Bookmark
  • Option sets recommended
  • Made with
  • Download with
  • Category
  • Example uses in your app
  • About Tinkso

Was this helpful?

  1. User manual
  2. Data
  3. The database
  4. Database structure by app type

Portfolio Apps

By Tinkso

Various members of the Bubble ecosystem contributed these use case-oriented database guides. There's always more than one way to do something in Bubble, but the advice here can help you get started if you're new to Bubble!

You’ll build an app that allows people to showcase their work and self-promote their projects. Portfolio apps consist mostly of showcasing your work but many similar apps also serve as a networking site for professionals. Most of the users use it for inspiration so almost all of the data will be publicly available.

Popular examples of portfolio apps are: Dribbble, Unsplash or Behance.

While we’ll focus on data architecture, this type of app is usually made of these elements:

  • Form to create a new project

  • Search and display a list of projects

  • Project detail page

  • Personal dashboard listing the projects you have created, liked or bookmarked

Data types recommended

A Project, which is the main data type, is created by a User. A user is able to create as many projects as she/he wants, each of them linked to that creator.

The challenge of this kind of app is to show visitors the projects that match their search, so the filter fields related to the projects are crucial. To keep consistency you might want to prohibit adding Categories, while you allow the creator of a project to create as many Tags as she/he wishes. These Tags will become new filters available to everyone, also available when creating future projects. A logged in user will be able to like a project, which will create a new Like record.

Likewise, it will be possible to build a library of projects using the Bookmark data type.

User

Built-in Bubble app data type. The user can create a Project, bookmark a Project, and like Projects.

Suggested fields on this type

  • First name - text

  • Last name - text

  • Email - text

  • Profile picture - image

  • Company name - text

  • Company logo - image

  • Location - geographical address

  • Website - text

  • Bio - text

  • Slug - text: using Bubble’s built-in feature. This helps create some clean shareable profile page links.

Privacy rules for this data type

Since the purpose of the app is to show a user’s work and allow them be contacted, all users' fields are public and without privacy rules. Note that this also means your users’ emails are public too - you may want to make it known to users that this is the case, or later tweak your app to make emails private but still allow the outreach functionality.

Project

Project is where all the information for a project is stored. You can add as many fields as you want to further filter the projects on the “search for inspirations” page.

Suggested fields on this type

  • Owner - User: is the creator of this project. We don’t use in-built Bubble’s “creator” field as you may want to transfer the project to another user - Built-in Bubble fields don't allow you to edit them.

  • Title - text

  • Images - list of images

  • Tags - list of Tags: this example assumes you want to allow your users to create and grow the number of tags and so we use a custom data type for these, as highlighted below.

  • Made with - option set: on the contrary, use option sets if you do not want to let users modify the list in order to keep the choices ordered. Option sets can be faster when loading pages.

  • Download with - option set

  • Category - option set

  • Main color - text

  • Description - text

  • Number of views - number: this field allows you to display how many times this page has been seen. Run a workflow each time the page is opened that increments this field: Current page Project’s Number of views + 1.

  • Slug - text: using Bubble’s inbuilt feature. This helps create some clean shareable profile page links.

Privacy rules for this data type

For the same reasons as for the previous data type, Project has no privacy rules.

Tag

After being created, users shouldn’t be able to delete this data as long as at least 1 project contains this record.

Suggested fields on this type

  • Name - text

Privacy rules for this data type

Public data type.

Like

This data type allows users to like projects. By creating a specific data type for it, it allows you to display the list or the count easily from either a project’s or a user’s point of view, e.g. how many users like a project or how many projects a user has liked.

Suggested fields on this type

  • Creator - User - Bubble built-in field that automatically captures the Creator of a data type. You don’t have to do anything in order to set this field when creating it. It’s fine to use the built-in field here because we aren’t planning to let users ‘transfer’ their like to another user.

  • Project - Project - The project being liked. Use this field as a constraint to count the number of likes associated with a specific project.

Privacy rules for this data type

Public data type.

Bookmark

Similar to a Like, users can have their own list of bookmarked projects.

Suggested fields on this type

  • Owner - User - Bubble built-in field that automatically captures the Creator of a data type. You don’t have to do anything in order to set this field when creating it. Use that field as a constraint when wanting to display to this user his own bookmarked projects.

  • Project - Project

Privacy rules for this data type

You can choose either to make it public so that you can display users' collections, or to make it private so that only the user who this list belongs to can see it.

(Apply the following privacy rules if you want to make it private) - This Bookmark’s Owner is Current User:

☑View all fields

☑Find this in searches

☑View attached files

Option sets recommended

All these options have only one purpose: to be able to filter the projects on the search for inspirations page. Create as many set options as you want then add a field with this set option in the PROJECT data type.

For instance, these are inspired by Dribbble’s list of options in its search capabilities.

Made with

  • Figma

  • Sketch

  • Unsplash

  • Adobe XD

Download with

  • Figma

  • Sketch

  • Unspash

  • Adobe XD

Category

  • Animation

  • Illustration

  • Branding

  • Web Design

  • Mobile

Example uses in your app

  • Show and filter projects: Do a search for Projects and add as many constraints as you need. Make sure to tick the box “Ignore empty constraints” in order to display items even when inputs are empty otherwise the list will be empty. Sort the list by descending Created date (Bubble in-built field) to show newest projects on top.

  • Display each project’s number of likes.

  • Display Current user’s bookmarked projects. If you choose to make bookmarks private with privacy rules, you don't even need to add a constraint.

About Tinkso

Last updated 3 years ago

Was this helpful?

Tinkso () is a pioneer and leader in professional no-code and low-code product development. Our unique approach allows our clients to run successful businesses, raise millions in funding and scale professionally. Our suite of tools consists of , and a range of other tools, turns makers, freelancers and businesses in professional Bubble app builders.

tinkso.com
openBuild Framework
openBuild UI Builder