Benson, William (GE Global Research, consultant)
Benson at ge.com
Tue Jan 1 22:11:41 CST 2013
I think you may conclude the same thing but to be clearer, http://news.netcraft.com/archives/2012/11/01/november-2012-web-server-survey.html says "Apache lost 2.0 million sites this month, whereas Microsoft gained 2.3 million" Maybe Microsoft is making a comeback :-) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Tuesday, January 01, 2013 6:14 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access Database on Web If you want avoid getting locked into a declining market, I'd go with *AMP. MS are down to around 16-17% market share now on web servers, http://news.netcraft.com/archives/2012/11/01/november-2012-web-server-survey.html and http://w3techs.com/technologies/overview/web_server/all On 1 Jan 2013 at 12:52, Doug Murphy wrote: > Hi Tina, > > If you are familiar with the Microsoft environment I'd stick with SQL > Server. There are many low cost web hosts, Arvixe for one, that offer > SQL Server databases that are more than adequate for the type of web > project your talking about. These companies use SQL Express but I have > found no performance limitations. Possibly if you're talking thousands > of hits per minute and gigs of storage you might find the limits, but > I haven't I we have some quite challenging stored procedures running on several of these. > You might also take a look at Microsoft LightSwitch for your > development environment. The new version will publish to the desktop > or web in HTML 5 so the apps will work on any phone or tablet. > > My 2 cents worth. > > Happy New Year. > > Doug > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris > Fields > Sent: Tuesday, January 01, 2013 12:28 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access Database on Web > > Thank you, Stuart. For my own curiosity and understanding,I have to > check that out. But, I really appreciate the feedback that I can do > the necessary with phpMyAdmin. I hope this new year a joyous and > prosperous one for you and your family. > Best, > T > > Tina Norris Fields > tinanfields at torchlake.com > 231-322-2787 > > On 1/1/2013 1:53 PM, Stuart McLachlan wrote: > > Don't bother with the CLI - I never do. You can do everything you > > want/need with phpMyAdmin. > > > > If you really want to check it out, go to your mySQL installation's > > binary > directory and type > > "mysql -h". (Not sure what it will be with UwAMP, but my WAMP was > installed on my D > > drive and the MySQL directory is: D:\wamp\bin\mysql\mysql5.5.20\bin). > > There's a tutorial on using mySQL.exe here: > > http://dev.mysql.com/doc/refman/5.5/en/mysql.html > > > > How the data is stored depends on which storage engine is used (msot > > likely InnoDB or myISAM for early versions). To quote the manual: > > > > <quote>For new tables, MySQL always creates an .frm file to hold the > > table and column definitions. The table's index and data may be > > stored in one or more other files, depending on the storage engine. > > The server > creates the .frm file above the storage engine level. > > Individual storage engines create any additional files required for > > the tables that they manage</quote>. . > > > > > > > > On 1 Jan 2013 at 9:43, Tina Norris Fields wrote: > > > >> I've been playing with MySQL, using UwAMP and phpMyAdmin to run > >> some tutorials. I've also downloaded a huge MySQL reference manual > >> and have begun studying it. Using the phpMyAdmin I have a WYSIWYG > >> interface for connecting to the localhost/mysql server to play > >> around. The reference manual speaks of what looks like a command > >> line connection for invoking MySQL. This one I don't follow. How > >> do I invoke MySQL from the DOS window? Where do I have to be? How > >> do I make the connection that the phpMyAdmin seems to make so > >> easily? Or, should I just wait until that part makes sense to me > >> and stick with the > WYSIWYG interface for now? > >> > >> The database structure for MySQL seems to be that the database is a > >> folder and the database objects are separate files within that folder. > >> Do I have that right? That's the way the old dBase structure was, > >> if I recall correctly. > >> > >> I do appreciate the hand-holding, my friends. There's so much to > >> learn in a short time! > >> > >> T > >> > >> Tina Norris Fields > >> tinanfields at torchlake.com > >> 231-322-2787 > >> > >> On 12/29/2012 6:22 PM, Tina Norris Fields wrote: > >>> Hi Guys, > >>> > >>> I've got two fairly straight-forward database projects coming up, > >>> that need to be available on the Web. > >>> > >>> One is of scanned images of soil erosion permit applications. > >>> People must apply for a soil erosion permit in Michigan if they > >>> are planning to do any tree cutting or earth modification within > >>> 100 feet of the state waters. Lake associations realize the > >>> importance of monitoring such applications. In order to make the > >>> records easily available, the county soil erosion officer wants to > >>> scan the permit applications and put the images online for the public to search. > >>> > >>> The second one is of data pertinent to streams that we monitor - > >>> macroinvertebrate inventory data, p H, temperature, clarity, etc., > >>> plus the GPS coordinates of the sites. > >>> > >>> I have never put a database online, and I could use some tutoring > >>> on how best to go about it. The databases themselves don't look > >>> complicated, but putting stuff on the Web for search is new to me. > >>> > >>> Thanks for all the good advice you will be giving me! > >>> > >>> T > >>> > >> -- > >> AccessD mailing list > >> AccessD at databaseadvisors.com > >> http://databaseadvisors.com/mailman/listinfo/accessd > >> Website: http://www.databaseadvisors.com > >> > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com