
Kanji
User
Jun 20, 2000, 3:44 PM
Post #6 of 7
(2434 views)
|
<BLOCKQUOTE><font size="1" face="Arial,Helvetica,sans serif">quote:</font><HR>1) Would you still recommend using DBI if I were making a script that would have absolutely no requirements except for a cgi-bin?<HR></BLOCKQUOTE> No. DBI is not part of the standard perl distribution, so using it would require anybody using your script to install DBI if they don't already. On a side note ... It could very well be RDBMS is overkill for your application. The same could be said if you limit yourself to a DBM solution. It's possible you haven't outgrown flat-files (the only truly portable format) at all, but are just using them inefficiently. Without knowing what you're trying to do and sample datasets, it's impossible to say whether its more sane to breakdown and require the use of non-standard modules. <BLOCKQUOTE><font size="1" face="Arial,Helvetica,sans serif">quote:</font><HR>...or to rephrase, can I sort a table by the order each row was created and then process the 10 most recent or least recent rows one at a time?<HR></BLOCKQUOTE> Yes, SQL is great for that sort of stuff. Something like SELECT * FROM table ORDER BY date DESC LIMIT 10 ( select all columns from table, sort them by date in descending order, and only give me the first 10 ).
|