Database on Mac

Hello annemcmahon2,

I'm sorry, but the answer is no.

First of all, you are asking about a dynamic website. You can't run that from your Mac. You have to host that somewhere. There are hundreds of different hosting providers for web sites. If you specify what kind of website you want to create, we might be able to give you some tips about where to host it.

But regardless, any data on that website is going to exist only on that website. Getting the data to and from your Mac will be a challenge. Doing it in any kind of friendly or easy fashion is absolutely out of the question.

That being said, there are many different hosting providers that do provide a friendly and easy interface for managing your site and data. Those sites will work with any computer.

Do you want to create a website using a database or do you want to use a database to create the website? There are any number of database programs around including one built-in to the Unix side of OS X called MySQL. There are many GUI front-ends for using the database.

You might find what you want at MacUpdate.

How To Safely Use Macupdate To Download Ad-Free Software

This site has both free and paid membership accounts. If you have neither then some software will be distributed as an installer wrapper that includes adware/malware you may not want. Such a download may appear on your computer like this: Firefox Installer.dmg. Delete the download and return to the main site where you will find a direct link to the developer's website. Use that link from which to download the software. Or a simpler way is to establish a free or paid membership to avoid problems getting adware with your download.

The database that continues to be the default installation by OS X/macOS is sqlite3, not MySQL, which is offered here. Both MySQL, and even Postgres (aka PostgreSQL) were offered with OS X clients several years ago, but no longer. The sqlite3 database by itself is useless for web integration until you put some “glue” between your web interface and the database. Read this article on the sqlite3 mission.

Both OS X/macOS use the sqlite3 database behind the scenes, and you are encouraged to not update the System version of sqlite3 with a newer version than installed by the operating system. Things could break.

The sqlite3 application has help in the form of the -help switch, or the documentation on the developer's site.

Here is phpLiteAdmin, a single 250KB php file that provides a visual interface to a sqlite3 database.

These days it's best to use a professionally managed server.

If you to do you own thing, you need to install lAMP equivalent on mac os.

https://jason.pureconcepts.net/2012/10/install-apache-php-mysql-mac-os-x/

There are some packages around for managing dynamic web sites. I forget there names.

R