Creating a Database on my Mac
Hello,
What is a good SQL program for mac for creating a database for my student database for a School Attendance System I am working on? Perifably GUI based as I don't work well with a command line.
3 Replies
still unsure what you mean, I'll assume you don't have a database at all and you want one you can use with a GUI, that's kinda 2 different problems btw
you can pick any database and there's many apps that let you have a GUI to interact with it but it tends to be a specific GUI for a specific database
if you want something really simple you could try supabase which is a postgreSQL database with a web-based GUI
it is more of a complete backend solution than just a database, so you can instead work with Postgre but use Postico for the GUI
OR if you don't know much about databases and how to set them up...use SQLite, simplest and smallest db you can use but absolutely good enough for your project
I've never used a GUI with sqlite so you'll have to google that yourself and see what works for you
+1 for SQLite
The good thing about picking the database and the GUI separately is that you aren't locked down to either client in particular. I don't know about any clients, btw, but I always use phpmyadmin which is web-based.
You should try Directus. They have really good documentation and examples. It's like a GUI for your SQL database. I have an instance running on Railway with a postgres database attached for a blog and a recipe website I use with my family. https://directus.io/
The Open Source Headless CMS (and More)
A powerful CMS, BaaS, and more. Power any project with Directus – a composable data platform to easily create and deploy data-rich apps.