Web hosting for Pervasive 9 applications??

[Database Administrator]

Does anyone know of a web hosting entity that explicitly offers
Pervasive 9 SQL database support "out of the box" (I've looked
extensively, but have not found any myself)??

I have a client with a PSQL9 desktop application that they would like
to host with unchanged mkd/ddf files (but obviously with a web
interface instead of a desktop interface) on the web and would like
something less than a full dedicated server hosting or server
colocation situation.

Ideally, the hosting entity would also support asp.net with all the
current bells and whistles (3.5 + WSE3, Silverlight, ...) but even
that is negotiable.

Thaks!

[Database Administrator]

If you want to access the same database as the application, you need
more than just a hosting service -- you need a developer to completely
re-write the application to the web interface.

It is more likely that you could find someone to provide a Citrix-based
solution (or host it yourself) that would allow running the entire
application via a web browser first, and then worry about writing a true
web version later on.

Of course, if you're rewriting the entire app for the web anyway, then
the actual database should be immaterial.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach (From Honolulu, HI)
BillBach@goldstarsoftware.com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - Nov. 2008 ***


DigitalConsultant@gmail.com wrote:
> Does anyone know of a web hosting entity that explicitly offers
> Pervasive 9 SQL database support "out of the box" (I've looked
> extensively, but have not found any myself)??
>
> I have a client with a PSQL9 desktop application that they would like
> to host with unchanged mkd/ddf files (but obviously with a web
> interface instead of a desktop interface) on the web and would like
> something less than a full dedicated server hosting or server
> colocation situation.
>
> Ideally, the hosting entity would also support asp.net with all the
> current bells and whistles (3.5 + WSE3, Silverlight, ...) but even
> that is negotiable.
>
> Thaks!

[Database Administrator]

On Aug 19, 4:11*pm, BtrieveBill wrote:
> If you want to access the same database as the application, you need
> more than just a hosting service -- you need a developer to completely
> re-write the application to the web interface.
>
> It is more likely that you could find someone to provide a Citrix-based
> solution (or host it yourself) that would allow running the entire
> application via a web browser first, and then worry about writing a true
> web version later on.
>
> Of course, if you're rewriting the entire app for the web anyway, then
> the actual database should be immaterial.
> * * * * Goldstar Software Inc.
> * * * * Pervasive-based Products, Training & Services
> * * * * Bill Bach (From Honolulu, HI)
> * * * * BillB...@goldstarsoftware.com
> * * * *http://www.goldstarsoftware.com
> * * * * *** Chicago: Pervasive Service & Support Class - Nov. *2008 ***
>
>
>
> DigitalConsult...@gmail.com wrote:
> > Does anyone know of a web hosting entity that explicitly offers
> > Pervasive 9 SQL database support "out of the box" *(I've looked
> > extensively, but have not found any myself)??
>
> > I have a client with a PSQL9 desktop application that they would like
> > to host with unchanged mkd/ddf files (but obviously with a web
> > interface instead of a desktop interface) on the web and would like
> > something less than a full dedicated server hosting or server
> > colocation situation.
>
> > Ideally, the hosting entity would also support asp.net with all the
> > current bells and whistles (3.5 + WSE3, Silverlight, ...) but even
> > that is negotiable.
>
> > Thaks!- Hide quoted text -
>
> - Show quoted text -

I'm the "lucky guy" who has to initially port the application to the
web.

The issue is that the client wishes to use the same physical files
between the two situations (so that nightly physical file backups from
the web can be verified within the old desktop application) in the
early stages of transition to a SOA.

And no, in their "wisdom", they do not want to send the data back from
the web to the company using a webservice approach for verification,
at least not initially.

Otherwise we would just port the existing database structure to Oracle
or MsSql or MySql and write to that from the very start and not deal
with the issue of finding a PSQL hosting entity (which was my original
response to the client).

HTH. Thanks!

[Database Administrator]

DigitalConsultant@gmail.com wrote:
> On Aug 19, 4:11 pm, BtrieveBill wrote:
>> If you want to access the same database as the application, you need
>> more than just a hosting service -- you need a developer to completely
>> re-write the application to the web interface.
>>
>> It is more likely that you could find someone to provide a Citrix-based
>> solution (or host it yourself) that would allow running the entire
>> application via a web browser first, and then worry about writing a true
>> web version later on.
>>
>> Of course, if you're rewriting the entire app for the web anyway, then
>> the actual database should be immaterial.
>> Goldstar Software Inc.
>> Pervasive-based Products, Training & Services
>> Bill Bach (From Honolulu, HI)
>> BillB...@goldstarsoftware.com
>> http://www.goldstarsoftware.com
>> *** Chicago: Pervasive Service & Support Class - Nov. 2008 ***
>>
>>
>>
>> DigitalConsult...@gmail.com wrote:
>>> Does anyone know of a web hosting entity that explicitly offers
>>> Pervasive 9 SQL database support "out of the box" (I've looked
>>> extensively, but have not found any myself)??
>>> I have a client with a PSQL9 desktop application that they would like
>>> to host with unchanged mkd/ddf files (but obviously with a web
>>> interface instead of a desktop interface) on the web and would like
>>> something less than a full dedicated server hosting or server
>>> colocation situation.
>>> Ideally, the hosting entity would also support asp.net with all the
>>> current bells and whistles (3.5 + WSE3, Silverlight, ...) but even
>>> that is negotiable.
>>> Thaks!- Hide quoted text -
>> - Show quoted text -
>
> I'm the "lucky guy" who has to initially port the application to the
> web.
>
> The issue is that the client wishes to use the same physical files
> between the two situations (so that nightly physical file backups from
> the web can be verified within the old desktop application) in the
> early stages of transition to a SOA.
>
> And no, in their "wisdom", they do not want to send the data back from
> the web to the company using a webservice approach for verification,
> at least not initially.
>
> Otherwise we would just port the existing database structure to Oracle
> or MsSql or MySql and write to that from the very start and not deal
> with the issue of finding a PSQL hosting entity (which was my original
> response to the client).
>
> HTH. Thanks!



Ouch. Given that directive, the "best" solution would be to put in an
INTERNAL web server in front of the firewall, with a single hole poked
through it for PSQL access (TCP Port 1583 between the two computers).
You can then do all of your web development locally on the web server
there, first.

The advantage here is that initial costs are low, especially during
application development. You can leverage easy access to the production
data, and you can easily build a test database area on the same
Pervasive database for your initial development efforts for testing
database updates and such. Obviously, the dev process will take some
time, so it will be much easier with the DB in house.

Once the new app dev project is finished (OK, so programs are never
finished, just abandoned), then you can migrate it to an off-site
hosting facility if you really need to. You probably won't find one
that supports native PSQL access, so you'll either need a co-lo facility
or one that at least gives you a dedicated (probably virtual) machine
onto which you can install PSQL.

Personally, my own recommendation would be to simply add the
Internet/Intranet license for your web users to the database engine and
keep everything in-house. The cost of the extra bandwidth will be far
less than any co-lo-fac, although attaining a given SLA might be more
costly if they need guaranteed uptime.
BB