Thoughts and ideas on how to build tools, automate workflows and speed-up the workplace.
There are countless situations where you might need to integrate multiple databases. This might be necessary for a particular app project. Providing more centralized and efficient access to information could also be a goal in itself. However, accomplishing this can be a challenge, especially for inexperienced developers. Today we’re going to look at two methods key methods for integrating databases, as well as how Budibase can make life easier along the way.
Ronan McQuillan
May 22, 2022
Your app’s database schema is absolutely central to its functionality, performance, and success. In fact, this determines just about every aspect of how your finished app will work. As such, knowing how to create an effective schema is critical when building any kind of tool. In this guide, we’ll cover everything you need to know. We’ll start with the basics, including what a schema contains, before moving on to more specific details you need to know when working with different kinds of databases.
Ronan McQuillan
May 22, 2022
In this example, we will build a small CRUD app that allows users to view sales records and create new ones. We will use the power of the Budibase backend and its public API to connect to a Postgres database, display sales records, and create a form to create a new sales record. Rather than defining your database connection, table queries, security, REST API in Next.js, we can instead utilize Budibase to simplify our backend.
Michael Drury
Mar 10, 2022