[AccessD] Access Database on Web

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
> 




More information about the AccessD mailing list