Thoughts and ideas on how to build tools, automate workflows and speed-up the workplace.
Understanding the different methods of API authentication is a core competence for any would-be developer, data professional, or anyone else who wants to connect to external tools, data sources, or other resources. Nowadays, APIs are fundamental to the way we build, integrate, and use all kinds of digital tools - whether this is building custom software from scratch - or simply connecting existing SaaS platforms to create streamlined workflows. So, you need to know how to use the different authentication methods that vendors could implement for their APIs.
Ronan McQuillan
Jul 21, 2023
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
Jun 23, 2023
MySQL admin tools are some of the simplest applications around - but they can play a vital role in all kinds of daily workflows. The unfortunate reality is that the kinds of colleagues who are responsible for most admin tasks don’t have the technical expertise or time to sit around writing custom queries all day. Therefore, we often need custom solutions to bridge this gap. IT teams are tasked with outputting huge numbers of internal tools for managing data sets.
Ronan McQuillan
Jun 23, 2023
Moving data from Google Sheets to Postgres - or the DBMS of your choice - is one of the fundamental steps toward achieving modern, effective data management. See, huge numbers of teams rely on spreadsheets for use cases where they just aren’t really suitable. Obviously, spreadsheets are so dominant for a reason - there’s no disputing that they offer a huge degree of flexibility, power, and usability. But - when it comes to securely scaling data operations while maintaining accuracy, reliability, and interoperability, they leave a lot to be desired.
Ronan McQuillan
Jun 16, 2023
Nowadays, your workload management tool is at the center of your daily operations. In the age of remote, distributed teams, effective oversight and coordination is everything. And the market has responded. In fact, there are countless platforms out there trying to fill this niche. The only trouble is that every company has its own unique requirements and challenges. Therefore, COTS vendors typically cast the widest net possible - aiming to provide value for the largest number of buyers rather than fully meeting more individualized requirements.
Ronan McQuillan
Jun 2, 2023
Knowing how to build a dashboard is one of the core competencies for most knowledge-based jobs. Dashboards are the difference between raw data and clear, actionable insights. Most of us can pull up a couple of pie charts based on a spreadsheet - or even use a visualization platform like Looker to create basic reports. But what happens when your business data doesn’t fit neatly into one of these tools?
Ronan McQuillan
Apr 28, 2023
Today, we’re going to run through how to build a relatively simple but no less powerful tool - an employee management app using Budibase. Your employees - along with their skills, knowledge, and expertise - are some of your most valuable assets. Therefore, making better use of their time is one of the easiest ways to create huge efficiency savings. And for that, we need proper oversight. Who is doing what - and when?
Ronan McQuillan
Apr 6, 2023
A Firestore Firebase GUI is the easiest way to interact with your database without coding. Firebase is a versatile tool for app developers. It can completely replace the back end of your app, so you can focus on its front end and features. But all this versatility comes with a cost. Firestore Firebase is widely used by developers, but interacting with it can be quite hard - in particular, if you need to perform admin actions.
Ronan McQuillan
Nov 21, 2022