This is a read-only archive. Find the latest Linux articles, documentation, and answers at the new Linux.com!

Linux.com

Re:question about Access

Posted by: Anonymous Coward on May 24, 2004 12:20 AM
> what did your brother replace Access with?

His database is not overly complex, and he originally programmed it himself. He migrated the data to MySQL (though I was pushing for PostgreSQL<nobr> <wbr></nobr>:-).

Migrating the data was fairly simple -- define the new tables, and then just export and import. The front-end queries, however, are more complicated.

Initially, for the front end, I helped him set up some rudimentary web-based queries using PHP.

We also used <A HREF="http://www.phpmyadmin.net/home_page/" title="phpmyadmin.net">phpMyAdmin</a phpmyadmin.net> (or <A HREF="http://sourceforge.net/projects/phpmyadmin/" title="sourceforge.net">here</a sourceforge.net>) to create and manage his MySQL tables.

He hasn't set up his local front-end yet, though he will probably be using the database software that comes with StarOffice.

I haven't used it myself, but I see from the <A HREF="http://wwws.sun.com/software/star/staroffice/faq.html#1q7" title="sun.com">StarOffice FAQ</a sun.com> that it now comes with the <A HREF="http://www2.softwareag.com/Corporate/products/adabas/default.asp" title="softwareag.com">Adabas Database</a softwareag.com>.

I had also suggested a few other alternatives, such as:

- A custom-written front-end using the Mozilla toolkit.
- A custom-written front-end using Gnome (since JDS is Gnome-based).
- GnomeDB (though I don't know how far along that project is).
- The database access capabilities of OpenOffice (though they're quite rudimentary).

#

Return to First look: Sun Java Desktop System Release 2