Re: MS Access -> MySQL

If you're using an ORM, data abstraction layer, or CMS that relies on
MySQL, then porting it to PostgreSQL could be more trouble than it's
worth.  Another reason might be if your host doesn't support pgsql, or
if the PHP coder is more comfortable w/ MySQL than pgsql.  Also, if
you intend to use full-text indexing, MySQL has it built in, whereas
it's an add-on for pgsql and can be a pain to set up (I've opted to do
FT indexing outside the DB using Xapian for my projects that require
it).

Matthew

On Dec 7, 2007 7:41 PM, J. Marsden DeLapp <[email protected]> wrote:
> Matthew Bowie wrote:
> > If you're looking for help to do it yourself, and not someone to do it
> > for you, I'll be glad to help.  I don't have time to be lead on a new
> > project right now, but I'll be glad to help you with getting started and
> > any questions that arise.  I can even provide hosting for you if needed
> > (I host several PHP and Django sites right now).
>
> I would like to do it myself but the problem is I just don't have time.
>
>
> > I'd highly recommend using Python and Django
> > (http://djangoproject.com).  I did PHP development for several years,
> > but I don't even touch it any more when I can help it, as Python is
> > (IMO) a much better language.  It has bindings for pretty much
> > everything under the sun, so it's very expandable.  I'm currently using
> > it to rebuild the web page and several web applications at LCC (
> > http://test.luna.edu), and the code is much cleaner and more
> > maintainable that the equivalent code in PHP.
>
> I looked into Python a while back and decided that is a language I would like to learn. I would not mind doing my stuff
> in Python and maybe PostgreSQL.
>
> The reason for choosing PHP for the NMSEA web site is that there is someone working on the web site that already knows
> PHP.  The reason for choosing MySQL is kind of like that is what everyone else is using...
>
> Ok now after you prompted my to think about PostgreSQL and some more research, I think it is pretty clear that
> PostgreSQL would be a better choice for my stuff.
>
> The next question is should I do the NMSEA database in PostgreSQL? Can anyone think of a reason not to?
>
>
> Mars
>
> --
> =============================================================
> J. Marsden DeLapp, PE
> President
> DeLapp & Associates, Inc. dba DeLapp Engineering(R)
> Providing lighting and power planning, design and analysis services
> for commercial, industrial and large residential facilities.
> 1190 Harrison Rd Ste 3a
> Santa Fe NM 87507
> (505) 983-5557
> http://DeLapp.com
> =============================================================
>
>
> _______________________________________________
> NMLUG mailing list
> [email protected]
> http://lists.b9.com/cgi-bin/mailman/listinfo/nmlug
>



-- 
Matthew Bowie
Programmer/IT Consultant
[email protected]
_______________________________________________
NMLUG mailing list
[email protected]
http://lists.b9.com/cgi-bin/mailman/listinfo/nmlug