-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/24/07 15:04, Craig Hawkes wrote: > Hi > > OK, Sorry but I did search, and did not find anything useful. > > Maybe putting forward a embedded solution as part of the question was the > wrong option. > > If I could reword: > > Given that we have a large estiblished client base running a Delphi/Paradox > solution, and that we would like to replace Paradox with a much better SQL > engine, I was looking for comments as to how Postgres maybe suitable. > > We will be implementing more multi-user features - it really is only single > user at this stage, plus we would like to be able to use better SQL - > espically for Reporting - where currently we have hundreds of lines of > Delphi code which could be replaced with a one or two reasonable SQL > Queries. Hmmm. Is Paradox that bad? Or are you pinning too many hopes on SQL? > There will really be two targets, replacing the existing single user > solutions, and providing a larger solution with multi-user etc. There is > however large base of similar code between these solutions, and it would be > perferable if they could use the same back-end engine or something very > simliar. I know some people will aruge that you should use the right tool > for the job, and I guess I am tring to see if there is a right tool which > will work for both these. > > My main/only real hesiation with Postgres is around supporting non IT users, > mainly around installation. I am keen to here peoples comments on this, and > what steps could be taken to mitigate these. Install PostgreSQL on your box, run the app and see how much maintenance it needs, and how much can be scripted. If PG is installed as a service (which it should be, no?), then certainly there is an API call to start the postgresql service at the beginning of your app and another to stop the service during app termination. > Currently the main alternate which is being considered is SQL Server, using > SQL Express, SQL Mobile/Compact. But I see this as limiting use to only > features supported by the Compact edition, or having to install SQL Express > - which I can see as being worst than supporting Postgres Installs. I think that you're just going to have to create a pilot project to see how it fits your individual needs. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHIAehS9HxQb37XmcRApZYAJ9uI5NHgVF19MytK2M+7+6xHGhlNACfR1bL qRhO+gSrIF5ow7lbQUbkWqo= =5vCS -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
