Suggestions on accessible ways to create SQL databases

Forum
macOS & Mac Apps

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

Options

Comments

Submitted by Tyflos Accessi… on Monday, August 7, 2017

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

Submitted by mehgcap on Monday, August 7, 2017

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.

Submitted by gfish103 on Wednesday, August 9, 2017

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.