An up-to-date look at free software and its makers

PROJECTS ON THE MOVE

Article from Issue 77/2007
Author(s):

Inthis month’s Projects on the Move, we look at Squirrel SQL, a full-featured easy-to-use GUI-based database management tool. We also have updates on Debian: frozen Etch, the upcoming DebConf 7, and spring cleaning
on the Debian Desktop.

Just like on a filesystem, the command line is often the quickest way to perform many database-related tasks. This said, GUI-based front-ends also have some advantages, like giving you a fast overview of existing databases and tables. Plus, if you are unfamiliar with a particular SQL dialect or engine, you can still edit tables, modify access privileges or change table structures. If you need SQL queries for more complex tasks, they often provide SQL editors with syntax highlighting.

Buy this article as PDF

Express-Checkout as PDF
Price $2.95
(incl. VAT)

Buy Linux Magazine

SINGLE ISSUES
 
SUBSCRIPTIONS
 
TABLET & SMARTPHONE APPS
Get it on Google Play

US / Canada

Get it on Google Play

UK / Australia

Related content

  • Introduction

    Charly has a web mailer on his server just for family and friends. Last weekend he ditched the overly simplistic SquirrelMail for a Web 2.0 program.

  • Kexi vs. Glom

    Kexi and Glom aim to create databases with little overhead. We compare the power of these two tools.

  • Full-Text Search Engines

    Full-text search engines like Solr, Xapian, and Sphinx make the daily data chaos on your hard disk searchable – and they even cooperate with relational databases.

  • MySQL Workbench 5.1

    A small database is easy to plan on paper, but the structure quickly becomes more complex as you add more elements. MySQL Workbench can help you keep the tables arranged.

  • Knoda Workshop

    KDE’s Knoda provides an intuitive front end for an SQL database. This workshop introduces Knoda and shows how you can use Knoda to simplify common database management tasks.

comments powered by Disqus

Direct Download

Read full article as PDF:

Free_Software_Projects.pdf (217.42 kB)

News