On Sat, 2009-05-23 at 02:59 -0400, Eddie Drapkin wrote:
> On Sat, May 23, 2009 at 2:58 AM, Ashley Sheridan
> <a...@ashleysheridan.co.uk>wrote:
> >
> > If it's a CSV, I'd recommend using phpMyAdmin directly to import it into
> > the database, assuming you are using a MySQL database that is. It's
> > using tried and tested code for large files like that.
> >
> >
> Tried and true to be what, exactly? Full of security holes and exploits and
> promoting bad habits?
> Really, if all you need to do for the database is import hte .csv, import it
> directly into mysql, from mysql:
> http://www.tech-recipes.com/rx/2345/import_csv_file_directly_into_mysql/
> And on a related note, you should never, ever use PMA on a production
> machine as it's so easy to exploit and hack.  Furthermore, if you use it on
> your dev server, you'll get used to managing your database with it and have
> trouble using it on the production server.  Take the time to use a real DB
> administration app (like SQLyog of the one that comes with KDE) or an IDE
> with integrated SQL management (like PDT or Zend Studio or Aptana I think
> too).
> Bottom line is if you said you used PMA in an interview I had any say in,
> I'd never hire you and I'd never work with a developer who was that
> uncomfortable with SQL.
I guess I don't get the job then! :p


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to