Hi all, I would like to know if somebody works with a database under QNX. I
take a look on some proposed by the QNX Web site but I would like to have an
idea from an end user.
I would like to create a application with a database that maybe can interact
with other OS to create reports for exemple. My QNX application can made
the processing and collecting data via the database and we will be interest
to made reports with these data on another application.
Thanks in advance.
We’re going to try the free Postgress as soon as we can get funds for a
TCP/IP developers license out of our boss. If anyone has binaries for
Postgress on QNX4 we’d appreciate a copy…
-Paul
Sylvain Guillemette <sguillemette@akitek.com> wrote in message
news:8rla8l$511$1@inn.qnx.com…
Hi all, I would like to know if somebody works with a database under QNX.
I
take a look on some proposed by the QNX Web site but I would like to have
an
idea from an end user.
I would like to create a application with a database that maybe can
interact
with other OS to create reports for exemple. My QNX application can made
the processing and collecting data via the database and we will be
interest
to made reports with these data on another application.
Thanks in advance.
Empress seems to work rather well. It provides a full-blown sql server and
ODBC server option, so you can access the database from various windows
apps such as excel and access.
Pricing is not too bad.
Your choice depends upon budget and requirements.
Regards …
“Sylvain Guillemette” <sguillemette@akitek.com> wrote in message
news:8rla8l$511$1@inn.qnx.com…
Hi all, I would like to know if somebody works with a database under QNX.
I
take a look on some proposed by the QNX Web site but I would like to have
an
idea from an end user.
I would like to create a application with a database that maybe can
interact
with other OS to create reports for exemple. My QNX application can made
the processing and collecting data via the database and we will be
interest
to made reports with these data on another application.
Thanks in advance.
we use Sybase SQL Anywhere 5.5 as local sql server for data storage and
it works well even on 486dx4-100Mz 16Mb RAM. more that, ram size maybe about
4mb or even less.
advantages:
- larget set of nice features like database encription, transactions
log and so on.
- server is supported under several platforms including win16/32, os/2,
qnx4, linux
- database format is the same for all supported platforms so you can
use same database file for example under winnt and qnx4. when nt server is
crashed [as usually] you can recover valuable database from qnx4 box
- look at the server documentation
disadvantages:
- linking odbc libraties with your program adds about 150Kb to target
image + shared libraries are not supported
- high enough price
- afaik server hasn’t been supported by watcom/sybase for several years
and there’s no perspectives for future development
hints for better server productivity:
- start server (dbsrv50) with transaction logging, it adds a “little”
transaction log but also incleases update/delete/… sql operations speed
- increase page size to 4096 bytes for large databases
- i would strongly recommend to move databas file on separate partition
or even hard drive if it’s possibly of couse. even using two partitions -
one for qnx4 system and another for database file decreases disk overload
dramatically. using separate partition also solves some security and
database file integrity problems.
- anyway, allocate database file as large as you think it might be. if
due to your calculations database may need about 2000 pages - make your
database large enough at the creation moment, don’t let server to add
aditional needed pages in runtime. reason is very easy - creating one large
file at the initialization phase it is probably allocated much more linearry
then adding pages during database grouth. qfs usually is highly fragmented
and in general imho wasn’t designed for large files manipulations.
my a little resume:
watcom sql anywhere 5.5 server is fast, resource safety and roubish
enough, has good enough documentation and at least was used/tested by many
qnx4 users 
enjoy
Ian M. Zagorskih
Software Developer
Novosoft CyBearNet Department
Custom software development and web design since 1992
Phone: +7 (3832) 39-72-60
Fax: +7 (3832) 39-63-58
E-mail: ianzag@novosoft.ru
For more visit http://www.novosoft.ru/
“Sylvain Guillemette” <sguillemette@akitek.com> wrote in message
news:8rla8l$511$1@inn.qnx.com…
Hi all, I would like to know if somebody works with a database under QNX.
I
take a look on some proposed by the QNX Web site but I would like to have
an
idea from an end user.
I would like to create a application with a database that maybe can
interact
with other OS to create reports for exemple. My QNX application can made
the processing and collecting data via the database and we will be
interest
to made reports with these data on another application.
Thanks in advance.
I don’t believe they sell a qnx version anymore.
This leaves Faircom and Empress
“Ian M. Zagorskih” <ianzag@novosoft.ru> wrote in message
news:8rurhg$jfp$1@inn.qnx.com…
we use Sybase SQL Anywhere 5.5 as local sql server for data storage
and
it works well even on 486dx4-100Mz 16Mb RAM. more that, ram size maybe
about
4mb or even less.
advantages:
- larget set of nice features like database encription, transactions
log and so on.
- server is supported under several platforms including win16/32,
os/2,
qnx4, linux
- database format is the same for all supported platforms so you can
use same database file for example under winnt and qnx4. when nt server is
crashed [as usually] you can recover valuable database from qnx4 box >
- look at the server documentation >
disadvantages:
- linking odbc libraties with your program adds about 150Kb to target
image + shared libraries are not supported
- high enough price
- afaik server hasn’t been supported by watcom/sybase for several
years
and there’s no perspectives for future development >
hints for better server productivity:
- start server (dbsrv50) with transaction logging, it adds a “little”
transaction log but also incleases update/delete/… sql operations speed
- increase page size to 4096 bytes for large databases
- i would strongly recommend to move databas file on separate
partition
or even hard drive if it’s possibly of couse. even using two partitions -
one for qnx4 system and another for database file decreases disk overload
dramatically. using separate partition also solves some security and
database file integrity problems.
- anyway, allocate database file as large as you think it might be.
if
due to your calculations database may need about 2000 pages - make your
database large enough at the creation moment, don’t let server to add
aditional needed pages in runtime. reason is very easy - creating one
large
file at the initialization phase it is probably allocated much more
linearry
then adding pages during database grouth. qfs usually is highly fragmented
and in general imho wasn’t designed for large files manipulations.
my a little resume:
watcom sql anywhere 5.5 server is fast, resource safety and roubish
enough, has good enough documentation and at least was used/tested by many
qnx4 users > 
enjoy
Ian M. Zagorskih
Software Developer
Novosoft CyBearNet Department
Custom software development and web design since 1992
Phone: +7 (3832) 39-72-60
Fax: +7 (3832) 39-63-58
E-mail: > ianzag@novosoft.ru
For more visit > http://www.novosoft.ru/
“Sylvain Guillemette” <> sguillemette@akitek.com> > wrote in message
news:8rla8l$511$> 1@inn.qnx.com> …
Hi all, I would like to know if somebody works with a database under
QNX.
I
take a look on some proposed by the QNX Web site but I would like to
have
an
idea from an end user.
I would like to create a application with a database that maybe can
interact
with other OS to create reports for exemple. My QNX application can
made
the processing and collecting data via the database and we will be
interest
to made reports with these data on another application.
Thanks in advance.
\
not sure about sybase, but at least russian dealer “swd real-time systems”
sales it without any problems:
http://www.qnx.ru/prices/qnx3107.htm
// wbr
Ian M. Zagorskih
Software Developer
Novosoft CyBearNet Department
Custom software development and web design since 1992
Phone: +7 (3832) 39-72-60
Fax: +7 (3832) 39-63-58
E-mail: ianzag@novosoft.ru
For more visit http://www.novosoft.ru/
“Richard Lyon” <rlyon01@ozemail.com.au> wrote in message
news:8s3olt$76m$1@inn.qnx.com…
I don’t believe they sell a qnx version anymore.
This leaves Faircom and Empress
“Ian M. Zagorskih” <> ianzag@novosoft.ru> > wrote in message
news:8rurhg$jfp$> 1@inn.qnx.com> …
we use Sybase SQL Anywhere 5.5 as local sql server for data storage
and
it works well even on 486dx4-100Mz 16Mb RAM. more that, ram size maybe
about
4mb or even less.
advantages:
- larget set of nice features like database encription,
transactions
log and so on.
- server is supported under several platforms including win16/32,
os/2,
qnx4, linux
- database format is the same for all supported platforms so you
can
use same database file for example under winnt and qnx4. when nt server
is
crashed [as usually] you can recover valuable database from qnx4 box >
- look at the server documentation >
disadvantages:
- linking odbc libraties with your program adds about 150Kb to
target
image + shared libraries are not supported
- high enough price
- afaik server hasn’t been supported by watcom/sybase for several
years
and there’s no perspectives for future development >
hints for better server productivity:
- start server (dbsrv50) with transaction logging, it adds a
“little”
transaction log but also incleases update/delete/… sql operations speed
- increase page size to 4096 bytes for large databases
- i would strongly recommend to move databas file on separate
partition
or even hard drive if it’s possibly of couse. even using two
partitions -
one for qnx4 system and another for database file decreases disk
overload
dramatically. using separate partition also solves some security and
database file integrity problems.
- anyway, allocate database file as large as you think it might be.
if
due to your calculations database may need about 2000 pages - make your
database large enough at the creation moment, don’t let server to add
aditional needed pages in runtime. reason is very easy - creating one
large
file at the initialization phase it is probably allocated much more
linearry
then adding pages during database grouth. qfs usually is highly
fragmented
and in general imho wasn’t designed for large files manipulations.
my a little resume:
watcom sql anywhere 5.5 server is fast, resource safety and roubish
enough, has good enough documentation and at least was used/tested by
many
qnx4 users > 
enjoy
Ian M. Zagorskih
Software Developer
Novosoft CyBearNet Department
Custom software development and web design since 1992
Phone: +7 (3832) 39-72-60
Fax: +7 (3832) 39-63-58
E-mail: > ianzag@novosoft.ru
For more visit > http://www.novosoft.ru/
“Sylvain Guillemette” <> sguillemette@akitek.com> > wrote in message
news:8rla8l$511$> 1@inn.qnx.com> …
Hi all, I would like to know if somebody works with a database under
QNX.
I
take a look on some proposed by the QNX Web site but I would like to
have
an
idea from an end user.
I would like to create a application with a database that maybe can
interact
with other OS to create reports for exemple. My QNX application can
made
the processing and collecting data via the database and we will be
interest
to made reports with these data on another application.
Thanks in advance.
\
There’s also Centurasoft, formerly Raima. They’ve ported their Velocis server
to QNX.
Richard Lyon wrote:
I don’t believe they sell a qnx version anymore.
This leaves Faircom and Empress
–
I wasn’t kissing her, I was whispering in her mouth.
– Chico Marx
Checked with these guys and they don’t support QNX anymore.
“Bruce Edge” <bedge@sattel.com> wrote in message
news:39E5DC42.E9EC7331@sattel.com…
There’s also Centurasoft, formerly Raima. They’ve ported their Velocis
server
to QNX.
Richard Lyon wrote:
I don’t believe they sell a qnx version anymore.
This leaves Faircom and Empress
–
I wasn’t kissing her, I was whispering in her mouth.
– Chico Marx