We have a schema for a MySQL relational database which includes web links, and also much other non-link data, eg: personal, events, geographical.

It looks to us like Gossamer Threads has done all the necessary work on the web links aspects, plus most of the work on external editors, building static pages, security, etc.

No point us doing these things ourselves, when GT has already done it so effectively. But we are wondering just how easy it would be to combine LinksSQL with other MySQL tables. Has anyone else done this?

We will probably order a copy of LinksSQL for experimentation, work it out for ourselves, but would appreciate existing knowledge that anyone could share in this forum.

Put all the other data into the Users table.

Regards,

Eliot Lee
http://anthrotech.com/

Hi,

If you are planning custom work, you may want to look at:

http://www.gossamer-threads.com/...help_guide_libs.html

which outlines the modules that come with Links SQL. Of interested would be the GT::SQL libraries which make it very easy to access data inside Links SQL, or merge it with other tables.

Cheers,

Alex

--
Gossamer Threads Inc.

What I have already started is modelling the database using Datanamic http://www.datanamic.com/.
You build a visual schema, and it outputs code for numerous DBMS's, including MySQL tables.

I would like to integrate LinksSQL into the generated schema ... if I can think of a way to do it.

I'm a novice at this sort of Visual Data Modeling thing (so far), but I'm on the curve. Wondering if there is anyone here more advanced who can tell me if I'm on the right track (or wasting my time) .. or if there is a better tool for the job.

I think you are wasting your time.

What I would recommend is FIRST install Links SQL and then add features to it. Doing the opposite will be way more pain than its worth!

Regards,

Eliot Lee
http://anthrotech.com/

Eliot's right. Start with Links SQL, and work backwards. You'll be glad you did.

PUGDOG® Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Plugins:http://LinkSQL.com/plugin

OK. Thanks for your input. We won't waste any more time. We will take your advice.