Re: PostgreSQL and AutoCad - Mailing list pgsql-general

From Ilan Volow
Subject Re: PostgreSQL and AutoCad
Date
Msg-id F2C47E48-11C9-4633-B3EC-FE43D4FD6AD3@clarux.com
Whole thread Raw
In response to Re: PostgreSQL and AutoCad  (Bob Pawley <rjpawley@shaw.ca>)
Responses Re: PostgreSQL and AutoCad
List pgsql-general

As I have a vested interest in storing AutoCad stuff in PostgreSQL, I searched for something like this a while ago and I ran across this.. I haven't really had a chance to play with it yet


I'm personally interested in the idea of versioning for a drawing. Instead of storing the entire drawing for each version, one could theoretically just store the vector additions/changes/deletions that happen from one revision to the next.

-- Ilan

On Oct 30, 2007, at 11:34 AM, Bob Pawley wrote:

If your holy grail is the ability of using infomation to drive drawings I have to ask if you have any idea what that could lead too?

- Design productivity would increase by factors of hundreds - perhaps thousands.

- Information would be infinitly adaptable.

- Structure that information properly and knowedge will result.

- We would begin to realize the full potential of computing power.

Is that what you were saying??

Bob





----- Original Message ----- From: "Richard Broersma Jr" <rabroersma@yahoo.com>
Sent: Monday, October 29, 2007 9:13 PM
Subject: Re: [GENERAL] PostgreSQL and AutoCad


--- On Thu, 10/25/07, Andy <nospam@noplace.com> wrote:
>> Is there any way of converting text from an
AutoCad (.dwg ot .dxf) file into
>> a PostgreSQL  Database??
Do you want AutoCad to edit the drawings right out of the
database?  How
would you want to put them in/get them out, of the
database?

I think the more traditional problem is to extract information embedded (within blocks) in a drawing to produce a bill of material.  As long as the text is stored in a block it is a trivial task.  On the other hand, if the text is free floating in the drawing, finding it is a little more difficult but still possible using lisp or vba.

Auto cad has prebuilt tools to extract/link data from blocks to any ODBC compliant database.  Of course, the holy grail would be to eliminate auto cad altogether and then render drawings from the data stored in the database. :-)
Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend 


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Ilan Volow
"Implicit code is inherently evil, and here's the reason why:"



pgsql-general by date:

Previous
From: Oisin Glynn
Date:
Subject: Re: PG windows service issues
Next
From: Brian Wipf
Date:
Subject: Re: Base Backups from PITR Standby