1

I need to practice SQL for my database class, and wanted a simple, hassle-free app that would let me write code and execute it. Does this exist?

1001000100100101010010101
  • 23
  • https://data.stackexchange.com has real data that you can perform all sorts of queries on (I'm commenting because this fits "practising SQL", but might not be what you're looking for) – grooveplex Jul 29 '16 at 18:46
  • what is your database? mysql? sqlite? progress? you can even try sql online: http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all – Rinzwind Jul 29 '16 at 18:48
  • MySQL. I know of Oracle and MySQL workbench, but I need a plain 'ol type, click run, save, etc. It would be pleasant if it had a dark theme. – 1001000100100101010010101 Jul 29 '16 at 18:51

2 Answers2

2

Back in the day I thought databases with SquirrelSQL and the students did not complain. It is a Java programme, so all you need is to download the jar file and run it.

Naturally, you need some DBMS to practice, in this regard I recommend Firebird. It is available from the official repositories, you can install it directly with apt:

sudo apt install firebird2.5-classic

Follow on the Ubuntu Wiki on Firebird for the examples and the first steps interacting with Firebird.

Luís de Sousa
  • 13,227
  • 26
  • 81
  • 128
1

SQLite3 is worth looking at. It is built in to Mobile phones and tablets to handle data like your contacts, app data, diary etc. SQLite3 studio is its own interface and can be a really useful app. It is all free. Best wishes in your studies

NotTheGuru
  • 11