Skip to main content
Home

Main navigation

  • Apps
  • Forum
  • Blog
    • Podcast
    • Guides
    • Hardware & Accessory Reviews
    • Bug Tracker
    • Developer Resources
  • Log in

Breadcrumb

  1. Home
  2. Forums
  3. macOS and Mac Apps

Suggestions on accessible ways to create SQL databases

By Chuck Winstead, 7 August, 2017

Forum
macOS and 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

  • Log in or register to post comments

Comments

SQLite3 is available from terminal

By Tyflos Accessible Software

5 years ago

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

By mehgcap

5 years ago

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

By gfish103

5 years ago

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.

More Like This

Coding SQL on Mak (Forum Topic)
Programming on a Mac question (Forum Topic)
SQLiteFlow - SQLite Editor (iOS and iPadOS App Directory)
asking for some suggestions for Web Development (Forum Topic)
Seeking Beta Testers for BlindSpot app (Forum Topic)
The Guy in the Spider’s Web… An Overview of Creating a Website with WordPress and a Screen Reader (Blog Post)
Trouble with Windows updates in bootcamp (Forum Topic)
ssh client (Forum Topic)

Site Information

  • About
  • Club AppleVis
  • FAQ
  • Contact

Unless stated otherwise, all content is copyright AppleVis. All rights reserved. © 2022 | Accessibility | Terms | Privacy