Working with a QNX database?

QNX Newsgroups (Archives) qdn.public.qnx4
1

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.

2

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.

3

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.

4

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:

  1. larget set of nice features like database encription, transactions
    log and so on.
  2. server is supported under several platforms including win16/32, os/2,
    qnx4, linux
  3. 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 :slight_smile:
  4. look at the server documentation :slight_smile:

disadvantages:

  1. linking odbc libraties with your program adds about 150Kb to target
    image + shared libraries are not supported
  2. high enough price
  3. afaik server hasn’t been supported by watcom/sybase for several years
    and there’s no perspectives for future development :frowning:

hints for better server productivity:

  1. start server (dbsrv50) with transaction logging, it adds a “little”
    transaction log but also incleases update/delete/… sql operations speed
  2. increase page size to 4096 bytes for large databases
  3. 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.
  4. 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 :slight_smile:

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.

5

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:

  1. larget set of nice features like database encription, transactions
    log and so on.
  2. server is supported under several platforms including win16/32,
    os/2,
    qnx4, linux
  3. 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 > :slight_smile:
  4. look at the server documentation > :slight_smile:

disadvantages:

  1. linking odbc libraties with your program adds about 150Kb to target
    image + shared libraries are not supported
  2. high enough price
  3. afaik server hasn’t been supported by watcom/sybase for several
    years
    and there’s no perspectives for future development > :frowning:

hints for better server productivity:

  1. start server (dbsrv50) with transaction logging, it adds a “little”
    transaction log but also incleases update/delete/… sql operations speed
  2. increase page size to 4096 bytes for large databases
  3. 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.
  4. 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 > :slight_smile:

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.
\

6

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:

  1. larget set of nice features like database encription,
    transactions
    log and so on.
  2. server is supported under several platforms including win16/32,
    os/2,
    qnx4, linux
  3. 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 > :slight_smile:
  4. look at the server documentation > :slight_smile:

disadvantages:

  1. linking odbc libraties with your program adds about 150Kb to
    target
    image + shared libraries are not supported
  2. high enough price
  3. afaik server hasn’t been supported by watcom/sybase for several
    years
    and there’s no perspectives for future development > :frowning:

hints for better server productivity:

  1. start server (dbsrv50) with transaction logging, it adds a
    “little”
    transaction log but also incleases update/delete/… sql operations speed
  2. increase page size to 4096 bytes for large databases
  3. 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.
  4. 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 > :slight_smile:

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.


\

7

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

8

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