Re: Choice of DB

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Choice of DB
Date: 2018-11-27 21:40:16
Message-ID: 1543354816692-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

To prevent any database war, I would suggest you to try a little POC ...

Regarding your testcase, I think that Postgresql can work fine, with the
expected performances.

What is much complicated is evaluating the migration effort ...

List all the Datatypes, object types you are using with Firebird,
and if you are using PL (triggers, functions, ...)
and check what are the corresponding datatypes / objects or corresponding
PL/pgsql syntax.

Then choose the more representative part of your application (a simple table
set, PK, FK)
and try to migrate it.
Reload sample data, and test !

You will have a much better view of the chances of success ;o)

Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-novice-f2132464.html

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Crawford 2018-11-27 21:46:09 Re: Choice of DB
Previous Message Thomas Kellerer 2018-11-27 21:36:39 Re: Choice of DB