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

4 years 10 months 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

4 years 10 months 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

4 years 10 months 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)
Wi-Fi Finders (Forum Topic)
Database Software (Forum Topic)
I am looking for a database application (Forum Topic)
Request for Database app for iOS (Forum Topic)
Accessible database program for mac (Forum Topic)

Site Information

  • About
  • Club AppleVis
  • FAQ
  • Contact

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