Re: [GENERAL] Porting from FrontBase

2007-11-30 Thread Martin 
In article [EMAIL PROTECTED],
David Fetter [EMAIL PROTECTED] wrote:

FrontBase has a Perl DBI driver
http://www.frontbase.com/cgi-bin/WebObjects/FrontBase, so you may be
able to use DBI-Link http://pgfoundry.org/projects/dbi-link/.

If you try that approach, let me know how it works out :)

Thanks, that looks interesting. Even if it doesn't work out for
porting, I will have to play with it. ;)

BTW, I ported a few of the tables and one of the queries. The timing
difference is quite amazing:

FrontBase:  13 seconds
Postgresql: 42 msec

There's a lot of incentive to do the port ;)


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/

[GENERAL] Porting from FrontBase

2007-11-29 Thread Martin 
I am looking at porting a web application from FrontBase to
Postgresql. If anybody has some tips on how to deal with
this, I'd appreciate hearing him. Thanks.


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

Re: [GENERAL] Porting from FrontBase

2007-11-29 Thread Guido Neitzer 

On 29.11.2007, at 12:30, Martin wrote:


I am looking at porting a web application from FrontBase to
Postgresql. If anybody has some tips on how to deal with
this, I'd appreciate hearing him. Thanks.


If it is WebObjects, you can contact me off-list. I've done that for  
some of our apps. It's not really hard.


cug

--
http://www.event-s.net


---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org/

Re: [GENERAL] Porting from FrontBase

2007-11-29 Thread David Fetter 
On Thu, Nov 29, 2007 at 07:30:53PM -, Martin wrote:
 I am looking at porting a web application from FrontBase to
 Postgresql. If anybody has some tips on how to deal with
 this, I'd appreciate hearing him. Thanks.

FrontBase has a Perl DBI driver
http://www.frontbase.com/cgi-bin/WebObjects/FrontBase, so you may be
able to use DBI-Link http://pgfoundry.org/projects/dbi-link/.

If you try that approach, let me know how it works out :)

Cheers,
David.
-- 
David Fetter [EMAIL PROTECTED] http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter  XMPP: [EMAIL PROTECTED]

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster