Re: PostgreSQL 8.1 vs. MySQL 5.0?

> > Just so I know (and am armed ;) ), are there any new comparable
> > features in MySQL 5.0 that aren't in PostgreSQL up to the
> forthcoming
> > 8.1? AFAIK, PG just lacks updatable views (which are on the TODO).
>
> PostgreSQL does not run in Windows 98
>
> There is a LOT of customers running Windows 98 .
>
> So I must switch to a Firebird, am I right ?

You can run PostgreSQL on Cygwin on Win98, I think.

But ifyou're running your database server on win98, you obviously don't
care much about your data :)

(PostgreSQL *client* tools and drivers run fine on Windows 98, btw)

//Magnus

> PostgreSQL does not run in Windows 98
> You can run PostgreSQL on Cygwin on Win98, I think.
> But ifyou're running your database server on win98, you obviously don't
care much about your data :)

My goal is to allow my application demo, trial and development versions to
run in every Windows.
If customer is not able to run even demo, he will not add data to take care
of. So running in Windows 98 is more important than taking a much care about
data in this case.

So I must add both native and cygwin versions and cygwin intallation to my
application setup and maintain cygwin and postgres-cygwin versions. A huge
meaningless work.

Do you think that this is more reasonable than using Firebird ?

Apache runs well in Windows 98. Why this is so difficult in native Windows
Postgres?

> (PostgreSQL *client* tools and drivers run fine on Windows 98, btw)

1.pgAdmin refuses to run in Windows 98, displays that it is compiled with
unicode support.
Where to find binary version of pgAdmin for Windows 98 ?

2. I use unicode encoding in databases. Are you sure that pgAdmin allows to
display accented charaters in Win 98 ?

Andrus.

1.pgAdmin refuses to run in Windows 98, displays that it is compiled with

>unicode support.
>Where to find binary version of pgAdmin for Windows 98 ?
>
>
>
You could try PG Lightning Admin, it should work in windows 98.
I don't have access to a win98 box to really test, but it *should* work.

--
Tony Caduto
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql 8.x

"Andrus" <eetasoft(at)online(dot)ee> writes:

> Apache runs well in Windows 98. Why this is so difficult in native Windows
> Postgres?

I *think* it's because we use certain features of NTFS, which Win98
will never support.

-Doug

"Douglas McNaught" <doug(at)mcnaught(dot)org> wrote in message
news:m2br21zd2l(dot)fsf(at)Douglas-McNaughts-Powerbook(dot)local(dot)(dot)(dot)
> "Andrus" <eetasoft(at)online(dot)ee> writes:
>
>> Apache runs well in Windows 98. Why this is so difficult in native
>> Windows
>> Postgres?
>
> I *think* it's because we use certain features of NTFS, which Win98
> will never support.

Postgres runs also in FAT32 file system , so this cannot be problem.

Problem may be service support.
Apache runs in Windows 98 as usual application, not as service. So this can
be done in Postgres also.

Andrus.

"Tony Caduto" <tony_caduto(at)amsoftwaredesign(dot)com> wrote in message
news:434672E3(dot)3030909(at)amsoftwaredesign(dot)com(dot)(dot)(dot)
> 1.pgAdmin refuses to run in Windows 98, displays that it is compiled with
>
>>unicode support.
>>Where to find binary version of pgAdmin for Windows 98 ?
>>
>>
> You could try PG Lightning Admin, it should work in windows 98.
> I don't have access to a win98 box to really test, but it *should* work.

My policy is to use open source or free software. So I can't use it, sorry
for that.

I tried EMS PostgreSQL Manager 3 Lite but it displays unicode incorrectly
even in XP.

Another open source project, EMULE, has excellent unicode support in Windows
98. It requires to load unicode support package from Microsoft for Windows
98.
Why this cannot be impemented in pgAdmin ?

Andrus.

On Friday 07 October 2005 04:22, Andrus wrote:
> > PostgreSQL does not run in Windows 98
> > You can run PostgreSQL on Cygwin on Win98, I think.
> > But ifyou're running your database server on win98, you obviously don't
> care much about your data :)
>
> My goal is to allow my application demo, trial and development versions to
> run in every Windows.
> If customer is not able to run even demo, he will not add data to take care
> of. So running in Windows 98 is more important than taking a much care
> about data in this case.
> So I must add both native and cygwin versions and cygwin intallation to my
> application setup and maintain cygwin and postgres-cygwin versions. A huge
> meaningless work.
> Do you think that this is more reasonable than using Firebird ?
>

Just depends on how well your application code will work with firebird, but
I'd certainly cut you some slack that it's a good reason to look around.
Since this sounds more like a single use application database you might want
to look at sqlite. It's install requires zero configuration and it's public
domain software so you don't have any licensing issues and afaik it runs on
win98 with no problems.

> Apache runs well in Windows 98. Why this is so difficult in native Windows
> Postgres?
>

You have to realize that the complexity of a RDBMS is worlds above that of a
simple webserver right? More to the point, PostgreSQL makes use of some
elements of NTFS which is not supported by win98. To be honest, I believe
you could hack things to get around this, but it's probably not worth the
effort / possible stability issues.

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

"Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net> wrote in message
news:200510071059(dot)16093(dot)xzilla(at)users(dot)sourceforge(dot)net(dot)(dot)(dot)
> On Friday 07 October 2005 04:22, Andrus wrote:
>> > PostgreSQL does not run in Windows 98
>> > You can run PostgreSQL on Cygwin on Win98, I think.
>> > But ifyou're running your database server on win98, you obviously don't
>> care much about your data :)
>>
>> My goal is to allow my application demo, trial and development versions
>> to
>> run in every Windows.
>> If customer is not able to run even demo, he will not add data to take
>> care
>> of. So running in Windows 98 is more important than taking a much care
>> about data in this case.
>> So I must add both native and cygwin versions and cygwin intallation to
>> my
>> application setup and maintain cygwin and postgres-cygwin versions. A
>> huge
>> meaningless work.
>> Do you think that this is more reasonable than using Firebird ?
>>
>
> Just depends on how well your application code will work with firebird,
> but
> I'd certainly cut you some slack that it's a good reason to look around.
> Since this sounds more like a single use application database you might
> want
> to look at sqlite. It's install requires zero configuration and it's
> public
> domain software so you don't have any licensing issues and afaik it runs
> on
> win98 with no problems.

I must support demo versions for 1 to 100 users in all Windowses using free
software.

So there are the following options :

1. Use Firebird
2. Use Postgres + cygwin all cases, even in XP
3. Use Postgres native for XP, Postgres+cygwin in Win 98
4. Use Postgres native for XP, Sqlite in in Win 98

(4) is the most expensive (requires supporting 2 different dbmses)

No ida, which is best from the remaining three.

Andrus.

Andrus wrote:
>
> I must support demo versions for 1 to 100 users in all Windowses using free
> software.
>
> So there are the following options :
>
> 1. Use Firebird
> 2. Use Postgres + cygwin all cases, even in XP
> 3. Use Postgres native for XP, Postgres+cygwin in Win 98
> 4. Use Postgres native for XP, Sqlite in in Win 98
>
> (4) is the most expensive (requires supporting 2 different dbmses)
>
> No ida, which is best from the remaining three.

I'd personally just go with Firebird/SQLite, and I say that as a
committed PostgreSQL user who knows next to nothing about Firebird.
You'll have enough problems with various library versions on different
versions of Windows without any other differences. Actually I'd probably
just use a MS-Access runtime engine if I still had a licence here
somewhere.

Presumably your database requirements aren't too demanding, or you
wouldn't be considering running on Win98 in the first place.

--
Richard Huxton
Archonet Ltd

On Fri, Oct 07, 2005 at 07:00:27PM +0300, Andrus wrote:
> "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net> wrote in message
> news:200510071059(dot)16093(dot)xzilla(at)users(dot)sourceforge(dot)net(dot)(dot)(dot)
> > On Friday 07 October 2005 04:22, Andrus wrote:
> >> > PostgreSQL does not run in Windows 98 You can run PostgreSQL on
> >> > Cygwin on Win98, I think. But ifyou're running your database
> >> > server on win98, you obviously don't
> >> care much about your data :)
> >>
> >> My goal is to allow my application demo, trial and development
> >> versions to run in every Windows. If customer is not able to run
> >> even demo, he will not add data to take care of. So running in
> >> Windows 98 is more important than taking a much care about data
> >> in this case. So I must add both native and cygwin versions and
> >> cygwin intallation to my application setup and maintain cygwin
> >> and postgres-cygwin versions. A huge meaningless work. Do you
> >> think that this is more reasonable than using Firebird ?
> >>
> >
> > Just depends on how well your application code will work with
> > firebird, but I'd certainly cut you some slack that it's a good
> > reason to look around. Since this sounds more like a single use
> > application database you might want to look at sqlite. It's
> > install requires zero configuration and it's public domain
> > software so you don't have any licensing issues and afaik it runs
> > on win98 with no problems.
>
> I must support demo versions for 1 to 100 users in all Windowses
> using free software.
>
> So there are the following options :
>
> 1. Use Firebird
> 2. Use Postgres + cygwin all cases, even in XP
> 3. Use Postgres native for XP, Postgres+cygwin in Win 98
> 4. Use Postgres native for XP, Sqlite in in Win 98
>
> (4) is the most expensive (requires supporting 2 different dbmses)
>
> No ida, which is best from the remaining three.
>
> Andrus.

I don't know enough about Firebird to have any opinions about it. I
think you're right to see about choosing just one DBMS for your
product. If you plan to de-support Win 98 soon, you might want to
ship PG+Cygwin with it and accept that there will be extra maintenance
costs. You could also use SQLite for everything until you port your
product to PostgreSQL and only offer it on platforms that allow you to
run PostgreSQL natively.

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!

Am Freitag, den 07.10.2005, 19:00 +0300 schrieb Andrus:
...
> I must support demo versions for 1 to 100 users in all Windowses using free
> software.
>
> So there are the following options :
>
> 1. Use Firebird
> 2. Use Postgres + cygwin all cases, even in XP
> 3. Use Postgres native for XP, Postgres+cygwin in Win 98
> 4. Use Postgres native for XP, Sqlite in in Win 98
>
> (4) is the most expensive (requires supporting 2 different dbmses)
>
> No ida, which is best from the remaining three.

You could also just make a live CD to boot the PCs using
some linux. Postgres isnt really a desktop database
so you might also consider building one special
CD with the database and 1-99 "client" CDs -
where you even have the choice to put the win98/xp/whatever
native applications if its desireable.

If you present it to customers, you can also put the
database on your notebook and just bring the clients
with you.