I, too, have been watching this thread with interest; I recently used SQLite on a project where a small-footprint DB manager was needed and it outperformed everyone's expectations. It seems to me that a rexx-ish solution would be to use a stem to return queries, whether single rows or cursors. The syntax
Sqldb.<column name> with sqldb.0 for the row count seems natural to me, and does not require ooRexx support, although ooRexx could use it. My experience has been with in-core databases, so I can't guess how fast a DASD query might run, but if one retrieved the column names, etc. for the query prior to retrieving the data the tail name of the stem items could be determined with no hassle. Mark, if you wish to release some sandbox versions of ooSQLite I will certainly exercise them, although I might not be able to build them. -----Original Message----- From: Mark Miesfeld [mailto:[email protected]] Sent: Monday, June 04, 2012 07:11 To: Open Object Rexx Developer Mailing List Subject: Re: [Oorexx-devel] Some comments on the ooSQLLite extension On Mon, Jun 4, 2012 at 4:47 AM, Lee Peedin <[email protected]> wrote: > Mark, lets assume your table structure is something like: > firstname > lastname > address > city > state > zip > > Now lets assume your sql query was simply: > select * from table > > Both your and Jon's query would work fine UNTIL the point where it's > determined that we now need a middleinitial column between firstname > and lastname. The beauty of SQL is that column can be inserted and the integrity of the data is not harmed. > > HOWEVER, if your case of using an array of arrays, every statement in > every script that expected the lastname to be the 2nd column to be returned would have to now be changed to the 3rd column. That's a good point Lee. I'm not arguing against using an array of directories. I'm just saying that it this point, (since the array of arrays is already coded,) it would be just as easy to allow the user to specify how he wanted the result set returned. It could be an attribute of the database. After your and Jon's arguments, I would make the default an array of directories. Yours is a good point, I'm not saying it isn't. But, if your application was already coded, why wouldn't you add the new column at the end, column 6? > But, hey, what do I know. Probably a lot more than I do when it comes to databases. -- Mark Miesfeld ---------------------------------------------------------------------------- -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Oorexx-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/oorexx-devel ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Oorexx-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/oorexx-devel
