Doug Murphy
dw-murphy at cox.net
Tue Jan 1 14:52:34 CST 2013
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