April 2001
Intermediate to advanced
432 pages
13h 2m
English
Content preview from Oracle and Open Source
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
gASQL
In addition to working on GNOME-DB, Vivien Malerba is contributing to an embryonic project with Gerhard Dieringer called gASQL. The gASQL application is a GTK+-based relational modeling tool that works with all of the GNOME-DB compatible databases, including, of course, Oracle. gASQL graphically represents an entity relationship diagram (ERD) of the tables in your database. It provides you with an easy-to-understand view of your tables and their primary keys, foreign keys, and sequences.
Tip
In order to demonstrate gASQL’s database independence (and for some variety), we’ve used the PostgreSQL database for the examples in this section.
The main web site for gASQL is:
| http://gasql.sourceforge.net |
Installing gASQL
gASQL is an application based on GNOME-DB, so refer to the GNOME-DB section for preliminary installation information. Actually, GNOME-DB is the hard part. After you finish installing it, you’ll have all the libraries and associated software you need installed. You can install gASQL from source or use an RPM as we did.
If you do decide to install from source, follow the basic format of other source-based installations. Here is an outline:
Download the source code from http://gasql.sourceforge.net.
Expand the tar file:
$ tar xvzf my_code.tar.gz
Build the Makefile:
$ cd my_code $ ./configure
Run make to build libraries and executables:
$ make
Install the libraries and executables in the proper directories on your system. You must be the root user to perform this step:
$ cd /path/to/my_code ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.