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.

  • Free Software Projects

    Ajax lets web developers concentrate on the important things and leave the browser abstraction to the libraries. Also in this issue, Cdrecord forked, Debconf in kilts, bugs squashed at Debian, and the latest news on Debian Etch.

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

  • KDE's Kexi Database

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

  • Electron

    GitHub's Electron project brings the benefits of web programming to the realm of desktop applications.

comments powered by Disqus

Direct Download

Read full article as PDF:

Free_Software_Projects.pdf (217.42 kB)
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Find SysAdmin Jobs