Thoughts and ideas on how to build tools, automate workflows and speed-up the workplace.
AI is fast becoming an integral part of all kinds of development projects. At the most basic level, this requires us to know how to connect various elements of our applications to AI tools and models. As you might expect, interactions between our app’s data layer and LLMs are probably the most important component to this. The challenge is that this can take a number of different forms. This depends on what kind of data we’re using, our use case, and how widespread or varied the interactions we require are.
Ronan McQuillan
May 28, 2025
AI is forming a key part of more and more internal tools. At a basic level, this requires us to have the tools and techniques available to connect different layers of our applications to AI models, in order to perform functions. Naturally, the database is probably the most important component to this. However, this also poses some key challenges. For one thing, certain database engines have been quicker to adopt AI-ready functionality than others.
Ronan McQuillan
May 27, 2025
A Postgres GUI helps you make the most out of your database, whether you are a coder or not. Databases are incredible tools for businesses. They allow you to store and process data at scale so that you can make better-informed decisions. You have two options to load data from databases. You can use code via a command line or a programming language. So, you type in the commands in a terminal or send your code to a server, and you get the results.
Ronan McQuillan
May 20, 2025
MySQL is one of the most popular database systems out there. And that’s for a good reason. It is lightweight, fast, easy to learn, and widely available. Using a MySQL GUI to manage your databases will help you make the most out of this tool. A GUI (Graphical User Interface) allows you to interact with your database with a visual interface. This allows you to see your data and use visual elements as opposed to text-based terminals and command lines.
Ronan McQuillan
May 20, 2025
SQL is a powerful query language that’s used to unlock valuable insights stored in databases. No matter how large our database is or what we’re using it for, we need a streamlined, accessible way to interact with our data. But we also need to do this in a controlled, secure manner. That’s where an effective SQL GUI comes in. A GUI - graphical user interface - is an application that allows us to interact visually with our data, rather than relying solely on written commands.
Ronan McQuillan
May 18, 2025
A Google Sheets GUI can help you turn your spreadsheets into real apps. Google Sheets is one of the most ubiquitous, widely used business tools around today. It allows you to get all the power of spreadsheets, databases, and scripting all at once. But at the end of the day, it’s still a spreadsheet tool. So you are limited to the grid design and unfiltered data entry. Users can add data in the wrong format.
Ronan McQuillan
May 17, 2025
Handling compliance tasks requires us to have a clear record of which policies are in place and how they change over time. For this, we need a robust system that enables colleagues to interact with our policy data in a structured way. The trouble is the specific internal workflows involved in this are rarely the same from one organization to the next. Today, we’re exploring one way of addressing this problem, by building a custom policy management system in Budibase.
Ronan McQuillan
Mar 14, 2025
Managing changes to engineering projects can be an incredibly tricky process. Even seemingly minor changes must be accurately assessed for risks, costs, compliance issues, and potential impacts. This applies to almost all kinds of engineering, including software, construction, and others. The key challenges here include identifying a need for change, assessing the impact of potential actions, and applying consistent business rules to authorize new change initiatives. However, engineering projects also introduce additional difficulties.
Ronan McQuillan
Feb 27, 2025