Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Pervasive.SQL Topics / August 2008

Tip: Looking for answers? Try searching our database.

Web hosting for Pervasive 9 applications??

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DigitalConsultant@gmail.com - 19 Aug 2008 21:25 GMT
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!
BtrieveBill - 19 Aug 2008 22:11 GMT
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 ***

> Does anyone know of a web hosting entity that explicitly offers
> Pervasive 9 SQL database support "out of the box"  (I've looked
[quoted text clipped - 11 lines]
>
> Thaks!
DigitalConsultant@gmail.com - 19 Aug 2008 22:29 GMT
> 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
[quoted text clipped - 32 lines]
>
> - 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!
BtrieveBill - 21 Aug 2008 13:51 GMT
>> 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
[quoted text clipped - 47 lines]
>
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.