Suggestions on accessible ways to create SQL databases

Hello apple Vis,
I want to work on a few different databases. Does anybody have any suggestions for accessible methods to use sql?
Thanks in Advance.
Chuck

Forum: 

SQLite3 is available from terminal

App Developer

You can manage SQLite3 data bases from terminal.

Open Terminal
Type: sqlite3 myDatabase.db

And a new database file named "myDatabase.db" will be created.

sqlite3 environment can use standar SQL language with some limitations.

You can use these commands to get more information or quit the SQLite environment
.exit, .help, .headers, etc

remember: In terminal all commands are case sensitive and remember you have to use special punctuation for some commands.

Regards

MySQL too

Member of the AppleVis Editorial Team

I believe you can also install MySQL and access it from Terminal. Once installed, type

mysql -u root -p

and press enter, then type the root password you configured during setup and press enter again. You're now in the MySQL prompt, and can do anything you like here. CREATE, show, or drop databases, use one and play with tables, manage users, whatever you want. Type quit; (note the semicolon) and press enter to exit back to Terminal.

Terminal is your best choice

App Developer

Agree. If your databases are held on a remote server, you can either ssh to that machine and do anything you like or connfigure the databases to make them support remote management. The former is more secure.