Thoughts and ideas on how to build tools, automate workflows and speed-up the workplace.
We love to hate spreadsheets. They’re everywhere. We use Excel for everything from planning our vacations and weddings, to managing inventories, payroll, and just about any other business process under the sun.
But, like any blunt instrument, spreadsheets are almost the most elegant solution. Today, we’re going to look at a better way to manage data, calculations, and workflows. That is, how to make an app from Excel spreadsheets.
You see, spreadsheets offer a huge amount of flexibility - there’s a reason why they’re so ubiquitous.
Aug 21, 2022
When building a web app, your choice of data source is critical. Deciding how and where to store, access, and manipulate data is fundamental to every successful app project. Today, we’ll be looking at everything you need to know to get this decision right.
We’ll start with the basics, including what a data source is, the different ways web apps access data, and how this fits into your wider app architecture.
May 22, 2022
Knowing how to create a data model is the first step toward building a successful app. This is the foundation of how you’ll transform your business requirements into reality.
In fact, all other elements of your app build on your data model.
However, coming up with an effective data model presents a few key challenges. This is a complex process, involving end-users, technical teams, and other business stakeholders.
Today, we’re going to look at exactly how you can create a successful data model.
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.
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.
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.
Mar 10, 2022