Think fast

Create a Form to Enter Google Sheets Data in 7 Steps

Obviously, Google Sheets is great for collaboratively managing all sorts of data. There are big downsides here too though, especially if you’re working at scale. One solution is using a form to enter data into Google Sheets. Today, we’re going to look at exactly how you can do this in Budibase. There are a bunch of other ways you could do this too, of course. We’re biased, but we think Budibase is the best option.

Ronan McQuillan

Jan 1, 2024

How to Integrate Multiple Databases

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

Dec 22, 2023

How to make an App from Excel Spreadsheets

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.

Ronan McQuillan

Dec 21, 2023

The Future of Databases | 8 Data Management Trends

Databases are not new. Having ways to be able to store data, query it, and serve it back to our users has been a key focus of web application development for decades. But, that doesn’t mean things have stood still. Today, we’re checking out the future of databases - with 8 data management trends and 11 real-world examples. Relational databases that were developed in the 70s still provide the backbone of most modern IT.

Ronan McQuillan

Oct 17, 2023

What is a Serverless Database? + 8 Picks for 2025

The rise of serverless databases has been one of the major shifts in how we build software over the past few years. In fact, they’re increasingly becoming a core part of all sorts of application projects. See, when we build any kind of solution, a big portion of the cost is the infrastructure we use to store and host relevant data. This also has an outsized impact on the quality and success of whatever we’re building.

Ronan McQuillan

Oct 13, 2023

10 Strategies for Simplified Data Management

Businesses today deal with larger, more complex data sets than at any point in history. Obviously, this brings huge benefits. At the same time, it introduces swathes of new challenges. These include inefficiencies, unnecessary risks, poor oversight, and a whole host of other problems. One approach to solving this problem is simplifying data management. See, the problem isn’t so much the data itself, it’s how we build processes and operations around it.

Ronan McQuillan

Sep 29, 2023

What is a Transactional Database?

Transactional databases are some of the most foundational and ubiquitous tools around. In fact, for countless IT teams, this is the default model for data storage. But, in recent years, the size, scale, and complexity of businesses’ data assets have exploded. In turn, it’s become more important than ever to choose the right data management tools for specific applications and use cases. This means that we need to have a realistic, clear grasp of the respective pros, cons, and core tenets of different models - including transactional systems.

Ronan McQuillan

Sep 29, 2023

What is a Wide-Column Database?

Wide-column databases are one of the most important types of NoSQL data storage solutions. Countless businesses use them every day, especially in analytics and big data workflows. But, if you go searching for a clear, concise definition, there’s a good chance you’re going to be left disappointed. Unless you like technical marketing jargon. Today, we’re filling that gap. Specifically, we’re diving deep into everything you need to know about wide-column databases - including what they are, how they work, what they’re used for, and how they fit into the bigger picture of the data management landscape.

Ronan McQuillan

Sep 19, 2023