Thoughts and ideas on how to build tools, automate workflows and speed-up the workplace.
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
If you want to manage or retrieve data without coding, an Elasticsearch GUI might just be the tool for you. Elasticsearch is used to perform fast searches, no matter how big your database is. It uses a series of ingenious solutions to preprocess data, allowing you to scale your database as much as you need, without sacrificing efficiency. It has so many tools that it’s hard to make sure that you are getting the most out of it.
Ronan McQuillan
Nov 2, 2022
With a Redis GUI, you can make the most out of your database, without memorizing any commands. Databases are incredible business tools. They allow you to store and manipulate large sets of data. That way, you can make better-informed decisions. They provide you with insights that just wouldn’t be possible with manual data storage. But they can be quite complex. Redis is a NoSQL database. It allows you to store data in key/value pairs.
Ronan McQuillan
Oct 17, 2022