Which DB/Software suite combo is best for Web<->DB implementation

I am new to the Web<->DB world. My past was primarily invloved in Windows Client/Server apps using C++ and MFC. Now my job entails using the web as the primary front end to our apps. I know/hope there is going to be lots of feedback with this question so here it goes: Which DB/Software suite combo is the best for Web<->DB implementation? What I exactly mean by this is that there are lots of technologies out there and I want to hear some feed back as to what has worked well for you, but also just as important, what has NOT worked well for you. The projects are going to range from small to large so I am open to anything. Thanks, Nate

FileMAker PRO and Tango(?) for fast, easy implementation. shopping etc.. In article <370ab48b.11143929@news.pacbell.net>, nthelen@pbjcorp.com says... > >I am new to the Web<->DB world. My past was primarily invloved in >Windows Client/Server apps using C++ and MFC. Now my job entails >using the web as the primary front end to our apps. I know/hope there >is going to be lots of feedback with this question so here it goes: > >Which DB/Software suite combo is the best for Web<->DB implementation? >What I exactly mean by this is that there are lots of technologies out >there and I want to hear some feed back as to what has worked well for >you, but also just as important, what has NOT worked well for you. >The projects are going to range from small to large so I am open to >anything. > >Thanks, >Nate

MS Access 97 and Cold Fusion Administrator 4.0. Works like a dream... Cheers, Stephanie Davis Saber Data Systems larry@lobster.com wrote in message <7eie1o$3t6@edrn.newsguy.com>... >FileMAker PRO and Tango(?) for fast, easy implementation. shopping etc.. > > >In article <370ab48b.11143929@news.pacbell.net>, nthelen@pbjcorp.com says... >> >>I am new to the Web<->DB world. My past was primarily invloved in >>Windows Client/Server apps using C++ and MFC. Now my job entails >>using the web as the primary front end to our apps. I know/hope there >>is going to be lots of feedback with this question so here it goes: >> >>Which DB/Software suite combo is the best for Web<->DB implementation? >>What I exactly mean by this is that there are lots of technologies out >>there and I want to hear some feed back as to what has worked well for >>you, but also just as important, what has NOT worked well for you. >>The projects are going to range from small to large so I am open to >>anything. >> >>Thanks, >>Nate >

"Saber Data Systems" <sjdavis@nospam.saberdata.com> writes: > MS Access 97 and Cold Fusion Administrator 4.0. Works like a dream... And the performance in a multiuser environment? > larry@lobster.com wrote in message <7eie1o$3t6@edrn.newsguy.com>... > >FileMAker PRO and Tango(?) for fast, easy implementation. shopping etc.. Filemaker and Tango are both proprietary solutions, much like Access and Cold Fusion. The implementation may be fast, performance is _not_. > >In article <370ab48b.11143929@news.pacbell.net>, nthelen@pbjcorp.com > says... > >> > >>I am new to the Web<->DB world. My past was primarily invloved in > >>Windows Client/Server apps using C++ and MFC. Now my job entails > >>using the web as the primary front end to our apps. I know/hope there > >>is going to be lots of feedback with this question so here it goes: > >> > >>Which DB/Software suite combo is the best for Web<->DB implementation? Apache with PHP or Modperl against Oracle, Sybase, MySQL or Solid. If you're from the Microsoft-camp IIS against SQL-server 7.0 is the obvious choice. I find Tango and Cold Fusion both strange and wrong (TM), but then again I use Perl on IIS (with ASP) instead of VB. (Don't like Visual Interdev much either) > >>What I exactly mean by this is that there are lots of technologies out > >>there and I want to hear some feed back as to what has worked well for > >>you, but also just as important, what has NOT worked well for you. NT/IIS has not worked well for me, Microsoft products in general actually... I've built two intranetts with IIS, one mainly databasebased (Sybase). > >>The projects are going to range from small to large so I am open to > >>anything. This is 90% philosophy and 10% science. Or 90/90 if you have the "right" philosophy... It's open vs. proprietary, good vs. evil, solution vs. technology In my opinion (and expreience): 1) Linux/Sybase ASE 11.0.3.3/Apache beates the hell out of NT/IIS/SQL-server while costing nothing. And doing so on _cheaper_ hardware. 2) ASE 11.9 will cost a lot (~MS SQL-server) but MySQL is good enough in most scenarios. 3) Perl, Python, PHP is _far_ better than VB Check out: www.apache.org perl.apache.org perl.apache.org/embperl www.perl.org www.php.net www.zope.org Thomas (commence flaming)

nthelen@pbjcorp.com wrote: > Which DB/Software suite combo is the best for Web<->DB implementation? > What I exactly mean by this is that there are lots of technologies out > there and I want to hear some feed back as to what has worked well for > you, but also just as important, what has NOT worked well for you. > The projects are going to range from small to large so I am open to > anything. Don't even think about Informix's web datablade. For scripting solutions, check out 1. http://www.php.net/ (GNU) PHP (linux, NT, others?) 2. http://www.allaire.com/ (commercial) Cold Fusion (NT, solaris, linux soon) 3. http://www.webcatalog.com/ (commercial) webcatalog (NT, Mac) 4. http://www.cpan.net/ (GNU) perl (everything; apache mod_perl) 5. http://www.metahtml.org/ (GNU) meta-html (unix) Sybase's web scripting thing is nice; like server-side javascript. Also look at server-side java. (1) and (2) seem to be the biggest in their fields. PHP people have been known to switch to cold fusion for productivity reasons. I guess it depends on the complexity of the app. PHP has plenty of demo libs of stuff. There are _many_ others. They are mostly identical. Critical features for real-world apps: a) ability to call external libraries b) control over transaction begin/commit c) maintainabilty (version churn, learning curve, syntax, ..) d) scalablity also watch out for engines that will cache parse-trees/compiled script code. (PHP: 'Zend') Note that MS visual studio will 'kill' javascript when you open/save a web page. very sad. Watch out for your script's 'compatability' with the graphicist's favourite html editors. It's no fun if they give you a refreshed look that has had all the scripting stripped out... Tha MAIN PAIN with this stuff is having to 'rewrite' everything each time the graphics people change the appearences. Advice: learn javascript _real well_ test on all browser/OS combinations don't underestimate the power of the FRAMESET Otherwise, look at 3-tier solutions, of which there are many. start from http://www.cetus-links.org/ for more details. also see http://www.cs.wustl.edu/~schmidt/ACE.html about larger-scale multi-tier things. See also <http://members.tripod.com/john_mullee/bca_report/index.html>; for an overview of 3-tier generic structure. I hear interesting things about OODBs. Gemstone, objectstore, ... SGML, on the other hand, is a quite different career path. john

I said: > > Don't even think about Informix's web datablade. Thomas Tatum wrote: > I disagree. Validating a date in Informix Web-Datablade tags. This resembles no language I ever heard of, except maybe RPG. But not really. <?MIBLOCK COND=$(EQ,$MMI_VALID,TRUE)> <?MIVAR NAME=MMI_VALDATE>TRUE<?/MIVAR> <?MIVAR COND=$(NOT,$(ISINT,$year_date_birth))NAME=MMI_VALID>FALSE<?/MIVAR> <?MIVAR COND=$(ISINT,$year_date_birth)>$(IF,$(<,$year_date_birth,1900),$(SETVAR,$MMI_VALID,FALSE))<?/MIVAR> <?MIVAR COND=$(NOT,$(ISINT,$month_date_birth)) NAME=MMI_VALID>FALSE<?/MIVAR> <?MIVAR COND=$(ISINT,$month_date_birth)>$(IF,$(<,$month_date_birth,1),$(SETVAR,$MMI_VALID,FALSE))<?/MIVAR> <?MIVAR COND=$(ISINT,$month_date_birth)>$(IF,$(NOT,$(<,$month_date_birth,13)),$(SETVAR,$MMI_VALID,FALSE))<?/MIVAR> <?MIVAR COND=$(NOT,$(ISINT,$day_date_birth)) NAME=MMI_VALID>FALSE<?/MIVAR> <?MIVAR COND=$(ISINT,$day_date_birth)>$(IF,$(<,$day_date_birth,1),$(SETVAR,$MMI_VALID,FALSE))<?/MIVAR> <?MIBLOCK COND=$(AND,$(ISINT,$day_date_birth),$(ISINT,$month_date_birth))> <?MIVAR COND=$(AND,$(<,0,$day_date_birth),$(<,$month_date_birth,13),$(<,0,$month_date_birth))> $(IF, $(<, $(NTH,$month_date_birth, 0,31, $(IF,$(=,$(/,$year_date_birth, 4),$(FIX,$(/,$year_date_birth, 4))), $(IF,$(=,$(/,$year_date_birth,100),$(FIX,$(/,$year_date_birth,100))), $(IF,$(=,$(/,$year_date_birth,400),$(FIX,$(/,$year_date_birth,400))), 29, 28), 29), 28), 31,30,31,30,31,31,30,31,30,31), $day_date_birth), $(SETVAR,$MMI_VALID,FALSE)) <?/MIVAR> <?/MIBLOCK> <?MIVAR COND=$(EQ,$MMI_VALID,FALSE)>$(SETVAR,$MMI_VALDATE,FALSE)<?/MIVAR> It took an embarrasing amount of effort to figure out to do this simple task. There are few if any resources 'out there' on how to do this kind of thing. In contrast, there are zillions of pages on cold fusion, php, etc etc. Another gripe I have is that each page is an atomic transaction. To select for update, or perform certain other kinds of operations, requires control over transaction boundaries. This is impossible with IUS/WEB-DB unless you queue a request to an external process with it's own session connection..... And the exception-handling is really cruddy. John

John Mullee wrote: > nthelen@pbjcorp.com wrote: > > Which DB/Software suite combo is the best for Web<->DB implementation? > > What I exactly mean by this is that there are lots of technologies out > > there and I want to hear some feed back as to what has worked well for > > you, but also just as important, what has NOT worked well for you. > > The projects are going to range from small to large so I am open to > > anything. > The problem with using scripts is that each time called, you have to create a new connection. Skip javascript. Not secure and those who are paranoid or do a lot of web surfing will not have that feature turned on. Server side Java == serverlets. Very easy to implement, and with JDBC, very efficient. You could have a server side java application which has a persistant connection and is independent of the httpd. This too has advantages... Using serialization you can have good communication from an applet to the server side application. You could also use CORBA or RMI, with CORBA being the recommended choice. As to web datablades, even Informix isn't really pushing them for "e-commerce" (Sorry Paul B.) Their new 600K program is using IDS technology not UDO. If you want another OO technology check out Apple's/NeXT's webObjects. Very strong technology too. -Mikey I know that there are those who swear by Javascript. But guess what. When you allow your browser to visit a website running javascript, you lose control over what the site can do with or to your machine. Until the browsers enable you to turn on or off preferences against sites, don't use it. But then again, I'm paranoid. I tend to think that there is some clown running around England who is out to get me. (A little inside joke! ;-)

> > If you want another OO technology check out Apple's/NeXT's webObjects. > Very strong technology too. > > -Mikey I got to second that, since I am using the technology day in and day out and am really happy with it. Nat! -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Maybe I can share some experience with all. Some is good and some is very bad I agree that never think about Informix Web datablade. One of my project failed and I need to switch back to MS ASP. Why? When their Business Development manager showed us Web DB and a package called Content Management Solution.(now they change name to I.Reach). It looks good. They also show me a lot of reference sites. What is the real? Informix Web datablade does not have following in their tag language: 1. For-Next loop or any Do While 2. No data cursor. That is, you can not write code to loop parent table and read the child record. It is fatal problem. 3. No HTTP session variable, it forces us to use cookies instead. However cookie is not often work in all browser. When we know this problem. We are crucial why other reference site can do that. Next we investigate them. We found that most of them are static page (check by view source) or only has a few simple Web datablade page. That is joke, one of them is ASP site. It made a very bad image in our team. Later on, I remember a word " Listen to peope who work, Don't trust people who talk" Remember this. I also has experience with other database Web connectivity since we are WEB to DB consultant. Lets be open and discuss. Hotquery OCP/ICP/MCP > -- All post are personal idea only :-} -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own