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


Article from Issue 77/2007

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

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.

  • 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.

  • Workspace: DAM with Glom

    Desktop databases are perfect for keeping tabs on miscellaneous data – from links and text snippets, to tasks and invoices – but building databases from scratch can be a daunting proposition, unless you use Glom for the job.

  • KDE's Kexi Database

    Kexi, part of the KOffice suite, allows anyone to create, populate, and maintain a database.

comments powered by Disqus

Direct Download

Read full article as PDF:

Free_Software_Projects.pdf (217.42 kB)