Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Need recommendations for a database

11 posts in Commercial ISV's Last posting was on 2008-02-01 20:59:03.0Z
Ken Judkins Posted on 2008-01-30 02:12:19.0Z
From: "Ken Judkins" <nospam@nospam.com>
Newsgroups: sybase.public.commercial-isv.general
Subject: Need recommendations for a database
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1914
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <479fdd03$1@forums-1-dub>
Date: 29 Jan 2008 18:12:19 -0800
X-Trace: forums-1-dub 1201659139 10.22.241.152 (29 Jan 2008 18:12:19 -0800)
X-Original-Trace: 29 Jan 2008 18:12:19 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:5
Article PK: 103726

I'd like to write an application I can sell on the Internet.
Recommendations for the database would be appreciated. The criteria for the
database would be:
1. Free to distribute in a commercial application.
2. Plays well with Powerbuilder 9 Enterprise (and eventually PB 11).
3. Small footprint on customer PC.
4. Allows more than one database on the customer PC.
5. Can be installed automatically as part of the application installation.
6. Allows me to add a table or add/alter table columns using SQL from
within the application.

The database within PowerBuilder meets the first five requirements.
However, if I need to send out an update that includes a new column on an
existing table, I cannot use the ALTER TABLE ADD COLUMN command from within
the application. I'm forever stuck with the original database structure.

I do not see a need for stored procedures or other fancy features.

Thanks in advance!

Ken Judkins


Richard Keller Posted on 2008-01-30 02:22:14.0Z
From: "Richard Keller" <richard@kellersystems.com>
Newsgroups: sybase.public.commercial-isv.general
References: <479fdd03$1@forums-1-dub>
Subject: Re: Need recommendations for a database
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <479fdf56$1@forums-1-dub>
Date: 29 Jan 2008 18:22:14 -0800
X-Trace: forums-1-dub 1201659734 10.22.241.152 (29 Jan 2008 18:22:14 -0800)
X-Original-Trace: 29 Jan 2008 18:22:14 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:6
Article PK: 103728

Microsoft SQL Express is my personal recommendation. It automatically
scales to Enterprise Databases and you have all the power you'll ever need.
It's free and the only limitation is DB size.

Richard

"Ken Judkins" <nospam@nospam.com> wrote in message
news:479fdd03$1@forums-1-dub...
> I'd like to write an application I can sell on the Internet.
> Recommendations for the database would be appreciated. The criteria for
> the
> database would be:
> 1. Free to distribute in a commercial application.
> 2. Plays well with Powerbuilder 9 Enterprise (and eventually PB 11).
> 3. Small footprint on customer PC.
> 4. Allows more than one database on the customer PC.
> 5. Can be installed automatically as part of the application
> installation.
> 6. Allows me to add a table or add/alter table columns using SQL from
> within the application.
>
> The database within PowerBuilder meets the first five requirements.
> However, if I need to send out an update that includes a new column on an
> existing table, I cannot use the ALTER TABLE ADD COLUMN command from
> within
> the application. I'm forever stuck with the original database structure.
>
> I do not see a need for stored procedures or other fancy features.
>
> Thanks in advance!
>
> Ken Judkins
>
>
>
>
>
>


Jeff Gibson Posted on 2008-01-30 05:51:46.0Z
Reply-To: "Jeff Gibson" <jgibson@interceptsolutions.com>
From: "Jeff Gibson" <jgibson@interceptsolutions.com>
Newsgroups: sybase.public.commercial-isv.general
References: <479fdd03$1@forums-1-dub>
Subject: Re: Need recommendations for a database
Lines: 69
Organization: Intercept Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47a01072$1@forums-1-dub>
Date: 29 Jan 2008 21:51:46 -0800
X-Trace: forums-1-dub 1201672306 10.22.241.152 (29 Jan 2008 21:51:46 -0800)
X-Original-Trace: 29 Jan 2008 21:51:46 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:7
Article PK: 103730

Ken,

You have some great ideas. I would think your number 6 item would be a good
item to bounce off of Sybase. (HEY Mike Paola!)

There are a multitude of free database solutions that are out there that
allow the deployer of a product to run DDL statements against their
database. As you know, Sybase's SQL Anywhere runtime engine does not allow
this. Along with not allowing triggers, stored procedures, transaction
logs, etc.

My question to Sybase would be this. What if Sybase did allow for DDL
within the runtime version of SQL Anywhere. I'm not saying throw all the
available options into the runtime version. Just allow DDL statements
against the database to allow scheme modifications. (I'm not sure if the
log file is required for scheme changes or not).

IMHO, this would get SQL Anywhere implemented in products that it hasn't up
until now, because of the fact you can't update the scheme. Not to mention
that a percentage of that group would eventually move to the full version of
SQL Anywhere, because they would start to see the benefits of the full
version of the database.

There are a LOT of small commercial products out there, and if Sybase
tweaked their runtime engine to allow for DDL, they could really show off
what a great product SQL Anywhere is to a large contingent of small shops.
That in turn could really increase profits for Sybase since their not
getting these shops anyways due to the limitations of the runtime engine.

As for your number 4 item (sorry I'm going backwards), you mention that you
would like to have more than one database on the customer PC. Would this be
similar to a QuickBooks style setup? If a user wants to create a new
company, it automatically generates a new database file for that company.
Just curious. Is that another limitation of the runtime engine?

Thanks for the post Ken. Any Sybase feedback would be greatly appreciated!!

Jeff Gibson
Intercept Solutions - Sybase SQL Anywhere OEM Partner
Nashville, TN

"Ken Judkins" <nospam@nospam.com> wrote in message
news:479fdd03$1@forums-1-dub...
> I'd like to write an application I can sell on the Internet.
> Recommendations for the database would be appreciated. The criteria for
> the
> database would be:
> 1. Free to distribute in a commercial application.
> 2. Plays well with Powerbuilder 9 Enterprise (and eventually PB 11).
> 3. Small footprint on customer PC.
> 4. Allows more than one database on the customer PC.
> 5. Can be installed automatically as part of the application
> installation.
> 6. Allows me to add a table or add/alter table columns using SQL from
> within the application.
>
> The database within PowerBuilder meets the first five requirements.
> However, if I need to send out an update that includes a new column on an
> existing table, I cannot use the ALTER TABLE ADD COLUMN command from
> within
> the application. I'm forever stuck with the original database structure.
>
> I do not see a need for stored procedures or other fancy features.
>
> Thanks in advance!
>
> Ken Judkins


Ken Judkins Posted on 2008-01-30 18:42:19.0Z
From: "Ken Judkins" <nospam@nospam.com>
Newsgroups: sybase.public.commercial-isv.general
References: <479fdd03$1@forums-1-dub> <47a01072$1@forums-1-dub>
Subject: Re: Need recommendations for a database
Lines: 103
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47a0c50b@forums-1-dub>
Date: 30 Jan 2008 10:42:19 -0800
X-Trace: forums-1-dub 1201718539 10.22.241.152 (30 Jan 2008 10:42:19 -0800)
X-Original-Trace: 30 Jan 2008 10:42:19 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:8
Article PK: 103729

Jeff,

#6: I wholeheartedly agree with your assessment of the DDL in SQL Anywhere.
If I had that, I wouldn't need to look beyond what came on the CD for most
stand-alone applications. Sybase may be missing an opportunity here,
because an office that upgrades to multiple seats of an application is going
to buy the database that came with the single-seat version. So long as the
prices are fairly comparable and no other database is already in use, most
small offices won't care so long as the job gets done.

#4: I'd like to have the ability to put multiple databases on a single PC
because I'm optimistic that people will want more than one of my
applications! I downloaded Oracle Express and it is nice, but one of the
restrictions is a single database per machine. If I wanted to allow an
application to be ported to another machine, splitting it out from the one
database would be a lot of unnecessary work. Oracle Express has its place,
such as if the original design was for a multiple-seat application and a
dedicated PC/server is available.

The projects that have sparked my interest at this time just happen to be
meant for home PCs, which defined the criteria I supplied.

I'm going to like this newsgroup!

Ken

"Jeff Gibson" <jgibson@interceptsolutions.com> wrote in message
news:47a01072$1@forums-1-dub...
> Ken,
>
> You have some great ideas. I would think your number 6 item would be a
> good item to bounce off of Sybase. (HEY Mike Paola!)
>
> There are a multitude of free database solutions that are out there that
> allow the deployer of a product to run DDL statements against their
> database. As you know, Sybase's SQL Anywhere runtime engine does not
> allow this. Along with not allowing triggers, stored procedures,
> transaction logs, etc.
>
> My question to Sybase would be this. What if Sybase did allow for DDL
> within the runtime version of SQL Anywhere. I'm not saying throw all the
> available options into the runtime version. Just allow DDL statements
> against the database to allow scheme modifications. (I'm not sure if the
> log file is required for scheme changes or not).
>
> IMHO, this would get SQL Anywhere implemented in products that it hasn't
> up until now, because of the fact you can't update the scheme. Not to
> mention that a percentage of that group would eventually move to the full
> version of SQL Anywhere, because they would start to see the benefits of
> the full version of the database.
>
> There are a LOT of small commercial products out there, and if Sybase
> tweaked their runtime engine to allow for DDL, they could really show off
> what a great product SQL Anywhere is to a large contingent of small shops.
> That in turn could really increase profits for Sybase since their not
> getting these shops anyways due to the limitations of the runtime engine.
>
> As for your number 4 item (sorry I'm going backwards), you mention that
> you would like to have more than one database on the customer PC. Would
> this be similar to a QuickBooks style setup? If a user wants to create a
> new company, it automatically generates a new database file for that
> company. Just curious. Is that another limitation of the runtime engine?
>
> Thanks for the post Ken. Any Sybase feedback would be greatly
> appreciated!!
>
> Jeff Gibson
> Intercept Solutions - Sybase SQL Anywhere OEM Partner
> Nashville, TN
>
> "Ken Judkins" <nospam@nospam.com> wrote in message
> news:479fdd03$1@forums-1-dub...
>> I'd like to write an application I can sell on the Internet.
>> Recommendations for the database would be appreciated. The criteria for
>> the
>> database would be:
>> 1. Free to distribute in a commercial application.
>> 2. Plays well with Powerbuilder 9 Enterprise (and eventually PB 11).
>> 3. Small footprint on customer PC.
>> 4. Allows more than one database on the customer PC.
>> 5. Can be installed automatically as part of the application
>> installation.
>> 6. Allows me to add a table or add/alter table columns using SQL from
>> within the application.
>>
>> The database within PowerBuilder meets the first five requirements.
>> However, if I need to send out an update that includes a new column on an
>> existing table, I cannot use the ALTER TABLE ADD COLUMN command from
>> within
>> the application. I'm forever stuck with the original database structure.
>>
>> I do not see a need for stored procedures or other fancy features.
>>
>> Thanks in advance!
>>
>> Ken Judkins
>
>


Roland Smith [TeamSybase] Posted on 2008-01-31 18:08:38.0Z
From: "Roland Smith [TeamSybase]" <rsmith_at_trusthss_dot_com>
Newsgroups: sybase.public.commercial-isv.general
References: <479fdd03$1@forums-1-dub> <47a01072$1@forums-1-dub> <47a0c50b@forums-1-dub>
Subject: Re: Need recommendations for a database
Lines: 114
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47a20ea6$1@forums-1-dub>
Date: 31 Jan 2008 10:08:38 -0800
X-Trace: forums-1-dub 1201802918 10.22.241.152 (31 Jan 2008 10:08:38 -0800)
X-Original-Trace: 31 Jan 2008 10:08:38 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:15
Article PK: 103737

I don't believe there is a limitation in SQLAnywhere as far as number of
separate database files.

"Ken Judkins" <nospam@nospam.com> wrote in message
news:47a0c50b@forums-1-dub...
> Jeff,
>
> #6: I wholeheartedly agree with your assessment of the DDL in SQL
> Anywhere. If I had that, I wouldn't need to look beyond what came on the
> CD for most stand-alone applications. Sybase may be missing an
> opportunity here, because an office that upgrades to multiple seats of an
> application is going to buy the database that came with the single-seat
> version. So long as the prices are fairly comparable and no other
> database is already in use, most small offices won't care so long as the
> job gets done.
>
> #4: I'd like to have the ability to put multiple databases on a single PC
> because I'm optimistic that people will want more than one of my
> applications! I downloaded Oracle Express and it is nice, but one of the
> restrictions is a single database per machine. If I wanted to allow an
> application to be ported to another machine, splitting it out from the one
> database would be a lot of unnecessary work. Oracle Express has its
> place, such as if the original design was for a multiple-seat application
> and a dedicated PC/server is available.
>
> The projects that have sparked my interest at this time just happen to be
> meant for home PCs, which defined the criteria I supplied.
>
> I'm going to like this newsgroup!
>
> Ken
>
>
>
>
> "Jeff Gibson" <jgibson@interceptsolutions.com> wrote in message
> news:47a01072$1@forums-1-dub...
>> Ken,
>>
>> You have some great ideas. I would think your number 6 item would be a
>> good item to bounce off of Sybase. (HEY Mike Paola!)
>>
>> There are a multitude of free database solutions that are out there that
>> allow the deployer of a product to run DDL statements against their
>> database. As you know, Sybase's SQL Anywhere runtime engine does not
>> allow this. Along with not allowing triggers, stored procedures,
>> transaction logs, etc.
>>
>> My question to Sybase would be this. What if Sybase did allow for DDL
>> within the runtime version of SQL Anywhere. I'm not saying throw all the
>> available options into the runtime version. Just allow DDL statements
>> against the database to allow scheme modifications. (I'm not sure if the
>> log file is required for scheme changes or not).
>>
>> IMHO, this would get SQL Anywhere implemented in products that it hasn't
>> up until now, because of the fact you can't update the scheme. Not to
>> mention that a percentage of that group would eventually move to the full
>> version of SQL Anywhere, because they would start to see the benefits of
>> the full version of the database.
>>
>> There are a LOT of small commercial products out there, and if Sybase
>> tweaked their runtime engine to allow for DDL, they could really show off
>> what a great product SQL Anywhere is to a large contingent of small
>> shops. That in turn could really increase profits for Sybase since their
>> not getting these shops anyways due to the limitations of the runtime
>> engine.
>>
>> As for your number 4 item (sorry I'm going backwards), you mention that
>> you would like to have more than one database on the customer PC. Would
>> this be similar to a QuickBooks style setup? If a user wants to create a
>> new company, it automatically generates a new database file for that
>> company. Just curious. Is that another limitation of the runtime engine?
>>
>> Thanks for the post Ken. Any Sybase feedback would be greatly
>> appreciated!!
>>
>> Jeff Gibson
>> Intercept Solutions - Sybase SQL Anywhere OEM Partner
>> Nashville, TN
>>
>> "Ken Judkins" <nospam@nospam.com> wrote in message
>> news:479fdd03$1@forums-1-dub...
>>> I'd like to write an application I can sell on the Internet.
>>> Recommendations for the database would be appreciated. The criteria for
>>> the
>>> database would be:
>>> 1. Free to distribute in a commercial application.
>>> 2. Plays well with Powerbuilder 9 Enterprise (and eventually PB 11).
>>> 3. Small footprint on customer PC.
>>> 4. Allows more than one database on the customer PC.
>>> 5. Can be installed automatically as part of the application
>>> installation.
>>> 6. Allows me to add a table or add/alter table columns using SQL from
>>> within the application.
>>>
>>> The database within PowerBuilder meets the first five requirements.
>>> However, if I need to send out an update that includes a new column on
>>> an
>>> existing table, I cannot use the ALTER TABLE ADD COLUMN command from
>>> within
>>> the application. I'm forever stuck with the original database
>>> structure.
>>>
>>> I do not see a need for stored procedures or other fancy features.
>>>
>>> Thanks in advance!
>>>
>>> Ken Judkins
>>
>>
>
>


Richard Keller Posted on 2008-01-30 20:08:54.0Z
From: "Richard Keller" <richard@kellersystems.com>
Newsgroups: sybase.public.commercial-isv.general
References: <479fdd03$1@forums-1-dub> <47a01072$1@forums-1-dub>
Subject: Re: Need recommendations for a database
Lines: 80
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47a0d956$1@forums-1-dub>
Date: 30 Jan 2008 12:08:54 -0800
X-Trace: forums-1-dub 1201723734 10.22.241.152 (30 Jan 2008 12:08:54 -0800)
X-Original-Trace: 30 Jan 2008 12:08:54 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:9
Article PK: 103731

I agree with Jeff hear SQL Anywhere is the best little database that Watcom
ever had. Those limitations make it difficult to be a recommendation for a
project like Ken's.

Richard

"Jeff Gibson" <jgibson@interceptsolutions.com> wrote in message
news:47a01072$1@forums-1-dub...
> Ken,
>
> You have some great ideas. I would think your number 6 item would be a
> good item to bounce off of Sybase. (HEY Mike Paola!)
>
> There are a multitude of free database solutions that are out there that
> allow the deployer of a product to run DDL statements against their
> database. As you know, Sybase's SQL Anywhere runtime engine does not
> allow this. Along with not allowing triggers, stored procedures,
> transaction logs, etc.
>
> My question to Sybase would be this. What if Sybase did allow for DDL
> within the runtime version of SQL Anywhere. I'm not saying throw all the
> available options into the runtime version. Just allow DDL statements
> against the database to allow scheme modifications. (I'm not sure if the
> log file is required for scheme changes or not).
>
> IMHO, this would get SQL Anywhere implemented in products that it hasn't
> up until now, because of the fact you can't update the scheme. Not to
> mention that a percentage of that group would eventually move to the full
> version of SQL Anywhere, because they would start to see the benefits of
> the full version of the database.
>
> There are a LOT of small commercial products out there, and if Sybase
> tweaked their runtime engine to allow for DDL, they could really show off
> what a great product SQL Anywhere is to a large contingent of small shops.
> That in turn could really increase profits for Sybase since their not
> getting these shops anyways due to the limitations of the runtime engine.
>
> As for your number 4 item (sorry I'm going backwards), you mention that
> you would like to have more than one database on the customer PC. Would
> this be similar to a QuickBooks style setup? If a user wants to create a
> new company, it automatically generates a new database file for that
> company. Just curious. Is that another limitation of the runtime engine?
>
> Thanks for the post Ken. Any Sybase feedback would be greatly
> appreciated!!
>
> Jeff Gibson
> Intercept Solutions - Sybase SQL Anywhere OEM Partner
> Nashville, TN
>
> "Ken Judkins" <nospam@nospam.com> wrote in message
> news:479fdd03$1@forums-1-dub...
>> I'd like to write an application I can sell on the Internet.
>> Recommendations for the database would be appreciated. The criteria for
>> the
>> database would be:
>> 1. Free to distribute in a commercial application.
>> 2. Plays well with Powerbuilder 9 Enterprise (and eventually PB 11).
>> 3. Small footprint on customer PC.
>> 4. Allows more than one database on the customer PC.
>> 5. Can be installed automatically as part of the application
>> installation.
>> 6. Allows me to add a table or add/alter table columns using SQL from
>> within the application.
>>
>> The database within PowerBuilder meets the first five requirements.
>> However, if I need to send out an update that includes a new column on an
>> existing table, I cannot use the ALTER TABLE ADD COLUMN command from
>> within
>> the application. I'm forever stuck with the original database structure.
>>
>> I do not see a need for stored procedures or other fancy features.
>>
>> Thanks in advance!
>>
>> Ken Judkins
>
>


Jim O'Neil [Sybase] Posted on 2008-02-01 02:09:51.0Z
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Newsgroups: sybase.public.commercial-isv.general
Subject: Re: Need recommendations for a database
Message-ID: <hfv4q3lmbp169ge2q19aukmsstta5g59c5@4ax.com>
References: <479fdd03$1@forums-1-dub> <47a01072$1@forums-1-dub>
X-Newsreader: Forte Agent 4.2/32.1118
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 31 Jan 2008 18:09:51 -0800
X-Trace: forums-1-dub 1201831791 10.22.241.152 (31 Jan 2008 18:09:51 -0800)
X-Original-Trace: 31 Jan 2008 18:09:51 -0800, vip152.sybase.com
Lines: 86
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:20
Article PK: 103742

My take from some of the folks in iAnywhere is that they are really
deemphasizing the runtime engine... try finding any info on it or its
restrictions on the Sybase site, for instance. My understanding is
that PB/IM is one of the few sets of products that are still including
this.

I'm not that tuned into the direction of SQL Anywhere, but I suspect
this isn't going to happen. I don't know though if they have other
ideas in play that would still fulfill your goal here.

In terms of DDL statements, I ran into this issue myself with a small
app I wrote for a non-profit. I had to write a small program that
essentially transferred from on DB to the new one with the additional
fields, etc. Tedious but not rocket science.

On 29 Jan 2008 21:51:46 -0800, "Jeff Gibson"

<jgibson@interceptsolutions.com> wrote:

>Ken,
>
>You have some great ideas. I would think your number 6 item would be a good
>item to bounce off of Sybase. (HEY Mike Paola!)
>
>There are a multitude of free database solutions that are out there that
>allow the deployer of a product to run DDL statements against their
>database. As you know, Sybase's SQL Anywhere runtime engine does not allow
>this. Along with not allowing triggers, stored procedures, transaction
>logs, etc.
>
>My question to Sybase would be this. What if Sybase did allow for DDL
>within the runtime version of SQL Anywhere. I'm not saying throw all the
>available options into the runtime version. Just allow DDL statements
>against the database to allow scheme modifications. (I'm not sure if the
>log file is required for scheme changes or not).
>
>IMHO, this would get SQL Anywhere implemented in products that it hasn't up
>until now, because of the fact you can't update the scheme. Not to mention
>that a percentage of that group would eventually move to the full version of
>SQL Anywhere, because they would start to see the benefits of the full
>version of the database.
>
>There are a LOT of small commercial products out there, and if Sybase
>tweaked their runtime engine to allow for DDL, they could really show off
>what a great product SQL Anywhere is to a large contingent of small shops.
>That in turn could really increase profits for Sybase since their not
>getting these shops anyways due to the limitations of the runtime engine.
>
>As for your number 4 item (sorry I'm going backwards), you mention that you
>would like to have more than one database on the customer PC. Would this be
>similar to a QuickBooks style setup? If a user wants to create a new
>company, it automatically generates a new database file for that company.
>Just curious. Is that another limitation of the runtime engine?
>
>Thanks for the post Ken. Any Sybase feedback would be greatly appreciated!!
>
>Jeff Gibson
>Intercept Solutions - Sybase SQL Anywhere OEM Partner
>Nashville, TN
>
>"Ken Judkins" <nospam@nospam.com> wrote in message
>news:479fdd03$1@forums-1-dub...
>> I'd like to write an application I can sell on the Internet.
>> Recommendations for the database would be appreciated. The criteria for
>> the
>> database would be:
>> 1. Free to distribute in a commercial application.
>> 2. Plays well with Powerbuilder 9 Enterprise (and eventually PB 11).
>> 3. Small footprint on customer PC.
>> 4. Allows more than one database on the customer PC.
>> 5. Can be installed automatically as part of the application
>> installation.
>> 6. Allows me to add a table or add/alter table columns using SQL from
>> within the application.
>>
>> The database within PowerBuilder meets the first five requirements.
>> However, if I need to send out an update that includes a new column on an
>> existing table, I cannot use the ALTER TABLE ADD COLUMN command from
>> within
>> the application. I'm forever stuck with the original database structure.
>>
>> I do not see a need for stored procedures or other fancy features.
>>
>> Thanks in advance!
>>
>> Ken Judkins
>


M. Searer Posted on 2008-01-31 16:17:00.0Z
From: "M. Searer" <nospam@nospam.com>
Newsgroups: sybase.public.commercial-isv.general
References: <479fdd03$1@forums-1-dub>
Subject: Re: Need recommendations for a database
Lines: 68
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47a1f47c$1@forums-1-dub>
Date: 31 Jan 2008 08:17:00 -0800
X-Trace: forums-1-dub 1201796220 10.22.241.152 (31 Jan 2008 08:17:00 -0800)
X-Original-Trace: 31 Jan 2008 08:17:00 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:12
Article PK: 103734

Free 'real' databases include (in addition to MS SQL Express):
Oracle XE
Sybase ASE (Linux only - horrible to setup)
DB2 (lite? or whatever)
These, as well as SQL Express are limited in memory, database size etc.

Also, there are all of the open source ones, and things like MS Access.

Oracle tools are very lacking, but there are some really good low cost ones
available. It supports multiple schemas per instance, which are somewhat like
databases.
Oracle XE does work very well.

DB2 is the database I wish I didn't dislike. The way security works is (IMO)
just horrible.

ASE performance for my application is very poor - comes in dead last in
benchmarks (factor of 100 slower in some situations, and yes there is a case
open for it). I wish it was better.

SQL Anywhere is one that we just added to our supported line of databases. It
is probably my favorite, but I'm not as expert in it as I would like to be. In
our benchmarks in blows away ASE and is at least as fast as Oracle and SQL
Server.

IMO, Oracle and ASE are too difficult for a user to set up and/or administer.
SQL Express is a lot easier.

For an end-user database (not one that a DBA is needed full or part time) I
think Anywhere is the easiest and most controllable within an application.

Don't forget too that the free SQL Anywhere doesn't support triggers and stored
procedures.

"Ken Judkins" <nospam@nospam.com> wrote in message
news:479fdd03$1@forums-1-dub...
> I'd like to write an application I can sell on the Internet.
> Recommendations for the database would be appreciated. The criteria for the
> database would be:
> 1. Free to distribute in a commercial application.
> 2. Plays well with Powerbuilder 9 Enterprise (and eventually PB 11).
> 3. Small footprint on customer PC.
> 4. Allows more than one database on the customer PC.
> 5. Can be installed automatically as part of the application installation.
> 6. Allows me to add a table or add/alter table columns using SQL from
> within the application.
>
> The database within PowerBuilder meets the first five requirements.
> However, if I need to send out an update that includes a new column on an
> existing table, I cannot use the ALTER TABLE ADD COLUMN command from within
> the application. I'm forever stuck with the original database structure.
>
> I do not see a need for stored procedures or other fancy features.
>
> Thanks in advance!
>
> Ken Judkins
>
>
>
>
>
>


Hans Groeneveld Posted on 2008-02-01 10:02:14.0Z
From: "Hans Groeneveld" <h.groeneNOveld@tsdSPAM.nl>
Newsgroups: sybase.public.commercial-isv.general
References: <479fdd03$1@forums-1-dub>
Subject: Re: Need recommendations for a database
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.3959
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4133
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47a2ee26@forums-1-dub>
Date: 1 Feb 2008 02:02:14 -0800
X-Trace: forums-1-dub 1201860134 10.22.241.152 (1 Feb 2008 02:02:14 -0800)
X-Original-Trace: 1 Feb 2008 02:02:14 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:21
Article PK: 103744

#6. Maybe, you can export the data of the database, copy a new empty
database with the new table definitions and re-import the data.

Hans

"Ken Judkins" <nospam@nospam.com> wrote in message
news:479fdd03$1@forums-1-dub...
> I'd like to write an application I can sell on the Internet.
> Recommendations for the database would be appreciated. The criteria for
> the
> database would be:
> 1. Free to distribute in a commercial application.
> 2. Plays well with Powerbuilder 9 Enterprise (and eventually PB 11).
> 3. Small footprint on customer PC.
> 4. Allows more than one database on the customer PC.
> 5. Can be installed automatically as part of the application
> installation.
> 6. Allows me to add a table or add/alter table columns using SQL from
> within the application.
>
> The database within PowerBuilder meets the first five requirements.
> However, if I need to send out an update that includes a new column on an
> existing table, I cannot use the ALTER TABLE ADD COLUMN command from
> within
> the application. I'm forever stuck with the original database structure.
>
> I do not see a need for stored procedures or other fancy features.
>
> Thanks in advance!
>
> Ken Judkins
>
>
>
>
>
>


Ken Judkins Posted on 2008-02-01 18:58:07.0Z
From: "Ken Judkins" <nospam@nospam.com>
Newsgroups: sybase.public.commercial-isv.general
References: <479fdd03$1@forums-1-dub> <47a2ee26@forums-1-dub>
Subject: Re: Need recommendations for a database
Lines: 56
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47a36bbf$1@forums-1-dub>
Date: 1 Feb 2008 10:58:07 -0800
X-Trace: forums-1-dub 1201892287 10.22.241.152 (1 Feb 2008 10:58:07 -0800)
X-Original-Trace: 1 Feb 2008 10:58:07 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:23
Article PK: 103745

Hans,

I like the recommendations you and Jim (in another post) make. I really
like the cost, footprint, and flexibility in the little runtime database.
Copying the data from one database to an expanded version would not be too
difficult. I'd been looking at Firebird, but if I have to take the time to
learn the particulars, I could have just written this utility and moved on.

This is a great discussion!

Ken

"Hans Groeneveld" <h.groeneNOveld@tsdSPAM.nl> wrote in message
news:47a2ee26@forums-1-dub...
> #6. Maybe, you can export the data of the database, copy a new empty
> database with the new table definitions and re-import the data.
>
> Hans
>
> "Ken Judkins" <nospam@nospam.com> wrote in message
> news:479fdd03$1@forums-1-dub...
>> I'd like to write an application I can sell on the Internet.
>> Recommendations for the database would be appreciated. The criteria for
>> the
>> database would be:
>> 1. Free to distribute in a commercial application.
>> 2. Plays well with Powerbuilder 9 Enterprise (and eventually PB 11).
>> 3. Small footprint on customer PC.
>> 4. Allows more than one database on the customer PC.
>> 5. Can be installed automatically as part of the application
>> installation.
>> 6. Allows me to add a table or add/alter table columns using SQL from
>> within the application.
>>
>> The database within PowerBuilder meets the first five requirements.
>> However, if I need to send out an update that includes a new column on an
>> existing table, I cannot use the ALTER TABLE ADD COLUMN command from
>> within
>> the application. I'm forever stuck with the original database structure.
>>
>> I do not see a need for stored procedures or other fancy features.
>>
>> Thanks in advance!
>>
>> Ken Judkins
>>
>>
>>
>>
>>
>>
>
>


Jim O'Neil [Sybase] Posted on 2008-02-01 20:59:03.0Z
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Newsgroups: sybase.public.commercial-isv.general
Subject: Re: Need recommendations for a database
Message-ID: <uu17q35lunil38kblrocmcrnpbhm5hmb9h@4ax.com>
References: <479fdd03$1@forums-1-dub> <47a2ee26@forums-1-dub> <47a36bbf$1@forums-1-dub>
X-Newsreader: Forte Agent 4.2/32.1118
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 1 Feb 2008 12:59:03 -0800
X-Trace: forums-1-dub 1201899543 10.22.241.152 (1 Feb 2008 12:59:03 -0800)
X-Original-Trace: 1 Feb 2008 12:59:03 -0800, vip152.sybase.com
Lines: 62
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:26
Article PK: 103750

By the way, if it's not already obvious, the pipeline can work well
for this. The one downside that I've run into is referential
integrity... you have to really think about what order to do all this
in.

On 1 Feb 2008 10:58:07 -0800, "Ken Judkins" <nospam@nospam.com> wrote:

>Hans,
>
>I like the recommendations you and Jim (in another post) make. I really
>like the cost, footprint, and flexibility in the little runtime database.
>Copying the data from one database to an expanded version would not be too
>difficult. I'd been looking at Firebird, but if I have to take the time to
>learn the particulars, I could have just written this utility and moved on.
>
>This is a great discussion!
>
>Ken
>
>
>"Hans Groeneveld" <h.groeneNOveld@tsdSPAM.nl> wrote in message
>news:47a2ee26@forums-1-dub...
>> #6. Maybe, you can export the data of the database, copy a new empty
>> database with the new table definitions and re-import the data.
>>
>> Hans
>>
>> "Ken Judkins" <nospam@nospam.com> wrote in message
>> news:479fdd03$1@forums-1-dub...
>>> I'd like to write an application I can sell on the Internet.
>>> Recommendations for the database would be appreciated. The criteria for
>>> the
>>> database would be:
>>> 1. Free to distribute in a commercial application.
>>> 2. Plays well with Powerbuilder 9 Enterprise (and eventually PB 11).
>>> 3. Small footprint on customer PC.
>>> 4. Allows more than one database on the customer PC.
>>> 5. Can be installed automatically as part of the application
>>> installation.
>>> 6. Allows me to add a table or add/alter table columns using SQL from
>>> within the application.
>>>
>>> The database within PowerBuilder meets the first five requirements.
>>> However, if I need to send out an update that includes a new column on an
>>> existing table, I cannot use the ALTER TABLE ADD COLUMN command from
>>> within
>>> the application. I'm forever stuck with the original database structure.
>>>
>>> I do not see a need for stored procedures or other fancy features.
>>>
>>> Thanks in advance!
>>>
>>> Ken Judkins
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>