Re: [PHP-DB] The New Guy
Paul, Just a clarification: I wasn't the original poster. Christopher J. Crane was the original asker of the CSV/flat file database question. I do have a db to use. Cheers, db Paul Burney wrote: > on 1/14/02 2:12 PM, Daniel Barton at [EMAIL PROTECTED] appended the following > bits to my mbox: > > > Well maybe I should just go out and join that perl list. > > I was going to respond to you but I didn't have a good answer. :) > > I don't know of any built in PHP functions that do what you are looking to > do. There are some special fgets-type functions for use with CSV, but > nothing that treats it as SQL. > > You might want to try the PEAR repository to see if they have anything, but > I'm not hopeful. > > For those of you who aren't familiar with it, the Perl DBI::CSV module > allows you to use a CSV file as a simple SQL database. Very nice if you > don't have a real database to work with (which in this case, Mr. Barton > doesn't). > > I was at a workshop by Randal Schwartz where he showed a bit of how to use > it. Very cool... > > If you can't get the clients to go for the extra cost, I'd recommend going > with Perl. Choose the best tool for the job at hand, TMTOWTDI. > > Paul > > while ($self != "asleep") { > $sheep_count++; > } > ?> > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- -- Dan Barton Terrestrial Program Biologist Asst. Data Manager Point Reyes Bird Observatory http://www.prbo.org [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] The New Guy
People, people! I wish we could all just get along. ;^) I did have a problem understanding the exact question. My response was a little off-target owing to ambiguity. Also, I did read (or participate in) the other threads mentioned by Mr. Neil, (aka "Mr anti-Guru basher.") Sincerely, "Mr anti-Newbie Basher" db p.s. I'm on a couple of perl lists. apologies for being WAY off-subject. DL Neil wrote: > In another thread there's a comment about "newbie bashing", the author now gets to >see that there are always two > sides to a story! > > Christopher: I notice that you have found it necessary to explain your rationale for >"They do not want to pay > the extra amount of money for a MySQL database". The fact that you felt it necessary >to expand on your earlier > statement illustrates an ambiguity/short-coming in the original. You were >responsible for that. How did Daniel > qualify for the blame? > > I also notice that you have not had the courtesy to comment on my own response to >your first post, and the other > confusing statement/ambiguity "A lot of my work is on unix system that people want >to work with Access." The > implication behind your post was that you only received responses concerned with the >cost of MySQL. This is not > true. You do however say "None the answers had anything to do with the question I >asked" which indicates you > either didn't read what I said, or failed to understand it. > > It is not fun to spend time attempting to help someone, and then find that not only >were your comments a waste > of time, but the questioner wants to argue or to replace good manners with rudeness >(and you are not the first > to have done so in the last few days - FYI Mr anti-Newbie Basher). > > If you have a problem with people on this list, please do unsubscribe (quietly). If >you prefer the company of > others, please do take Dan's advice. Your experience is contrary to my own, and is >NOT supported by the majority > as evidenced by the volume of list transactions. > > =dn > > ----- Original Message - > From: "Daniel Barton" <[EMAIL PROTECTED]> > To: "Christopher J. Crane" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: 14 January 2002 19:12 > Subject: Re: [PHP-DB] The New Guy > > > Well maybe I should just go out and join that perl list. > > > > "Christopher J. Crane" wrote: > > > > > It's not that MySQL is not free, I know that and I am using iton my > > > development servers. The problem is some of the work I do is for clients > > > that do not have their own server. So their site is hosted by a company and > > > most of these companies charge extra for a MySQL database. > > > > > > This is the second answer I got about MySQL being free. None the answers had > > > anything to do with the question I asked. The people at the perl lists are > > > so much more helpful and direct with the answers someone seeks. > > > - Original Message - > > > From: "Daniel Barton" <[EMAIL PROTECTED]> > > > To: "Christopher J. Crane" <[EMAIL PROTECTED]> > > > Sent: Sunday, January 13, 2002 9:10 PM > > > Subject: Re: [PHP-DB] The New Guy > > > > > > > MySQL is free and open source. Support from MySQL AB is not free, but > > > > that shouldn't be an issue. > > > > > > > > Check out: > > > > > > > > http://www.mysql.com > > > > > > > > for more info. It's a free, fully functional relational database. > > > > > > > > If you mean pay for the hosting of a MySQL database..?? > > > > > > > > -db > > > > > > > > "Christopher J. Crane" wrote: > > > > > > > > > I do a lot of work with Perl and have decided to see what this PHP is > > > all > > > > > about. The best way for me to do that, is to just do a project. Here is > > > what > > > > > I am looking to do. I would like to use PHP and the SQL language on a > > > CSV or > > > > > Flat File Database. A lot of my work is on unix system that people want > > > to > > > > > work with Access. They do not want to pay the extra amount of money fora > > > > > MySQL database. The answer to this issue is access with exports to CSV > > > files > > > > > for some of the simplier stuff like shopping carts and members and stuff > > > > > like that. > > > >
Re: [PHP-DB] The New Guy
on 1/14/02 2:12 PM, Daniel Barton at [EMAIL PROTECTED] appended the following bits to my mbox: > Well maybe I should just go out and join that perl list. I was going to respond to you but I didn't have a good answer. :) I don't know of any built in PHP functions that do what you are looking to do. There are some special fgets-type functions for use with CSV, but nothing that treats it as SQL. You might want to try the PEAR repository to see if they have anything, but I'm not hopeful. For those of you who aren't familiar with it, the Perl DBI::CSV module allows you to use a CSV file as a simple SQL database. Very nice if you don't have a real database to work with (which in this case, Mr. Barton doesn't). I was at a workshop by Randal Schwartz where he showed a bit of how to use it. Very cool... If you can't get the clients to go for the extra cost, I'd recommend going with Perl. Choose the best tool for the job at hand, TMTOWTDI. Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] The New Guy
In another thread there's a comment about "newbie bashing", the author now gets to see that there are always two sides to a story! Christopher: I notice that you have found it necessary to explain your rationale for "They do not want to pay the extra amount of money for a MySQL database". The fact that you felt it necessary to expand on your earlier statement illustrates an ambiguity/short-coming in the original. You were responsible for that. How did Daniel qualify for the blame? I also notice that you have not had the courtesy to comment on my own response to your first post, and the other confusing statement/ambiguity "A lot of my work is on unix system that people want to work with Access." The implication behind your post was that you only received responses concerned with the cost of MySQL. This is not true. You do however say "None the answers had anything to do with the question I asked" which indicates you either didn't read what I said, or failed to understand it. It is not fun to spend time attempting to help someone, and then find that not only were your comments a waste of time, but the questioner wants to argue or to replace good manners with rudeness (and you are not the first to have done so in the last few days - FYI Mr anti-Newbie Basher). If you have a problem with people on this list, please do unsubscribe (quietly). If you prefer the company of others, please do take Dan's advice. Your experience is contrary to my own, and is NOT supported by the majority as evidenced by the volume of list transactions. =dn - Original Message - From: "Daniel Barton" <[EMAIL PROTECTED]> To: "Christopher J. Crane" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: 14 January 2002 19:12 Subject: Re: [PHP-DB] The New Guy > Well maybe I should just go out and join that perl list. > > "Christopher J. Crane" wrote: > > > It's not that MySQL is not free, I know that and I am using iton my > > development servers. The problem is some of the work I do is for clients > > that do not have their own server. So their site is hosted by a company and > > most of these companies charge extra for a MySQL database. > > > > This is the second answer I got about MySQL being free. None the answers had > > anything to do with the question I asked. The people at the perl lists are > > so much more helpful and direct with the answers someone seeks. > > - Original Message ----- > > From: "Daniel Barton" <[EMAIL PROTECTED]> > > To: "Christopher J. Crane" <[EMAIL PROTECTED]> > > Sent: Sunday, January 13, 2002 9:10 PM > > Subject: Re: [PHP-DB] The New Guy > > > > > MySQL is free and open source. Support from MySQL AB is not free, but > > > that shouldn't be an issue. > > > > > > Check out: > > > > > > http://www.mysql.com > > > > > > for more info. It's a free, fully functional relational database. > > > > > > If you mean pay for the hosting of a MySQL database..?? > > > > > > -db > > > > > > "Christopher J. Crane" wrote: > > > > > > > I do a lot of work with Perl and have decided to see what this PHP is > > all > > > > about. The best way for me to do that, is to just do a project. Here is > > what > > > > I am looking to do. I would like to use PHP and the SQL language on a > > CSV or > > > > Flat File Database. A lot of my work is on unix system that people want > > to > > > > work with Access. They do not want to pay the extra amount of money fora > > > > MySQL database. The answer to this issue is access with exports to CSV > > files > > > > for some of the simplier stuff like shopping carts and members and stuff > > > > like that. > > > > > > > > Here's the thing, can PHP interact with a flat file databse like perl > > and > > > > the DBD::CSV? If so can someone point me in the right idrection to get > > > > started. I have a server for development and it now has 4.0 PHP. > > > > > > > > -- > > > > PHP Database Mailing List (http://www.php.net/) > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > -- > > > -- > > > Dan Barton > > > Terrestrial Program Biologist > > > Asst. Data Manager > > > Point Reyes Bird Observatory > > > http://www.prbo.org > > > [EMAIL PROTECTED] > > > [EMAIL PROTECTED] > > > > > > > > > > > -- > -- > Dan Barton > Terrestrial Program Biologist > Asst. Data Manager > Point Reyes Bird Observatory > http://www.prbo.org > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] The New Guy
Well maybe I should just go out and join that perl list. "Christopher J. Crane" wrote: > It's not that MySQL is not free, I know that and I am using iton my > development servers. The problem is some of the work I do is for clients > that do not have their own server. So their site is hosted by a company and > most of these companies charge extra for a MySQL database. > > This is the second answer I got about MySQL being free. None the answers had > anything to do with the question I asked. The people at the perl lists are > so much more helpful and direct with the answers someone seeks. > - Original Message - > From: "Daniel Barton" <[EMAIL PROTECTED]> > To: "Christopher J. Crane" <[EMAIL PROTECTED]> > Sent: Sunday, January 13, 2002 9:10 PM > Subject: Re: [PHP-DB] The New Guy > > > MySQL is free and open source. Support from MySQL AB is not free, but > > that shouldn't be an issue. > > > > Check out: > > > > http://www.mysql.com > > > > for more info. It's a free, fully functional relational database. > > > > If you mean pay for the hosting of a MySQL database..?? > > > > -db > > > > "Christopher J. Crane" wrote: > > > > > I do a lot of work with Perl and have decided to see what this PHP is > all > > > about. The best way for me to do that, is to just do a project. Here is > what > > > I am looking to do. I would like to use PHP and the SQL language on a > CSV or > > > Flat File Database. A lot of my work is on unix system that people want > to > > > work with Access. They do not want to pay the extra amount of money fora > > > MySQL database. The answer to this issue is access with exports to CSV > files > > > for some of the simplier stuff like shopping carts and members and stuff > > > like that. > > > > > > Here's the thing, can PHP interact with a flat file databse like perl > and > > > the DBD::CSV? If so can someone point me in the right idrection to get > > > started. I have a server for development and it now has 4.0 PHP. > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > -- > > -- > > Dan Barton > > Terrestrial Program Biologist > > Asst. Data Manager > > Point Reyes Bird Observatory > > http://www.prbo.org > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > > > > > -- -- Dan Barton Terrestrial Program Biologist Asst. Data Manager Point Reyes Bird Observatory http://www.prbo.org [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] The New Guy
Christopher, > I do a lot of work with Perl and have decided to see what this PHP is all > about. The best way for me to do that, is to just do a project. Here is what > I am looking to do. I would like to use PHP and the SQL language on a CSV or > Flat File Database. A lot of my work is on unix system that people want to > work with Access. They do not want to pay the extra amount of money fora > MySQL database. The answer to this issue is access with exports to CSV files > for some of the simplier stuff like shopping carts and members and stuff > like that. > Here's the thing, can PHP interact with a flat file databse like perl and > the DBD::CSV? If so can someone point me in the right idrection to get > started. I have a server for development and it now has 4.0 PHP. =When you next change jobs will you be keen to accept a company car that has one wheel permanently removed, has no doors, and is pulling a U-Haul filled with lead bars and raw sewage, topped off with a flag saying "We are the greatest!" ? =Is the outlined task a primary focus of PHP? PHP is renowned for its web orientation (output is HTML), and support of databases to build/run dynamic web sites. Ironically 'dumbing it down' to "simpler stuff[sic]", like removing the fourth wheel from a car, is likely to give you a very stunted/skewed view of the package. =Yes PHP has a library of flat file routines, if you insist on using them. MySQL has the capability to LOAD .csv DATA if that is the specified transfer medium, and would offer full RDBMS speed and dynamism. =Where do the lead bars etc fit in? You mention Unix systems and the Access package, plus CSV file exports. In such an incompatible environment you are hobbling the development project before you start. Again with the result that any system produced will not be representative of what PHP can do. =PHP users talk of "LAMPS" and the PHP Triad (the former is well explained by O'Reilly (the publishers) and Google will supplement my faded memory for a source on the latter). LAMPS is Linux, Apache (web server), MySQL (RDBMS), and PHP. The PHP 'Triad' is the last of those three conveniently packaged together for download/installation. So from this you can take it that PHP was designed to/will work well in any combination of these. =In your example, I fail to perceive success in a Unix-Access combination, but presume you know more than I. The PHP-MySQL combination is proven, and operates at a far more 'industrial scale' than Access (more comparable to MS SQL-Server). In a standard commercial environment I cannot think of a particular service that MySQL under PHP control cannot provide, that Access can - but many pragmatic reasons not to use Access. =You mention "extra money". This may or may not be the case. If it were a comparison between buying Access or buying MySQL then it would be wrong, but if they have already paid for Access then you may be correct. By and large, MySQL is 'free' but MySQL AB will charge for a support contract - but you must check your application against the license terms! You also ask about 'sources'. The best place to start, both to review the licensing and to find links to online sources is the MySQL AB web site. =Get rid of the "we are the greatest" flag, and choose the right tool for the job - or leave the challenge of starting on a PHP/MySQL career until it/they are the 'right' tool/best mix for the client-constraints of your application! =dn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] The New Guy
I do a lot of work with Perl and have decided to see what this PHP is all about. The best way for me to do that, is to just do a project. Here is what I am looking to do. I would like to use PHP and the SQL language on a CSV or Flat File Database. A lot of my work is on unix system that people want to work with Access. They do not want to pay the extra amount of money fora MySQL database. The answer to this issue is access with exports to CSV files for some of the simplier stuff like shopping carts and members and stuff like that. Here's the thing, can PHP interact with a flat file databse like perl and the DBD::CSV? If so can someone point me in the right idrection to get started. I have a server for development and it now has 4.0 PHP. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]