[nmglug] MS Access -> MySQL

[Todd Richardson]

I'm pretty amateur at ruby & rails, but I've had some experience with
PHP.  Both would be an excellent platform for building your web app for
the nmsea.  The advantage of ruby and rails is gem packages for
installation of certain plugins, like saltedhashuserlogin (or something
to that effect) which follows the spirit of opensource software with
ease of installation (gem install package, like yum, apt-get, emerge or
other flavors of repository)  With php, there are packages available,
but its been a while and I don't know if there is that kind of easy
installation.  PHP is a scripting language, and therefore you must come
up with your own framework of 'how its going to work.'  This can be a
blessing or a curse.  If you are used to PHP than using it will be a
breeze, and you will by practice know where you are going to store
certain scripts, and how you will structure your database interface,
what scripts will deal with control etc (whether or not you follow
MVC.)  I'm more and more an advocate of M.odel V.iew C.ontrol because it
structures your code for you, and its built into rails.  Its a bit of a
challenge to learn if you are not used to it, but there are some great
resources for learning ruby on rails (including MVC) out there. 

I'm not a programmer by trade.  The most complex thing I've ever done
was come up with a user session tracker for PHP/MySQL which worked ok,
so there may be vastly differing opinions on the above statements.  I
can only tell you what I've experienced.

Here is an article on mysql's website for conversion scripts.
> http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html
If I can offer any more assistance, please let me know.  Hope this has
been helpful.

-Todd Richardson
 IT/GIS Manager
 Central Valley Electric Coop.
 Artesia, NM



Ted Pomeroy wrote:

> Mars, I am interested in learning database
> functionality and use, but I have no background. I
> have been trying to learn the Open Office Database,
> but I have not succeeded in making even a simple
> database that works/uses true db features and not just
> tables.
> Let me know if I can help. Ted Pomeroy
>
>
>
>       ____________________________________________________________________________________
> Be a better sports nut!  Let your teams follow you 
> with Yahoo Mobile. Try it now.  http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ
> _______________________________________________
> nmglug mailing list
> nmglug at nmglug.org
> https://nmglug.org/mailman/listinfo/nmglug
>
>