database

QNX Newsgroups (Archives) qdn.public.qnx4
1

I’m looking for a database program for QNX 4.25. I want to be able to take
raw transaction data, on the order of 1 million records of 500 bytes or so,
with a few dozen fields, and put it into this database, to allow for various
queries based on the fields. This would be mainly for debugging purposes, as
the “real” database runs on Windows NT on a “real” computer. Share or
freeware would be nice, but we can afford to pay a modest price as well. Any
suggestions would be appreciated.

Thanks,

Kevin
kevin.miller@transcore.com

2

Kevin Miller wrote:

I’m looking for a database program for QNX 4.25. I want to be able to take
raw transaction data, on the order of 1 million records of 500 bytes or so,
with a few dozen fields, and put it into this database, to allow for various
queries based on the fields. This would be mainly for debugging purposes, as
the “real” database runs on Windows NT on a “real” computer. Share or
freeware would be nice, but we can afford to pay a modest price as well. Any
suggestions would be appreciated.

I know that Empress creates an RDBMS that runs on QNX amongst others.
Sybase did have a RDBMS but have stopped supporting it.
Prehaps, you could find PosgreSQL (www.postgres.org) compiled for QNX 4.25.
Have heard somewhere that it exists but I’ve never gone looking for it.

Regards,
Joachim Holst

3

“Joachim Holst” <joachim.holst@obducat.com> wrote in message
news:asfu2f$olj$1@inn.qnx.com…

Kevin Miller wrote:
I’m looking for a database program for QNX 4.25. I want to be able to
take
raw transaction data, on the order of 1 million records of 500 bytes or
so,
with a few dozen fields, and put it into this database, to allow for
various
queries based on the fields. This would be mainly for debugging
purposes, as
the “real” database runs on Windows NT on a “real” computer. Share or
freeware would be nice, but we can afford to pay a modest price as well.
Any
suggestions would be appreciated.

I know that Empress creates an RDBMS that runs on QNX amongst others.
Sybase did have a RDBMS but have stopped supporting it.
Prehaps, you could find PosgreSQL (> www.postgres.org> ) compiled for QNX
4.25.
Have heard somewhere that it exists but I’ve never gone looking for it.

Regards,
Joachim Holst

I use it last 12 month on QNX4 with PHP 4 and seams that work ok
Butt notice that there is’t stored procedure and trigger support
because QNX4 don’t support shared object.
Second, in my compilation I don’t have real int8 support!
I compile it with Watcom 10.6. witch don’t have long long type butt this
was the fastest way to
interface it with my Watcom C application

Best Regards,
Ernest Simunic

4

I’m a great fan of Sybase (Watcom) SQL Anywhere. Unfortunately they decided
not to support QNX anymore. However, at least SW Datentechnik in Germany
still sells version 5 for QNX and the price (server around 300 USD, extra
clients 150 USD) is not (in my mind) bad although otherwise I could have
something to say about their service. But if you exactly know, what you
need, you will get it. Already version 5 has both procedures and triggers
and the SQL language is very well according to the standard. Maybe in your
case also a discontinued product is an option.

  • easy to administer (really out of the box product), standard language,
    lot of features, stable, small, (fast)
  • no development or support anymore for QNX, hard to find

I would be very interested if someone could tell how Postgress works for
QNX4. For me it looks like a possible replacement for SQL Anywhere because
how much I like it, I cannot live forever with a dead product. I haven’t
tried it and according to the documentation it doesn’t look that easy to
manage as SQL Anywhere but the basic SQL language seems to be very much
like in Anywhere. I’m not sure if Mr. Simunic meant Postgress, when telling
about the lack of procedures and triggers?

  • free, standard language
  • stability of QNX version?, easiness of administration?, lack of
    procedures and triggers in QNX4?

Empress looks to be quite special database engine especially for embedded
purposes. For me the SQL language looks quite different compared to
standard SQL beginning from the schema definition statements.

  • efficient?
  • non-standard language, hard to administer?

Does ‘raw transaction data’ mean that you take a snaphot of the ‘real’
database table and put that data into a single table in the debug database
or are you filling the debug database in real time? In the first case you
would manage with a single SQL Anywhere license (network server or
standalone engine, I don’t think there is price difference), in the second
you need the network server plus one client license and client software for
the respective platform.
Restrictions of the SQL Anywhere 5 are 999 columns per table and 2 GB file
size (12 files per database maximum). Number of rows as well as the row
size are limited by the file size, so the amount of data you need should
fit there.

Let me know if you have more questions. I can try to help concerning SQL
Anywhere. Hope that also people knowing more about Postgress and Empress
take further part into the discussion.

On Mon, 2 Dec 2002 09:04:06 -0500, Kevin Miller <kevin.miller@transcore.com>
wrote:

I’m looking for a database program for QNX 4.25. I want to be able to
take
raw transaction data, on the order of 1 million records of 500 bytes or
so,
with a few dozen fields, and put it into this database, to allow for
various
queries based on the fields. This would be mainly for debugging purposes,
as
the “real” database runs on Windows NT on a “real” computer. Share or
freeware would be nice, but we can afford to pay a modest price as well.
Any
suggestions would be appreciated.

Thanks,

Kevin
kevin.miller@transcore.com
\

–
Juho Joensuu

5

Juho Joensuu wrote:

Empress looks to be quite special database engine especially for
embedded purposes. For me the SQL language looks quite different
compared to standard SQL beginning from the schema definition statements.

  • efficient?
  • non-standard language, hard to administer?

We’ve had some dealings with Empress and I’ve got to say one more thing to
their advantage is, they have great support. At lest it was like that for us.

Regards,
Joachim Holst

6

I was able to compile and run Postgres 7.2.3 with very little work under QNX
4.25, using gcc and bash. 7.3 would not compile, and it looks like the guy
who ported Postgres to QNX hasn’t gotten around to 7.3 yet, so I am sticking
with 7.2.3.

“Joachim Holst” <joachim.holst@obducat.com> wrote in message
news:asn1ms$sct$1@inn.qnx.com…

Juho Joensuu wrote:

Empress looks to be quite special database engine especially for
embedded purposes. For me the SQL language looks quite different
compared to standard SQL beginning from the schema definition
statements.

  • efficient?
  • non-standard language, hard to administer?


    We’ve had some dealings with Empress and I’ve got to say one more thing to
    their advantage is, they have great support. At lest it was like that for
    us.

Regards,
Joachim Holst

7

Having been away a while. Just curious, how about procedures and triggers?

juho

On Mon, 9 Dec 2002 12:42:22 -0500, Kevin Miller <kevin.miller@transcore.com>
wrote:

I was able to compile and run Postgres 7.2.3 with very little work under
QNX
4.25, using gcc and bash. 7.3 would not compile, and it looks like the
guy
who ported Postgres to QNX hasn’t gotten around to 7.3 yet, so I am
sticking
with 7.2.3.

“Joachim Holst” <> joachim.holst@obducat.com> > wrote in message
news:asn1ms$sct$> 1@inn.qnx.com> …
Juho Joensuu wrote:

Empress looks to be quite special database engine especially for
embedded purposes. For me the SQL language looks quite different
compared to standard SQL beginning from the schema definition
statements.

  • efficient?
  • non-standard language, hard to administer?


    We’ve had some dealings with Empress and I’ve got to say one more thing
    to
    their advantage is, they have great support. At lest it was like that
    for
    us.

Regards,
Joachim Holst

\

–
Juho Joensuu