Stuart McLachlan
stuart at lexacorp.com.pg
Tue Jan 1 17:13:36 CST 2013
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 >