Thoughts and ideas on how to build tools, automate workflows and speed-up the workplace.
Keeping track of stock is one of the most fundamental processes in any customer-facing business. Today, we’re checking out how to build a custom inventory management app for free - in just 20 minutes. Even better, since we’re going to use Budibase to build it, you’ll barely need any coding skills - and we’ll have a fully functional application before your coffee gets cold. All we need to do is connect our data, add a couple of custom queries, and start using Budibase’s built-in components to create a professional UI for managing stock levels.
Ronan McQuillan
Oct 23, 2024
Database GUI (Graphical User Interface) are tools that allow you to interact with databases even if you aren’t a programmer. In addition, they are useful for programmers, since they provide quick ways to get data. When it comes to picking the right database GUI for you, things get tricky. Although there are a lot of options out there, there are many things to take into account. From something as simple as pricing to more complex considerations, like the functionality provided.
Ronan McQuillan
Oct 22, 2024
Web forms are some of the most basic applications around. But the value we get from them really depends on what we can do with the data we gather. Most form builders are kind of limited in this regard - largely restricting us to their built-in databases. We can also go down the route of building fully custom forms. This provides greater flexibility, but it also requires a lot more from us in terms of time, effort, and expertise.
Ronan McQuillan
Oct 14, 2024
Databases are vital for every business. But as soon as you create your database, a question arises. How can you maintain the information you store? Of course, you could write out queries manually, but you’ll also want a way for less technical staff to enter data. This means building forms. Today we’ll look at how to create forms for SQL databases. You can also use forms to limit access to your database.
Ronan McQuillan
Oct 3, 2024
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
Oct 1, 2024
CAP vs ACID is probably one of the most widely misunderstood questions in the world of data engineering. Today, we’re setting out to dispel any misconceptions and give you an actionable, practical guide to choosing the right data storage framework for your real-world applications. We’ll break down some pretty complex computer science theory into insights with real-world applicability - including checking out examples of what key principles look like in practice.
Ronan McQuillan
Sep 30, 2024
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
Sep 21, 2024
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, 2024